Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ServiceStack.OrmLite;
using ServiceStack.OrmLite.Sqlite;
using System.Data;
using ServiceStack.Common.Utils;

namespace OrmLiteExample
{
    class Program
    {
        // Updated using excellent feedback from Demis Bellot
        public static string SqliteMemoryDb = ":memory:";
        public static string SqliteFileDb = "~/App_Data/db.sqlite".MapAbsolutePath();

        static void Main(string[] args)
        {
            //Using Sqlite DB
            var dbFactory = new OrmLiteConnectionFactory(
                SqliteFileDb, false, SqliteDialect.Provider);

            using (var db = dbFactory.Open()) {

                db.CreateTableIfNotExists<Note>();

                // Insert
                db.Insert(
                    new Note { 
                        SchemaUri = "tcm:0-0-0", 
                        NoteText = "Hello world 5", 
                        LastUpdated = new DateTime(2013, 1, 5), 
                        UpdatedBy = "RC" });

                // Read
                var notes = db.Where<Note>(new { SchemaUri = "tcm:0-0-0" });
                foreach (Note note in notes)
                {
                    Console.WriteLine("note id=" + note.Id + "noteText=" + note.NoteText);
                }
            }
            Console.ReadLine();
        }
    }
}