查询表达式点符号
问题描述:
喜,需要一些帮助来此LINQ查询转换为点记号:查询表达式点符号
var productions =
from row in data
group row by row.PRODUCTION_NAME into gr
select new
{
Group = gr.Key,
Jobs = from row in gr
orderby row.SortFieldCard
group row by row.JOB_NAME into job
select new { job.Key, Cards = job }
};
答
var productions = data
.GroupBy(row => row.PRODUCTION_NAME)
.Select(gr => new
{
Group = gr.Key,
Jobs = gr
.OrderBy(row => row.SortFieldCard)
.GroupBy(row => row.JOB_NAME)
.Select(job => new { job.Key, Cards = job })
});
答
嘛。如果你的意思是Linq的流利表示法(你说的“dot net”,并且都是dot net(.NET)),我认为这应该有效:
var productions = data
.GroupBy(row => row.PRODUCTION_NAME)
.Select(gr => new {
Group = gr.Key,
Jobs = gr
.OrderBy(row => row.SortFieldCard)
.GroupBy(row => row.JOB_NAME)
.Select(job => new { job.Key, Cards = job})
});
to sql you mean? – ariel 2011-05-19 07:17:15