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;}
}

QueryExamples.cs

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

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

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"));

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

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