![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
linq-to-sql
易兒善
坚持终身学习,遇见更好的自己
展开
-
Linq语句实现(INNER JOIN、LEFT OUTER JOIN、RIGHT OUTER JOIN、FULL OUTER JOIN、CROSS JOIN)
首先建立三张表如下:分别加入数据如下:内连接 INNER JOINsql:SELECT [t0].[Id], [t0].[Name], [t1].[GroupName], [t2].[Salary] AS [Content]FROM [User] AS [t0]INNER JOIN [Group] AS [t1] ON [t0].[GroupId] = ([t1].[Id])INNER JOI原创 2017-06-01 14:12:01 · 4444 阅读 · 0 评论 -
linq join on 多条件
借助于匿名类型:和解决按多条件分组的思路相同。from c in CustomerLegalOrgsjoin ao in AccountingOrganizationConfigs on c.OrganizationId equals ao.OrganizationIdjoin ac in AccountingCustomerConfigs on c.CustomerLegalId equals原创 2017-07-13 09:17:25 · 1699 阅读 · 0 评论