已于 2017/6/27 15:28:24 +08:00
打开了连接
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'
-- 正在 2017/6/27 15:28:24 +08:00
执行
-- 已在 12 毫秒内完成,结果为: 2
已于 2017/6/27 15:28:24 +08:00
关闭了连接
已于 2017/6/27 15:28:25 +08:00
打开了连接
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)
-- 正在 2017/6/27 15:28:26 +08:00
执行
-- 已在 4 毫秒内完成,结果为: SqlDataReader
已于 2017/6/27 15:28:26 +08:00
关闭了连接
已于 2017/6/27 15:28:26 +08:00
打开了连接
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)
-- 正在 2017/6/27 15:28:26 +08:00
执行
-- 已在 4 毫秒内完成,结果为: SqlDataReader
已于 2017/6/27 15:28:26 +08:00
关闭了连接 方法一:
方法二:
(在EF 4.1中,我们可以直接调用DbQuery<>的ToString()方法得到所生成的SQL。)
|