|
SELECT
[Project1].[Id] AS [Id],
[Project1].[AdSoyad] AS [AdSoyad],
[Project1].[EMail] AS [EMail],
[Project1].[C1] AS [C1],
[Project1].[Id1] AS [Id1],
[Project1].[YazarId] AS [YazarId],
[Project1].[Tanim] AS [Tanim],
[Project1].[Aciklama] AS [Aciklama],
[Project1].[Detay] AS [Detay]
FROM ( SELECT
[Extent1].[Id] AS [Id],
[Extent1].[AdSoyad] AS [AdSoyad],
[Extent1].[EMail] AS [EMail],
[Extent2].[Id] AS [Id1],
[Extent2].[YazarId] AS [YazarId],
[Extent2].[Tanim] AS [Tanim],
[Extent2].[Aciklama] AS [Aciklama],
[Extent2].[Detay] AS [Detay],
CASE WHEN ([Extent2].[Id] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1]
FROM [dbo].[Yazar] AS [Extent1]
LEFT OUTER JOIN [dbo].[Makale] AS [Extent2] ON [Extent1].[Id] = [Extent2].[YazarId]
WHERE 1 = [Extent1].[Id]
) AS [Project1]
ORDER BY [Project1].[Id] ASC, [Project1].[C1] ASC
|