[Source] ef displays the generated SQL statements

Published on 2017/6/27 15:28:24 +08:00
The connection is open

SELECT Count(*)
FROM INFORMATION_SCHEMA. TABLES AS t
WHERE t.TABLE_SCHEMA + '.' + t.TABLE_NAME IN ('dbo. Tab1','dbo. Tab2')
    OR t.TABLE_NAME = 'EdmMetadata'


-- On 6/27/2017 15:28:24 +08:00
execute
-- Completed in 12 milliseconds with a result: 2



Published on 2017/6/27 15:28:24 +08:00
Closed the connection
Published on 2017/6/27 15:28:25 +08:00
The connection is open
SELECT
    [GroupBy1]. [A1] AS [C1]
    FROM ( SELECT
        COUNT(1) AS [A1]
        FROM [dbo]. [__MigrationHistory] AS [Extent1]
        WHERE [Extent1]. [ContextKey] = @p__linq__0
    )  AS [GroupBy1]


-- p__linq__0: 'CodeFirstDemo.TestDb' (Type = String, Size = 4000)

-- On 2017/6/27 15:28:26 +08:00
execute
-- Completed in 4 milliseconds with the result: SqlDataReader



Uploaded on 2017/6/27 15:28:26 +08:00
Closed the connection
Uploaded on 2017/6/27 15:28:26 +08:00
The connection is open
SELECT TOP (1)
    [Project1]. [C1] AS [C1],
    [Project1]. [MigrationId] AS [MigrationId],
    [Project1]. [Model] AS [Model],
    [Project1]. [ProductVersion] AS [ProductVersion]
    FROM ( SELECT
        [Extent1]. [MigrationId] AS [MigrationId],
        [Extent1]. [Model] AS [Model],
        [Extent1]. [ProductVersion] AS [ProductVersion],
        1 AS [C1]
        FROM [dbo]. [__MigrationHistory] AS [Extent1]
        WHERE [Extent1]. [ContextKey] = @p__linq__0
    )  AS [Project1]
    ORDER BY [Project1]. [MigrationId] DESC


-- p__linq__0: 'CodeFirstDemo.TestDb' (Type = String, Size = 4000)

-- On 2017/6/27 15:28:26 +08:00
execute
-- Completed in 4 milliseconds with the result: SqlDataReader



Uploaded on 2017/6/27 15:28:26 +08:00
Closed the connection

EF Core Series 4 looks at the generated SQL statements
https://www.itsvse.com/thread-9564-1-1.html

[Actual combat]. NET/C# SQL query generator based on sqlkata
https://www.itsvse.com/thread-10370-1-1.html