using ServiceStack;

using ServiceStack.OrmLite;

using ServiceStack.DataAnnotations;

​

var dbFactory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);

​

using var db = dbFactory.Open();

​

db.CreateTable<Record>();

for (int i = 0; i < 100; i++)

{

    db.Insert(new Record

    {

        Name = $"Name {i}" ,

        CreatedBy =  "TEST",

        ModifiedBy = "TEST",

        CreatedDate = DateTime.Now,

        ModifiedDate = DateTime.Now

    });

}

​

var sw = new Stopwatch();

sw.Start();

​

var records = db.Select<Record>();

​

var loadTime = sw.ElapsedMilliseconds;

Console.WriteLine($"Took {loadTime}ms to load {records.Count} records");

​

public class Record : AuditBase

{

    [PrimaryKey]

    [AutoIncrement]

    public int Id { get; set; }

    public string Name { get; set; }

}

​