public void SimpleTest() { string sql = @"SELECT TOP 10 * FROM fei_users"; using (var context = new SkyDbContext()) { var results = context.Query <FeiUsers>(sql); } }
public void JoinPagingTest() { string sql = @"SELECT x.* FROM fei_users x INNER JOIN fei_userdetails y ON x.uid = y.uid WHERE x.userstatus = 1"; using (var context = new SkyDbContext()) { var results = context.Query <FeiUsers>(sql, 0, 10); } }