Basic select statement, any order is allowed

varcmd=newToDBCommand();cmd.From("Order").Select("OrderNumber","OrderId").Where(where=>where.AreEqual("OrderType","@OrderType"));if(getMoreInfo){cmd.Select("OrderDescription,OrderName");}stringsql=cmd.ToSql();

select OrderNumber,OrderId,OrderDescription,OrderNamefrom Orderwhere OrderType=@OrderType

Join

cmd.SelectAllFrom("Order").InnerJoin("Customer", on=>on.AreEqual("Order.CustomerId","Customer.CustomerId").And().AreEqual("Order.RegionId","Customer.RegionId"));

select*from Orderinner join CustomeronOrder.CustomerId=Customer.CustomerIdandOrder.RegionId=Customer.RegionId

How lucky, our model matches our database schema

varparameters=new{CompanyId=5};cmd.SelectFrom<Company>().Where(where=>where.IsEqual(()=>parameters.CompanyId));

select CompanyId,CompanyNamefrom Companywhere CompanyId=@CompanyId

Complex queries

cmd.From("Product").Select("OrderNumber").Select(subQuery=>subQuery.Select("sum(Price)").From("Product"),"Total").Where(where=>where.IsEqual(()=>parameters.CustomerId).And(either=>either.IsGreaterOrEqual(()=>parameters.MinimumOder).Or().IsEqual(()=>parameters.IsVeryImportant)));

select OrderNumber,(selectsum(Price)from Product) Totalfrom Productwhere CustomerId=@CustomerIdand (MinimumOrder>=@MinimumOrderor IsVeryImportant=@IsVeryImportant)