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