RepoDB with SQL Server's OUTPUT clause

Question

How can I access the contents of an OUTPUT clause with RepoDB, e.g.

INSERT INTO MyTable(Name)
OUTPUT INSERTED.ID
VALUES ('TheName')

Answer 1

An DML with an OUTPUT clause looks to the client like a SELECT. So it looks like ExecuteQuery would be the correct API.

Answer 2

Use the ExecuteScalar extension method like below (only if you are inserting single row).

var result = connection.ExecuteScalar("INSERT INTO MyTable(Name) OUTPUT INSERTED.ID VALUES (@Name);", new { Name = "TheName" });

Or using the typed-result.

var result = connection.ExecuteScalar<int>("INSERT INTO MyTable(Name) OUTPUT INSERTED.ID VALUES (@Name);", new { Name = "TheName" });

If you are inserting multiple rows, please use the ExecuteQuery method. The result would be a model (of type IEnumerable<T>).