Skip to content

Instantly share code, notes, and snippets.

@rafaelpadovezi
Created March 17, 2021 11:08
Show Gist options
  • Save rafaelpadovezi/e59f2009252a589db9fddb486d51ed15 to your computer and use it in GitHub Desktop.
Save rafaelpadovezi/e59f2009252a589db9fddb486d51ed15 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='3' (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