Skip to content

Instantly share code, notes, and snippets.

@rafaelpadovezi
Created March 17, 2021 11:11
Show Gist options
  • Save rafaelpadovezi/669339b2550a04ff3f1696af0f8fdf99 to your computer and use it in GitHub Desktop.
Save rafaelpadovezi/669339b2550a04ff3f1696af0f8fdf99 to your computer and use it in GitHub Desktop.
Insert entities
dbug: RelationalEventId.CommandExecuting[20100] (Microsoft.EntityFrameworkCore.Database.Command)
Executing DbCommand [Parameters=[@p0='John Doe' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [Employees] ([Name])
VALUES (@p0);
SELECT [Id]
FROM [Employees]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();
dbug: RelationalEventId.CommandExecuting[20100] (Microsoft.EntityFrameworkCore.Database.Command)
Executing DbCommand [Parameters=[@p1='5' (Nullable = true), @p2='12:00:00', @p3='08:00:00'], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [TimeEntries] ([EmployeeId], [End], [Start])
VALUES (@p1, @p2, @p3);
SELECT [Id]
FROM [TimeEntries]
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment