data-access

example-queries\Author.cs

public class Author
{
    public Author(){}
    [AutoIncrement]
    [Alias("AuthorID")]
    public Int32 Id { get; set;}
    [Index(Unique = true)]
    [StringLength(40)]
    public string Name { get; set;}
    public DateTime Birthday { get; set;}
    public DateTime ? LastActivity  { get; set;}
    public Decimal? Earnings { get; set;}  
    public bool Active { get; set; } 
    [StringLength(80)]
    [Alias("JobCity")]
    public string City { get; set;}
    [StringLength(80)]
    [Alias("Comment")]
    public string Comments { get; set;}
    public Int16 Rate { get; set;}
}

example-queries\QueryExamples.cs

var dbFactory = HostContext.Resolve<IDbConnectionFactory>();
using var db = dbFactory.OpenDbConnection();

int agesAgo = DateTime.Today.AddYears(-20).Year;
db.Select<Author>(x => x.Birthday >= new DateTime(agesAgo, 1, 1) 
                    && x.Birthday <= new DateTime(agesAgo, 12, 31));
                    
db.Select<Author>(x => Sql.In(x.City, "London", "Madrid", "Berlin"));

db.Select<Author>(x => x.Earnings <= 50);

db.Select<Author>(x => x.Name.StartsWith("A"));

db.Select<Author>(x => x.Name.EndsWith("garzon"));

db.Select<Author>(x => x.Name.Contains("Benedict"));

//impicit string casting
db.Select<Author>(x => x.Rate.ToString() == "10"); 

//server string concatenation
db.Select<Author>(x => "Rate " + x.Rate == "Rate 10"); 

supported-dbs\AppHost.cs

public class AppHost : AppHostBase
{
    public AppHost() : base("Web",typeof(MyServices).Assembly){}

    public override void Configure(Container container)
    {
        var connectionString =
            "Server=127.0.0.1;Port=5432;" +
            "Database=host;User Id=user;" +
            "Password=myPassword;";
            
        container.Register<IDbConnectionFactory>(
            new OrmLiteConnectionFactory(
                connectionString,
                PostgreSqlDialect.Provider));
    }
}