Typed Ids

insert.sql

Executed DbCommand (37ms) [Parameters=[@p0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
      SET IMPLICIT_TRANSACTIONS OFF;
      SET NOCOUNT ON;
      INSERT INTO [Blogs] ([Name])
      OUTPUT INSERTED.[Id]
      VALUES (@p0);
      
Executed DbCommand (17ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = DateTimeOffset), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (DbType = DateTimeOffset), @p7='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
      SET IMPLICIT_TRANSACTIONS OFF;
      SET NOCOUNT ON;
      MERGE [Post] USING (
      VALUES (@p0, @p1, @p2, @p3, 0),
      (@p4, @p5, @p6, @p7, 1)) AS i ([BlogId], [Content], [PublishedOn], [Title], _Position) ON 1=0
      WHEN NOT MATCHED THEN
      INSERT ([BlogId], [Content], [PublishedOn], [Title])
      VALUES (i.[BlogId], i.[Content], i.[PublishedOn], i.[Title])
      OUTPUT INSERTED.[Id], i._Position;      

read.sql

Executed DbCommand (3ms) [Parameters=[@__id_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(2) [b].[Id], [b].[Name]
      FROM [Blogs] AS [b]
      WHERE [b].[Id] = @__id_0
      
 Executed DbCommand (13ms) [Parameters=[@__lastPostId_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(2) [p].[Id], [p].[BlogId], [p].[Content], [p].[PublishedOn], [p].[Title]
      FROM [Blogs] AS [b]
      INNER JOIN [Post] AS [p] ON [b].[Id] = [p].[BlogId]
      WHERE [p].[Id] = @__lastPostId_0