(@p__linq__0 int,@p__linq__1 uniqueidentifier,@p__linq__2 nvarchar(4000),@p__linq__3 nvarchar(4000),@p__linq__5 nvarchar(4000),@p__linq__4 nvarchar(4000),@p__linq__6 nvarchar(4000),@p__linq__7 nvarchar(4000),@p__linq__8 nvarchar(4000),@p__linq__9 nvarchar(4000),@p__linq__10 nvarchar(4000),@p__linq__11 nvarchar(4000),@p__linq__12 nvarchar(4000),@p__linq__13 nvarchar(4000),@p__linq__14 nvarchar(4000),@p__linq__15 nvarchar(4000),@p__linq__16 uniqueidentifier,@p__linq__17 uniqueidentifier,@p__linq__18 uniqueidentifier,@p__linq__19 uniqueidentifier,@p__linq__20 uniqueidentifier)
SELECT
[UnionAll8].[Id] AS [C1],
[UnionAll8].[Id1] AS [C2],
[UnionAll8].[Id2] AS [C3],
[UnionAll8].[Id3] AS [C4],
[UnionAll8].[Id4] AS [C5],
[UnionAll8].[Id5] AS [C6],
[UnionAll8].[Id6] AS [C7],
[UnionAll8].[Id7] AS [C8],
[UnionAll8].[Id8] AS [C9],
[UnionAll8].[C2] AS [C10],
[UnionAll8].[Number] AS [C11],
[UnionAll8].[C3] AS [C12],
[UnionAll8].[C4] AS [C13],
[UnionAll8].[C5] AS [C14],
[UnionAll8].[C6] AS [C15],
[UnionAll8].[C7] AS [C16],
[UnionAll8].[C8] AS [C17],
[UnionAll8].[C9] AS [C18],
[UnionAll8].[C10] AS [C19],
[UnionAll8].[Number1] AS [C20],
[UnionAll8].[C11] AS [C21],
[UnionAll8].[Value] AS [C22],
[UnionAll8].[C12] AS [C23],
[UnionAll8].[Value1] AS [C24],
[UnionAll8].[C13] AS [C25],
[UnionAll8].[C14] AS [C26],
[UnionAll8].[Number2] AS [C27],
[UnionAll8].[Number3] AS [C28],
[UnionAll8].[FirstName] AS [C29],
[UnionAll8].[MiddleName] AS [C30],
[UnionAll8].[LastName] AS [C31],
[UnionAll8].[C15] AS [C32],
[UnionAll8].[C16] AS [C33],
[UnionAll8].[BirthDate] AS [C34],
[UnionAll8].[C17] AS [C35],
[UnionAll8].[C18] AS [C36],
[UnionAll8].[C1] AS [C37],
[UnionAll8].[C19] AS [C38],
[UnionAll8].[BirthDate1] AS [C39],
[UnionAll8].[C20] AS [C40],
[UnionAll8].[FirstName1] AS [C41],
[UnionAll8].[LastName1] AS [C42],
[UnionAll8].[C21] AS [C43],
[UnionAll8].[C22] AS [C44],
[UnionAll8].[C23] AS [C45],
[UnionAll8].[C24] AS [C46],
[UnionAll8].[C25] AS [C47],
[UnionAll8].[C26] AS [C48],
[UnionAll8].[C27] AS [C49],
[UnionAll8].[C28] AS [C50],
[UnionAll8].[C29] AS [C51],
[UnionAll8].[C30] AS [C52],
[UnionAll8].[C31] AS [C53],
[UnionAll8].[C32] AS [C54],
[UnionAll8].[C33] AS [C55],
[UnionAll8].[C34] AS [C56],
[UnionAll8].[C35] AS [C57],
[UnionAll8].[C36] AS [C58],
[UnionAll8].[C37] AS [C59],
[UnionAll8].[C38] AS [C60],
[UnionAll8].[C39] AS [C61],
[UnionAll8].[C40] AS [C62],
[UnionAll8].[C41] AS [C63],
[UnionAll8].[C42] AS [C64],
[UnionAll8].[C43] AS [C65],
[UnionAll8].[C44] AS [C66],
[UnionAll8].[C45] AS [C67],
[UnionAll8].[C46] AS [C68],
[UnionAll8].[C47] AS [C69],
[UnionAll8].[C48] AS [C70],
[UnionAll8].[C49] AS [C71],
[UnionAll8].[C50] AS [C72],
[UnionAll8].[C51] AS [C73],
[UnionAll8].[C52] AS [C74],
[UnionAll8].[C53] AS [C75],
[UnionAll8].[C54] AS [C76],
[UnionAll8].[C55] AS [C77],
[UnionAll8].[C56] AS [C78],
[UnionAll8].[C57] AS [C79],
[UnionAll8].[C58] AS [C80],
[UnionAll8].[C59] AS [C81],
[UnionAll8].[C60] AS [C82],
[UnionAll8].[C61] AS [C83],
[UnionAll8].[C62] AS [C84],
[UnionAll8].[C63] AS [C85],
[UnionAll8].[C64] AS [C86],
[UnionAll8].[C65] AS [C87],
[UnionAll8].[C66] AS [C88],
[UnionAll8].[C67] AS [C89]
FROM (SELECT
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1],
[Project12].[Id1] AS [Id],
[Project12].[Id2] AS [Id1],
[Project12].[Id3] AS [Id2],
[Project12].[Id4] AS [Id3],
[Project12].[Id5] AS [Id4],
[Project12].[Id6] AS [Id5],
[Project12].[Id7] AS [Id6],
[Project12].[Id8] AS [Id7],
[Project12].[Id] AS [Id8],
[Project12].[C2] AS [C2],
[Project12].[Number] AS [Number],
CASE WHEN ([Project12].[isDeleted] = 1) THEN N'Delete' ELSE N'Insert' END AS [C3],
N'DE' AS [C4],
@p__linq__6 AS [C5],
N'Individual' AS [C6],
@p__linq__7 AS [C7],
@p__linq__8 AS [C8],
CASE WHEN ([Project12].[isDeleted] = 1) THEN N'Inactive' ELSE N'Active' END AS [C9],
[Project12].[C1] AS [C10],
[Project12].[Number] AS [Number1],
CASE WHEN ([Project12].[Value] IS NOT NULL) THEN N'STO' END AS [C11],
[Project12].[Value] AS [Value],
CASE WHEN ([Project12].[Value1] IS NOT NULL) THEN N'STO' END AS [C12],
[Project12].[Value1] AS [Value1],
CAST( [Project12].[CreateDate] AS datetime2) AS [C13],
CAST( [Project12].[LastChange] AS datetime2) AS [C14],
[Project12].[Number] AS [Number2],
[Project12].[Number] AS [Number3],
[Project12].[FirstName] AS [FirstName],
[Project12].[MiddleName] AS [MiddleName],
[Project12].[LastName] AS [LastName],
CASE WHEN (N'F' = [Project12].[Gender]) THEN N'FEMALE' WHEN (N'M' = [Project12].[Gender]) THEN N'MALE' ELSE N'NOTSET' END AS [C15],
CASE WHEN (@p__linq__9 = N'AT' OR [Project12].[Title] IN (N'Dr.',N'Prof.',N'Prof. Dr.')) THEN [Project12].[Title] END AS [C16],
[Project12].[BirthDate] AS [BirthDate],
CAST( [Project12].[CreateDate] AS datetime2) AS [C17],
CAST( [Project12].[LastChange] AS datetime2) AS [C18],
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C19],
[Join7].[BirthDate] AS [BirthDate1],
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS varchar(1)) WHEN (N'M' = [Join7].[Gender]) THEN N'MALE' WHEN (N'F' = [Join7].[Gender]) THEN N'FEMALE' ELSE N'NOTSET' END AS [C20],
[Join7].[FirstName] AS [FirstName1],
[Join7].[LastName] AS [LastName1],
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS datetime2) ELSE CAST( [Join7].[LastChange] AS datetime2) END AS [C21],
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS datetime2) ELSE CAST( [Join7].[CreateDate] AS datetime2) END AS [C22],
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS varchar(1)) WHEN ([Join7].[BirthDate] IS NOT NULL) THEN CAST( DATEPART (year, [Join7].[BirthDate]) AS nvarchar(max)) END AS [C23],
CASE WHEN ([Join7].[FK_CustomerId] IS NULL) THEN CAST(NULL AS varchar(1)) ELSE N'UNKNOWN' END AS [C24],
CAST(NULL AS uniqueidentifier) AS [C25],
CAST(NULL AS uniqueidentifier) AS [C26],
CAST(NULL AS int) AS [C27],
CAST(NULL AS varchar(1)) AS [C28],
CAST(NULL AS varchar(1)) AS [C29],
CAST(NULL AS varchar(1)) AS [C30],
CAST(NULL AS varchar(1)) AS [C31],
CAST(NULL AS varchar(1)) AS [C32],
CAST(NULL AS varchar(1)) AS [C33],
CAST(NULL AS varchar(1)) AS [C34],
CAST(NULL AS varchar(1)) AS [C35],
CAST(NULL AS datetime2) AS [C36],
CAST(NULL AS datetime2) AS [C37],
CAST(NULL AS uniqueidentifier) AS [C38],
CAST(NULL AS uniqueidentifier) AS [C39],
CAST(NULL AS int) AS [C40],
CAST(NULL AS int) AS [C41],
CAST(NULL AS varchar(1)) AS [C42],
CAST(NULL AS datetime2) AS [C43],
CAST(NULL AS datetime2) AS [C44],
CAST(NULL AS int) AS [C45],
CAST(NULL AS varchar(1)) AS [C46],
CAST(NULL AS varchar(1)) AS [C47],
CAST(NULL AS datetime2) AS [C48],
CAST(NULL AS datetime2) AS [C49],
CAST(NULL AS int) AS [C50],
CAST(NULL AS varchar(1)) AS [C51],
CAST(NULL AS varchar(1)) AS [C52],
CAST(NULL AS datetime2) AS [C53],
CAST(NULL AS datetime2) AS [C54],
CAST(NULL AS int) AS [C55],
CAST(NULL AS int) AS [C56],
CAST(NULL AS varchar(1)) AS [C57],
CAST(NULL AS datetime2) AS [C58],
CAST(NULL AS datetime2) AS [C59],
CAST(NULL AS int) AS [C60],
CAST(NULL AS varchar(1)) AS [C61],
CAST(NULL AS varchar(1)) AS [C62],
CAST(NULL AS int) AS [C63],
CAST(NULL AS varchar(1)) AS [C64],
CAST(NULL AS varchar(1)) AS [C65],
CAST(NULL AS datetime2) AS [C66],
CAST(NULL AS datetime2) AS [C67]
FROM (SELECT
[Project10].[Id] AS [Id],
[Project10].[Number] AS [Number],
[Project10].[FirstName] AS [FirstName],
[Project10].[MiddleName] AS [MiddleName],
[Project10].[LastName] AS [LastName],
[Project10].[Gender] AS [Gender],
[Project10].[Title] AS [Title],
[Project10].[BirthDate] AS [BirthDate],
[Project10].[isDeleted] AS [isDeleted],
[Project10].[CreateDate] AS [CreateDate],
[Project10].[LastChange] AS [LastChange],
[Project10].[Id1] AS [Id1],
[Project10].[Id2] AS [Id2],
[Project10].[Id3] AS [Id3],
[Project10].[Value] AS [Value],
[Project10].[Id4] AS [Id4],
[Project10].[Id5] AS [Id5],
[Project10].[Id6] AS [Id6],
[Project10].[Value1] AS [Value1],
[Project10].[Id7] AS [Id7],
[Project10].[Id8] AS [Id8],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CustomerParameter] AS [Extent11]
INNER JOIN [dbo].[Parameter] AS [Extent12] ON [Extent11].[FK_ParameterId] = [Extent12].[Id]
WHERE ([Project10].[Id] = [Extent11].[FK_CustomerId]) AND ([Extent12]. = @p__linq__4) )) THEN [Project10].[CustomValue] END AS [C1], [Project10].[C1] AS [C2] FROM ( SELECT [Project8].[Id] AS [Id], [Project8].[Number] AS [Number], [Project8].[FirstName] AS [FirstName], [Project8].[MiddleName] AS [MiddleName], [Project8].[LastName] AS [LastName], [Project8].[Gender] AS [Gender], [Project8].[Title] AS [Title], [Project8].[BirthDate] AS [BirthDate], [Project8].[isDeleted] AS [isDeleted], [Project8].[CreateDate] AS [CreateDate], [Project8].[LastChange] AS [LastChange], [Project8].[Id1] AS [Id1], [Project8].[Id2] AS [Id2], [Project8].[Id3] AS [Id3], [Project8].[Value] AS [Value], [Project8].[Id4] AS [Id4], [Project8].[Id5] AS [Id5], [Project8].[Id6] AS [Id6], [Project8].[Value1] AS [Value1], [Limit4].[Id] AS [Id7], [Limit4].[CustomValue] AS [CustomValue], [Limit4].[Id1] AS [Id8], [Project8].[C1] AS [C1] FROM (SELECT [Project6].[Id] AS [Id], [Project6].[Number] AS [Number], [Project6].[FirstName] AS [FirstName], [Project6].[MiddleName] AS [MiddleName], [Project6].[LastName] AS [LastName], [Project6].[Gender] AS [Gender], [Project6].[Title] AS [Title], [Project6].[BirthDate] AS [BirthDate], [Project6].[isDeleted] AS [isDeleted], [Project6].[CreateDate] AS [CreateDate], [Project6].[LastChange] AS [LastChange], [Project6].[Id1] AS [Id1], [Project6].[Id2] AS [Id2], [Project6].[Id3] AS [Id3], [Project6].[Value] AS [Value], [Limit3].[Id] AS [Id4], [Limit3].[Id1] AS [Id5], [Limit3].[Id2] AS [Id6], [Limit3].[Value] AS [Value1], [Project6].[C1] AS [C1] FROM (SELECT [Project4].[Id] AS [Id], [Project4].[Number] AS [Number], [Project4].[FirstName] AS [FirstName], [Project4].[MiddleName] AS [MiddleName], [Project4].[LastName] AS [LastName], [Project4].[Gender] AS [Gender], [Project4].[Title] AS [Title], [Project4].[BirthDate] AS [BirthDate], [Project4].[isDeleted] AS [isDeleted], [Project4].[CreateDate] AS [CreateDate], [Project4].[LastChange] AS [LastChange], [Limit2].[Id] AS [Id1], [Limit2].[Id1] AS [Id2], [Limit2].[Id2] AS [Id3], [Limit2].[Value] AS [Value], [Project4].[C1] AS [C1] FROM (SELECT [Project3].[Id] AS [Id], [Project3].[Number] AS [Number], [Project3].[FirstName] AS [FirstName], [Project3].[MiddleName] AS [MiddleName], [Project3].[LastName] AS [LastName], [Project3].[Gender] AS [Gender], [Project3].[Title] AS [Title], [Project3].[BirthDate] AS [BirthDate], [Project3].[isDeleted] AS [isDeleted], [Project3].[CreateDate] AS [CreateDate], [Project3].[LastChange] AS [LastChange], [Project3].[C1] AS [C1] FROM ( SELECT [Project1].[Id] AS [Id], [Project1].[Number] AS [Number], [Project1].[FirstName] AS [FirstName], [Project1].[MiddleName] AS [MiddleName], [Project1].[LastName] AS [LastName], [Project1].[Gender] AS [Gender], [Project1].[Title] AS [Title], [Project1].[BirthDate] AS [BirthDate], [Project1].[isDeleted] AS [isDeleted], [Project1].[CreateDate] AS [CreateDate], [Project1].[LastChange] AS [LastChange], (SELECT TOP (1) [Extent2].[Id] AS [Id] FROM [dbo].[CustomerProgram] AS [Extent2] WHERE (0 = [Extent2].[isDeleted]) AND ([Project1].[Id] = [Extent2].[FK_CustomerId]) AND (@p__linq__1 = [Extent2].[FK_ProgramId])) AS [C1] FROM ( SELECT [Extent1].[Id] AS [Id], [Extent1].[Number] AS [Number], [Extent1].[FirstName] AS [FirstName], [Extent1].[MiddleName] AS [MiddleName], [Extent1].[LastName] AS [LastName], [Extent1].[Gender] AS [Gender], [Extent1].[Title] AS [Title], [Extent1].[BirthDate] AS [BirthDate], [Extent1].[isDeleted] AS [isDeleted], [Extent1].[CreateDate] AS [CreateDate], [Extent1].[LastChange] AS [LastChange] FROM [dbo].[Customer] AS [Extent1] WHERE ( NOT (([Extent1].[isDeleted] = 1) AND (2 = @p__linq__0))) AND ([Extent1].[Id] IN (cast('08909057-84e7-4eb6-8c5b-580b4732c82a' as uniqueidentifier))) ) AS [Project1] ) AS [Project3] ) AS [Project4] OUTER APPLY (SELECT TOP (1) [Extent3].[Id] AS [Id], [Extent4].[Id] AS [Id1], [Extent5].[Id] AS [Id2], [Extent5].[Value] AS [Value] FROM [dbo].[CustomerParameter] AS [Extent3] INNER JOIN [dbo].[Parameter] AS [Extent4] ON [Extent3].[FK_ParameterId] = [Extent4].[Id] LEFT OUTER JOIN [dbo].[ParameterValue] AS [Extent5] ON [Extent3].[FK_ParameterValueId] = [Extent5].[Id] WHERE ([Project4].[Id] = [Extent3].[FK_CustomerId]) AND ([Extent4].[code] = @p__linq__2) ) AS [Limit2] ) AS [Project6] OUTER APPLY (SELECT TOP (1) [Extent6].[Id] AS [Id], [Extent7].[Id] AS [Id1], [Extent8].[Id] AS [Id2], [Extent8].[Value] AS [Value] FROM [dbo].[CustomerParameter] AS [Extent6] INNER JOIN [dbo].[Parameter] AS [Extent7] ON [Extent6].[FK_ParameterId] = [Extent7].[Id] LEFT OUTER JOIN [dbo].[ParameterValue] AS [Extent8] ON [Extent6].[FK_ParameterValueId] = [Extent8].[Id] WHERE ([Project6].[Id] = [Extent6].[FK_CustomerId]) AND ([Extent7].[code] = @p__linq__3) ) AS [Limit3] ) AS [Project8] OUTER APPLY (SELECT TOP (1) [Extent9].[Id] AS [Id], [Extent9].[FK_ParameterId] AS [FK_ParameterId], [Extent9].[CustomValue] AS [CustomValue], [Extent10].[Id] AS [Id1], [Extent10].[code] AS [code] FROM [dbo].[CustomerParameter] AS [Extent9] INNER JOIN [dbo].[Parameter] AS [Extent10] ON [Extent9].[FK_ParameterId] = [Extent10].[Id] WHERE ([Project8].[Id] = [Extent9].[FK_CustomerId]) AND ([Extent10].[code] = @p__linq__5) ) AS [Limit4] ) AS [Project10] ) AS [Project12] LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange] FROM [dbo].[Customer_CustomerChild] AS [Extent13] INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1) UNION ALL ещё одна портянка UNION ALL ещё одна портянка [/spoiler] Что называется "без комментариев" :-)[code] = @p__linq__4)
)) THEN [Project10].[CustomValue] END AS [C1],
[Project10].[C1] AS [C2]
FROM ( SELECT
[Project8].[Id] AS [Id],
[Project8].[Number] AS [Number],
[Project8].[FirstName] AS [FirstName],
[Project8].[MiddleName] AS [MiddleName],
[Project8].[LastName] AS [LastName],
[Project8].[Gender] AS [Gender],
[Project8].[Title] AS [Title],
[Project8].[BirthDate] AS [BirthDate],
[Project8].[isDeleted] AS [isDeleted],
[Project8].[CreateDate] AS [CreateDate],
[Project8].[LastChange] AS [LastChange],
[Project8].[Id1] AS [Id1],
[Project8].[Id2] AS [Id2],
[Project8].[Id3] AS [Id3],
[Project8].[Value] AS [Value],
[Project8].[Id4] AS [Id4],
[Project8].[Id5] AS [Id5],
[Project8].[Id6] AS [Id6],
[Project8].[Value1] AS [Value1],
[Limit4].[Id] AS [Id7],
[Limit4].[CustomValue] AS [CustomValue],
[Limit4].[Id1] AS [Id8],
[Project8].[C1] AS [C1]
FROM (SELECT
[Project6].[Id] AS [Id],
[Project6].[Number] AS [Number],
[Project6].[FirstName] AS [FirstName],
[Project6].[MiddleName] AS [MiddleName],
[Project6].[LastName] AS [LastName],
[Project6].[Gender] AS [Gender],
[Project6].[Title] AS [Title],
[Project6].[BirthDate] AS [BirthDate],
[Project6].[isDeleted] AS [isDeleted],
[Project6].[CreateDate] AS [CreateDate],
[Project6].[LastChange] AS [LastChange],
[Project6].[Id1] AS [Id1],
[Project6].[Id2] AS [Id2],
[Project6].[Id3] AS [Id3],
[Project6].[Value] AS [Value],
[Limit3].[Id] AS [Id4],
[Limit3].[Id1] AS [Id5],
[Limit3].[Id2] AS [Id6],
[Limit3].[Value] AS [Value1],
[Project6].[C1] AS [C1]
FROM (SELECT
[Project4].[Id] AS [Id],
[Project4].[Number] AS [Number],
[Project4].[FirstName] AS [FirstName],
[Project4].[MiddleName] AS [MiddleName],
[Project4].[LastName] AS [LastName],
[Project4].[Gender] AS [Gender],
[Project4].[Title] AS [Title],
[Project4].[BirthDate] AS [BirthDate],
[Project4].[isDeleted] AS [isDeleted],
[Project4].[CreateDate] AS [CreateDate],
[Project4].[LastChange] AS [LastChange],
[Limit2].[Id] AS [Id1],
[Limit2].[Id1] AS [Id2],
[Limit2].[Id2] AS [Id3],
[Limit2].[Value] AS [Value],
[Project4].[C1] AS [C1]
FROM (SELECT
[Project3].[Id] AS [Id],
[Project3].[Number] AS [Number],
[Project3].[FirstName] AS [FirstName],
[Project3].[MiddleName] AS [MiddleName],
[Project3].[LastName] AS [LastName],
[Project3].[Gender] AS [Gender],
[Project3].[Title] AS [Title],
[Project3].[BirthDate] AS [BirthDate],
[Project3].[isDeleted] AS [isDeleted],
[Project3].[CreateDate] AS [CreateDate],
[Project3].[LastChange] AS [LastChange],
[Project3].[C1] AS [C1]
FROM ( SELECT
[Project1].[Id] AS [Id],
[Project1].[Number] AS [Number],
[Project1].[FirstName] AS [FirstName],
[Project1].[MiddleName] AS [MiddleName],
[Project1].[LastName] AS [LastName],
[Project1].[Gender] AS [Gender],
[Project1].[Title] AS [Title],
[Project1].[BirthDate] AS [BirthDate],
[Project1].[isDeleted] AS [isDeleted],
[Project1].[CreateDate] AS [CreateDate],
[Project1].[LastChange] AS [LastChange],
(SELECT TOP (1)
[Extent2].[Id] AS [Id]
FROM [dbo].[CustomerProgram] AS [Extent2]
WHERE (0 = [Extent2].[isDeleted]) AND ([Project1].[Id] = [Extent2].[FK_CustomerId]) AND (@p__linq__1 = [Extent2].[FK_ProgramId])) AS [C1]
FROM ( SELECT
[Extent1].[Id] AS [Id],
[Extent1].[Number] AS [Number],
[Extent1].[FirstName] AS [FirstName],
[Extent1].[MiddleName] AS [MiddleName],
[Extent1].[LastName] AS [LastName],
[Extent1].[Gender] AS [Gender],
[Extent1].[Title] AS [Title],
[Extent1].[BirthDate] AS [BirthDate],
[Extent1].[isDeleted] AS [isDeleted],
[Extent1].[CreateDate] AS [CreateDate],
[Extent1].[LastChange] AS [LastChange]
FROM [dbo].[Customer] AS [Extent1]
WHERE ( NOT (([Extent1].[isDeleted] = 1) AND (2 = @p__linq__0))) AND ([Extent1].[Id] IN (cast('08909057-84e7-4eb6-8c5b-580b4732c82a' as uniqueidentifier)))
) AS [Project1]
) AS [Project3] ) AS [Project4]
OUTER APPLY (SELECT TOP (1)
[Extent3].[Id] AS [Id],
[Extent4].[Id] AS [Id1],
[Extent5].[Id] AS [Id2],
[Extent5].[Value] AS [Value]
FROM [dbo].[CustomerParameter] AS [Extent3]
INNER JOIN [dbo].[Parameter] AS [Extent4] ON [Extent3].[FK_ParameterId] = [Extent4].[Id]
LEFT OUTER JOIN [dbo].[ParameterValue] AS [Extent5] ON [Extent3].[FK_ParameterValueId] = [Extent5].[Id]
WHERE ([Project4].[Id] = [Extent3].[FK_CustomerId]) AND ([Extent4]. = @p__linq__2) ) AS [Limit2] ) AS [Project6] OUTER APPLY (SELECT TOP (1) [Extent6].[Id] AS [Id], [Extent7].[Id] AS [Id1], [Extent8].[Id] AS [Id2], [Extent8].[Value] AS [Value] FROM [dbo].[CustomerParameter] AS [Extent6] INNER JOIN [dbo].[Parameter] AS [Extent7] ON [Extent6].[FK_ParameterId] = [Extent7].[Id] LEFT OUTER JOIN [dbo].[ParameterValue] AS [Extent8] ON [Extent6].[FK_ParameterValueId] = [Extent8].[Id] WHERE ([Project6].[Id] = [Extent6].[FK_CustomerId]) AND ([Extent7].[code] = @p__linq__3) ) AS [Limit3] ) AS [Project8] OUTER APPLY (SELECT TOP (1) [Extent9].[Id] AS [Id], [Extent9].[FK_ParameterId] AS [FK_ParameterId], [Extent9].[CustomValue] AS [CustomValue], [Extent10].[Id] AS [Id1], [Extent10].[code] AS [code] FROM [dbo].[CustomerParameter] AS [Extent9] INNER JOIN [dbo].[Parameter] AS [Extent10] ON [Extent9].[FK_ParameterId] = [Extent10].[Id] WHERE ([Project8].[Id] = [Extent9].[FK_CustomerId]) AND ([Extent10].[code] = @p__linq__5) ) AS [Limit4] ) AS [Project10] ) AS [Project12] LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange] FROM [dbo].[Customer_CustomerChild] AS [Extent13] INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1) UNION ALL ещё одна портянка UNION ALL ещё одна портянка [/spoiler] Что называется "без комментариев" :-)[code] = @p__linq__2) ) AS [Limit2] ) AS [Project6]
OUTER APPLY (SELECT TOP (1)
[Extent6].[Id] AS [Id],
[Extent7].[Id] AS [Id1],
[Extent8].[Id] AS [Id2],
[Extent8].[Value] AS [Value]
FROM [dbo].[CustomerParameter] AS [Extent6]
INNER JOIN [dbo].[Parameter] AS [Extent7] ON [Extent6].[FK_ParameterId] = [Extent7].[Id]
LEFT OUTER JOIN [dbo].[ParameterValue] AS [Extent8] ON [Extent6].[FK_ParameterValueId] = [Extent8].[Id]
WHERE ([Project6].[Id] = [Extent6].[FK_CustomerId]) AND ([Extent7]. = @p__linq__3) ) AS [Limit3] ) AS [Project8] OUTER APPLY (SELECT TOP (1) [Extent9].[Id] AS [Id], [Extent9].[FK_ParameterId] AS [FK_ParameterId], [Extent9].[CustomValue] AS [CustomValue], [Extent10].[Id] AS [Id1], [Extent10].[code] AS [code] FROM [dbo].[CustomerParameter] AS [Extent9] INNER JOIN [dbo].[Parameter] AS [Extent10] ON [Extent9].[FK_ParameterId] = [Extent10].[Id] WHERE ([Project8].[Id] = [Extent9].[FK_CustomerId]) AND ([Extent10].[code] = @p__linq__5) ) AS [Limit4] ) AS [Project10] ) AS [Project12] LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange] FROM [dbo].[Customer_CustomerChild] AS [Extent13] INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1) UNION ALL ещё одна портянка UNION ALL ещё одна портянка [/spoiler] Что называется "без комментариев" :-)[code] = @p__linq__3) ) AS [Limit3] ) AS [Project8]
OUTER APPLY (SELECT TOP (1)
[Extent9].[Id] AS [Id],
[Extent9].[FK_ParameterId] AS [FK_ParameterId],
[Extent9].[CustomValue] AS [CustomValue],
[Extent10].[Id] AS [Id1],
[Extent10]. AS [code] FROM [dbo].[CustomerParameter] AS [Extent9] INNER JOIN [dbo].[Parameter] AS [Extent10] ON [Extent9].[FK_ParameterId] = [Extent10].[Id] WHERE ([Project8].[Id] = [Extent9].[FK_CustomerId]) AND ([Extent10].[code] = @p__linq__5) ) AS [Limit4] ) AS [Project10] ) AS [Project12] LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange] FROM [dbo].[Customer_CustomerChild] AS [Extent13] INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1) UNION ALL ещё одна портянка UNION ALL ещё одна портянка [/spoiler] Что называется "без комментариев" :-)[code] AS FROM [dbo].[CustomerParameter] AS [Extent9] INNER JOIN [dbo].[Parameter] AS [Extent10] ON [Extent9].[FK_ParameterId] = [Extent10].[Id] WHERE ([Project8].[Id] = [Extent9].[FK_CustomerId]) AND ([Extent10].[code] = @p__linq__5) ) AS [Limit4] ) AS [Project10] ) AS [Project12] LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange] FROM [dbo].[Customer_CustomerChild] AS [Extent13] INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1) UNION ALL ещё одна портянка UNION ALL ещё одна портянка [/spoiler] Что называется "без комментариев" :-)[code]
FROM [dbo].[CustomerParameter] AS [Extent9]
INNER JOIN [dbo].[Parameter] AS [Extent10] ON [Extent9].[FK_ParameterId] = [Extent10].[Id]
WHERE ([Project8].[Id] = [Extent9].[FK_CustomerId]) AND ([Extent10]. = @p__linq__5) ) AS [Limit4] ) AS [Project10] ) AS [Project12] LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange] FROM [dbo].[Customer_CustomerChild] AS [Extent13] INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1) UNION ALL ещё одна портянка UNION ALL ещё одна портянка [/spoiler] Что называется "без комментариев" :-)[code] = @p__linq__5) ) AS [Limit4]
) AS [Project10] ) AS [Project12]
LEFT OUTER JOIN (SELECT [Extent13].[FK_CustomerId] AS [FK_CustomerId], [Extent14].[FirstName] AS [FirstName], [Extent14].[LastName] AS [LastName], [Extent14].[Gender] AS [Gender], [Extent14].[BirthDate] AS [BirthDate], [Extent14].[isDeleted] AS [isDeleted], [Extent14].[CreateDate] AS [CreateDate], [Extent14].[LastChange] AS [LastChange]
FROM [dbo].[Customer_CustomerChild] AS [Extent13]
INNER JOIN [dbo].[CustomerChild] AS [Extent14] ON [Extent14].[Id] = [Extent13].[FK_CustomerChildId] ) AS [Join7] ON ([Project12].[Id] = [Join7].[FK_CustomerId]) AND ([Join7].[isDeleted] <> 1)
UNION ALL
ещё одна портянка
UNION ALL
ещё одна портянка