Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Entity Framework Join doubts with generated SQL
- Dim result = From p In DbContext.TblParent Join c In DbContext.TblChilds _
- On c.idparent Equals p.id Where c.field1 = 1 And c.field2 = 2 Select p
- Dim result = From p In DbContext.TblParent From c In p.TblChilds Where c.field1 = 1 And c.field2 = 2 Select p
- SELECT
- [Extent1].[id] AS [id],
- [Extent1].[field1] AS [field1],
- [Extent1].[field2] AS [field2],
- [Extent2].[field1] AS [field1],
- [Extent2].[field2] AS [field2],
- [Extent2].[idparent] AS [idparent]
- FROM [dbo].[TblParent] AS [Extent1]
- INNER JOIN (SELECT
- [TblChilds].[field1] AS [field1],
- [TblChilds].[field2] AS [field2],
- [TblChilds].[idparent] AS [idparent]
- FROM [dbo].[TblChilds] AS [TblChilds]) AS [Extent2] ON [Extent1].[id] = [Extent2].[idparent]
- WHERE ([Extent2].[field1] = 1) AND ([Extent2].[field2] = 2)
Add Comment
Please, Sign In to add comment