Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Generated SQL for `.FirstOrDefault()` (for http://stackoverflow.com/questions/12138353/)
SELECT
[Project4].[ID] AS [ID],
[Project4].[C1] AS [C1],
[Project4].[AuthorID] AS [AuthorID],
[Project4].[Title] AS [Title],
[Project4].[Revision] AS [Revision],
[Project4].[CreatedUTC] AS [CreatedUTC],
[Project4].[Body] AS [Body]
FROM ( SELECT
[Filter1].[ID] AS [ID],
[Apply1].[AuthorID] AS [AuthorID],
[Apply1].[Title1] AS [Title],
[Apply1].[Revision] AS [Revision],
[Apply1].[CreatedUTC] AS [CreatedUTC],
[Apply1].[Body] AS [Body],
CASE WHEN ([Apply1].[Title2] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1]
FROM (SELECT [Extent1].[ID] AS [ID]
FROM [dbo].[Authors] AS [Extent1]
WHERE [Extent1].[Name] LIKE N'John%' ) AS [Filter1]
OUTER APPLY (SELECT [Project2].[Title] AS [Title2], [Limit1].[AuthorID] AS [AuthorID], [Limit1].[Title] AS [Title1], [Limit1].[Revision] AS [Revision], [Limit1].[CreatedUTC] AS [CreatedUTC], [Limit1].[Body] AS [Body]
FROM (SELECT
[Filter1].[ID] AS [ID],
[Distinct1].[Title] AS [Title]
FROM ( SELECT DISTINCT
[Extent2].[Title] AS [Title]
FROM [dbo].[Articles] AS [Extent2]
WHERE [Filter1].[ID] = [Extent2].[AuthorID]
) AS [Distinct1] ) AS [Project2]
OUTER APPLY (SELECT TOP (1) [Project3].[AuthorID] AS [AuthorID], [Project3].[Title] AS [Title], [Project3].[Revision] AS [Revision], [Project3].[CreatedUTC] AS [CreatedUTC], [Project3].[Body] AS [Body]
FROM ( SELECT
[Extent3].[AuthorID] AS [AuthorID],
[Extent3].[Title] AS [Title],
[Extent3].[Revision] AS [Revision],
[Extent3].[CreatedUTC] AS [CreatedUTC],
[Extent3].[Body] AS [Body]
FROM [dbo].[Articles] AS [Extent3]
WHERE ([Project2].[ID] = [Extent3].[AuthorID]) AND ([Project2].[Title] = [Extent3].[Title])
) AS [Project3]
ORDER BY [Project3].[Revision] DESC ) AS [Limit1] ) AS [Apply1]
) AS [Project4]
ORDER BY [Project4].[ID] ASC, [Project4].[C1] ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.