Returning a value after a insert statement

This is the code im running in DotNet:

var testQuery = $@"
  INSERT INTO [{databaseName}].[dbo].[steptable] ([Type], [ParentKey], [SubWorkflowCode], [Sequence], [WorkflowKey]) 
  OUTPUT inserted.[Key]
  VALUES (@Type, CASE WHEN @ParentKey = 0 THEN NULL ELSE @ParentKey END, @SubWorkflowCode, @Sequence, @WorkflowKey);";

var test = await connection.ExecuteAsync(testQuery, step);

var testQuery = $@"
  INSERT INTO [{databaseName}].[dbo].[steptable] ([Type], [ParentKey], [SubWorkflowCode], [Sequence], [WorkflowKey]) 
  OUTPUT inserted.[Key]
  VALUES (@Type, CASE WHEN @ParentKey = 0 THEN NULL ELSE @ParentKey END, @SubWorkflowCode, @Sequence, @WorkflowKey);";

var test = await connection.ExecuteAsync(testQuery, step);

After execution the var test contains 1. When i run the same sql statement in mssql the result can be seen in the attached image.
I think the 1 comes from the row number, but i need the 441 to be returned into the test variable.

Thanks in advance!

C#•3y ago•

6 replies

Zil

Returning a value after a insert statement

This is the code im running in DotNet:

var testQuery = $@"
  INSERT INTO [{databaseName}].[dbo].[steptable] ([Type], [ParentKey], [SubWorkflowCode], [Sequence], [WorkflowKey]) 
  OUTPUT inserted.[Key]
  VALUES (@Type, CASE WHEN @ParentKey = 0 THEN NULL ELSE @ParentKey END, @SubWorkflowCode, @Sequence, @WorkflowKey);";

var test = await connection.ExecuteAsync(testQuery, step);

var testQuery = $@"
  INSERT INTO [{databaseName}].[dbo].[steptable] ([Type], [ParentKey], [SubWorkflowCode], [Sequence], [WorkflowKey]) 
  OUTPUT inserted.[Key]
  VALUES (@Type, CASE WHEN @ParentKey = 0 THEN NULL ELSE @ParentKey END, @SubWorkflowCode, @Sequence, @WorkflowKey);";

var test = await connection.ExecuteAsync(testQuery, step);

Returning a value after a insert statement

Similar Threads

Returning a value after a insert statement

Similar Threads

Similar Threads

Similar Threads