Mego开发文档 - 复杂查询
复杂查询
Mego 还支持一些更高级的LLINQ查询写法,本文只列出一部分。
分组汇总查询
using (var db = neOrderManageEntities())
{
var query = from a in db.Products
group a by a.Category into g
select new
{
g.Key,
Count = g.Count(),
Max = g.Max(a => a.Id)
};
var data = query.ToArray();
}
分组查询及分页
using (var db = new OrderManageEntities())
{
var query = (from a in db.Products
group a by a.Category into g
select new
{
g.Key,
List = g
})
.Skip(2).Take(2);
var data = query.ToArray();
}
连接分组查询
using (var db = new OrderManageEntities())
{
var query = from a in db.Orders
join b in db.OrderDetails on a.Id equals b.OrderId into g
select new
{
Order = a,
MaxId = g.Max(m => m.Id)
};
var data = query.ToArray();
}
连接分组查询及分页
using (var db = new OrderManageEntities())
{
var query = (from a in db.Orders
join b in db.OrderDetails on a.Id equals b.OrderId into g
select new
{
Order = a,
List = g
})
.Skip(5).Take(5);
var data = query.ToArray();
}
声明:一个新的技术或框架出现后还是需要时间的沉淀,我个人觉的至少需要半年以上的时间,所以请暂时不要将该框架应用到你觉的重要的系统中。不过也请大家可以多多试用,帮助Mego可以快速成长,感谢各位的问题及意见反馈。