本文介绍了如何在Linq中使用SQL查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨!
我曾在面试中出现过,要求我写一个我设法写的查询,然后被要求在Linq中写同样的查询,但我不能.请引导我.查询如下:
Hi!
I had appeared in interview where i was asked to write a query which i managed to write then i was asked to write same query in Linq but i couln''t . Plz guide me. The query is given below;
select c.CustomerId,c.CustomerName, sum(o.OrderAmount) as ''Total Amount'' from Customer c join [Order] o on c.CustomerId = o.CustomerId group by c.CustomerId, c.CustomerName
推荐答案
这篇关于如何在Linq中使用SQL查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!