[C#/COMMON/SQLITE] In-Memory 데이터베이스 사용하기

■ In-Memory 데이터베이스를 사용하는 방법을 보여준다.

▶ 예제 코드 (C#)


using System;
using System.Data.SQLite;

string connectionString = "Data Source=:memory:";

SQLiteConnection sqliteConnection = null;
SQLiteCommand    sqliteCommand    = null;

try
{
    sqliteConnection = new SQLiteConnection(connectionString);

    sqliteConnection.Open();

    string sql = "SELECT SQLITE_VERSION()";

    sqliteCommand = new SQLiteCommand(sql, sqliteConnection);

    string version = sqliteCommand.ExecuteScalar().ToString();

    Console.WriteLine("SQLite version : {0}", version);
}
catch(SQLiteException sqliteException)
{
    Console.WriteLine("Error: {0}", sqliteException.ToString());
}
finally
{
    if(sqliteCommand != null)
    {
        sqliteCommand.Dispose();
    }

    if(sqliteConnection != null)
    {
        try
        {
            sqliteConnection.Close();
        }
        catch(SQLiteException sqliteException)
        {
            Console.WriteLine("Closing connection failed.");
            Console.WriteLine("Error: {0}", sqliteException.ToString());
        }
        finally
        {
            sqliteConnection.Dispose();
        }
    }
}

using System;

using System.Data.SQLite;

string connectionString = "Data Source=:memory:";

SQLiteConnection sqliteConnection = null;

SQLiteCommand sqliteCommand = null;

try

{

sqliteConnection = new SQLiteConnection(connectionString);

sqliteConnection.Open();

string sql = "SELECT SQLITE_VERSION()";

sqliteCommand = new SQLiteCommand(sql, sqliteConnection);

string version = sqliteCommand.ExecuteScalar().ToString();

Console.WriteLine("SQLite version : {0}", version);

}

catch(SQLiteException sqliteException)

{

Console.WriteLine("Error: {0}", sqliteException.ToString());

}

finally

{

if(sqliteCommand != null)

{

sqliteCommand.Dispose();

}

if(sqliteConnection != null)

{

try

{

sqliteConnection.Close();

}

catch(SQLiteException sqliteException)

{

Console.WriteLine("Closing connection failed.");

Console.WriteLine("Error: {0}", sqliteException.ToString());

}

finally

{

sqliteConnection.Dispose();

}