SqlSharp 1.0.2

Generate SqlQuery for your type/object dynamically.

  ============  Query builder example:   ===============

  using SqlSharp;
  using SqlSharp.Query;

  SharpQuery select = SharpQuery
  .Select()
  .Field("Id").As("AccountId") // with alias
  .Field("AccountNumber") //name only
  .Where("account.created", Compare.GreaterThanEqual, "'2018-01-01'") //where clause
  .TopN(100)
  .From("account"); //table

  // sql output
  var sqlQuery = QueryHelper.GetSqlOutput(select);




  ===========   Generate Select dynamically =============
  //Query With Alias:

  // Add a class, Define column name with optional attribute, property name is used as Alias
  public class Account
  {
  [SqlSharp("Account.Id")] // column name
  public string AccountId { get; set; } // alias

  public string AccountNumber { get; set; }

  }

  // generate query:

  Account a = new Account();
  var fields = QueryHelper.GetSelects<Account>(a);


    SharpQuery select = SharpQuery
    .Select()
    .Fields(fields.ToArray())
    .Where("account.created", Compare.GreaterThanEqual, "'2018-01-01'")
    .TopN(100)
    .From("account");


    var sqlOutput = QueryHelper.GetSqlOutput(select);