void TestLong()
{
Select sel = Qb.Select("*")
.From("tab")
.Where(Cond.Equal("col", DateTime.Now.Ticks));
AnyDbFactory factory = new AnyDbFactory(new AnyDbSetting());
string sql = factory.GetSql(sel);
Update upd = Qb.Update("tab")
.Values(
Value.New("col", DateTime.Now.Ticks)
);
sql = factory.GetSql(upd);
}
public void GetPageSqlTest()
{
Select sel = Qb.Select("*")
.From("customer").OrderBy("id").Page(1, 10);
string sql = _factory.GetSql(sel);
using (AnyDbConnection con = _factory.OpenConnection())
{
var res = con.Query(sel);
Assert.Equal(10, res.Count());
}
}
