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)