Simple OrmLite CRUD demo

main.cs

using System;
using System.Collections.Generic;
using ServiceStack;
using ServiceStack.Text;
using ServiceStack.OrmLite;
using ServiceStack.OrmLite.Sqlite;
using ServiceStack.DataAnnotations;

public class User
{
    public long Id { get; set; }
    
    [Index]
    public string Name { get; set; }
    public DateTime CreatedDate { get; set; }
    public override string ToString() => Name;
}

var dbFactory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);
var db = dbFactory.Open();     //Open ADO.NET DB Connection

db.DropAndCreateTable<User>(); //DROP (if exist) and CREATE Table from User POCO

db.Insert(                     //INSERT multiple Users by params
    new User { Id = 1, Name = "A", CreatedDate = DateTime.Now },
    new User { Id = 2, Name = "B", CreatedDate = DateTime.Now },
    new User { Id = 3, Name = "C", CreatedDate = DateTime.Now },
    new User { Id = 4, Name = "C", CreatedDate = DateTime.Now });

var rowsA = db.SqlList<User>("SELECT * FROM User", new {Arg1 = "whatever"});
rowsA.PrintDump();                         
Inspect.vars(new { rowsA });

packages.config

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="System.Memory" version="4.5.4" targetFramework="net45" />
  <package id="ServiceStack.Text" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.Client" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.Common" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.Interfaces" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.OrmLite" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.OrmLite.Sqlite.Windows" version="5.10.0" targetFramework="net45" />
</packages>