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