dbcontext.tableName.Where("columnName=?", varname).OrderBy("Name DESC, Id").List()
.Send(function(results} {
handler(results);
}
);
dbcontext.tableName.Join("Address, Profile b").Where("b.Name=? and Address.Id=?", varname, variid)
.OrderBy("Name DESC, Id").Limit(0, 10).PagingJsons("b.Name, Address.PostCode, Id")
.Send(function(results} {
handler(results);
}
);