string createTableQuery = @"CREATE TABLE IF NOT EXISTS [MyTable] ( [ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Key] NVARCHAR(2048) NULL, [Value] VARCHAR(2048) NULL )"; { { con.Open(); com.CommandText = createTableQuery; com.ExecuteNonQuery(); com.CommandText = "INSERT INTO MyTable (Key,Value) Values ('key one','value one')"; com.ExecuteNonQuery(); com.CommandText = "INSERT INTO MyTable (Key,Value) Values ('key two','value value')"; com.ExecuteNonQuery(); com.CommandText = "Select * FROM MyTable"; { while (reader.Read()) { Console.WriteLine(reader["Key"] + " : " + reader["Value"]); } } con.Close(); } }