有人知道如何将以下SQL查询转换为可以在Odata上运行的查询吗?
SELECT FirstName, LastName, MobileNo, COUNT(1) as CNT
FROM CUSTOMER
GROUP BY FirstName, LastName, MobileNo;
谢谢!
有人知道如何将以下SQL查询转换为可以在Odata上运行的查询吗?
SELECT FirstName, LastName, MobileNo, COUNT(1) as CNT
FROM CUSTOMER
GROUP BY FirstName, LastName, MobileNo;
谢谢!
var values = from i in CUSTOMER
group i by new
{
i.FirstName,
i.LastName,
i.MobileNo
} into g
select new
{
g.Key.FirstName,
g.Key.LastName,
g.Key.MobileNo,
COUNT = g.Count()
};