Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__options_Value_ApplicationDomain_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ApplicationName]
FROM [AspNetAppDomains] AS [a]
WHERE [a].[ApplicationName] = @__options_Value_ApplicationDomain_0
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__domainName_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ApplicationName]
FROM [AspNetAppDomains] AS [a]
WHERE [a].[ApplicationName] = @__domainName_0
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (2ms) [Parameters=[@__domainId_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[DomainId], [a].[IsGlobal], [a].[PolicyName], [a0].[Id], [a0].[ApplicationName]
FROM [AspNetAppPolicies] AS [a]
LEFT JOIN [AspNetAppDomains] AS [a0] ON [a].[DomainId] = [a0].[Id]
WHERE [a].[DomainId] = @__domainId_0 OR [a].[IsGlobal] = CAST(1 AS bit)
ORDER BY [a].[Id], [a0].[Id]
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (3ms) [Parameters=[@__domainId_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
SELECT [t].[Id], [t].[ClaimId], [t].[PolicyId], [a].[Id], [a0].[Id], [t].[Id0], [t].[ClaimName], [t].[DomainId], [t].[IsGlobal]
FROM [AspNetAppPolicies] AS [a]
LEFT JOIN [AspNetAppDomains] AS [a0] ON [a].[DomainId] = [a0].[Id]
INNER JOIN (
SELECT [a1].[Id], [a1].[ClaimId], [a1].[PolicyId], [a2].[Id] AS [Id0], [a2].[ClaimName], [a2].[DomainId], [a2].[IsGlobal]
FROM [AspNetAppPolicyClaims] AS [a1]
INNER JOIN [AspNetAppClaims] AS [a2] ON [a1].[ClaimId] = [a2].[Id]
) AS [t] ON [a].[Id] = [t].[PolicyId]
WHERE [a].[DomainId] = @__domainId_0 OR [a].[IsGlobal] = CAST(1 AS bit)
ORDER BY [a].[Id], [a0].[Id], [t].[Id], [t].[Id0]
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (3ms) [Parameters=[@__domainId_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
SELECT [a1].[Id], [a1].[PolicyId], [a].[Id], [a0].[Id]
FROM [AspNetAppPolicies] AS [a]
LEFT JOIN [AspNetAppDomains] AS [a0] ON [a].[DomainId] = [a0].[Id]
INNER JOIN [AspNetAppPolicyRoles] AS [a1] ON [a].[Id] = [a1].[PolicyId]
WHERE [a].[DomainId] = @__domainId_0 OR [a].[IsGlobal] = CAST(1 AS bit)
ORDER BY [a].[Id], [a0].[Id], [a1].[Id]
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (6ms) [Parameters=[@__domainId_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
SELECT [t].[Id], [t].[PolicyRoleId], [t].[RoleId], [t].[Id0], [t].[DomainId], [t].[IsGlobal], [t].[RoleName], [a].[Id], [a0].[Id], [a1].[Id]
FROM [AspNetAppPolicies] AS [a]
LEFT JOIN [AspNetAppDomains] AS [a0] ON [a].[DomainId] = [a0].[Id]
INNER JOIN [AspNetAppPolicyRoles] AS [a1] ON [a].[Id] = [a1].[PolicyId]
INNER JOIN (
SELECT [a2].[Id], [a2].[PolicyRoleId], [a2].[RoleId], [a3].[Id] AS [Id0], [a3].[DomainId], [a3].[IsGlobal], [a3].[RoleName]
FROM [AspNetAppPolicyRoleValues] AS [a2]
INNER JOIN [AspNetAppRoles] AS [a3] ON [a2].[RoleId] = [a3].[Id]
) AS [t] ON [a1].[Id] = [t].[PolicyRoleId]
WHERE [a].[DomainId] = @__domainId_0 OR [a].[IsGlobal] = CAST(1 AS bit)
ORDER BY [a].[Id], [a0].[Id], [a1].[Id]
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__domainId_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
SELECT [a3].[Id], [a3].[PolicyClaimId], [a3].[Value], [a].[Id], [a0].[Id], [t].[Id], [t].[Id0]
FROM [AspNetAppPolicies] AS [a]
LEFT JOIN [AspNetAppDomains] AS [a0] ON [a].[DomainId] = [a0].[Id]
INNER JOIN (
SELECT [a1].[Id], [a1].[PolicyId], [a2].[Id] AS [Id0]
FROM [AspNetAppPolicyClaims] AS [a1]
INNER JOIN [AspNetAppClaims] AS [a2] ON [a1].[ClaimId] = [a2].[Id]
) AS [t] ON [a].[Id] = [t].[PolicyId]
INNER JOIN [AspNetAppPolicyClaimValues] AS [a3] ON [t].[Id] = [a3].[PolicyClaimId]
WHERE [a].[DomainId] = @__domainId_0 OR [a].[IsGlobal] = CAST(1 AS bit)
ORDER BY [a].[Id], [a0].[Id], [t].[Id], [t].[Id0]
Information: Microsoft.EntityFrameworkCore.Database.Command - Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[CodeValue], [c].[CreateDate], [c].[CreateUser], [c].[DisplayOrder], [c].[IsActive], [c].[Name], [c].[UpdateDate], [c].[UpdateUser], [c].[Version]
FROM [CountryType] AS [c]
ORDER BY [c].[DisplayOrder]