How do I perform an insert and return inserted identity with Dapper?

by

It does support input/output parameters (including RETURN value) if you use DynamicParameters, but in this case the simpler option is simply:

var id = connection.QuerySingle<int>( @"
INSERT INTO [MyTable] ([Stuff]) VALUES (@Stuff);
SELECT CAST(SCOPE_IDENTITY() as int)", new { Stuff = mystuff});

Note that on more recent versions of SQL Server (2005+) you can use the OUTPUT clause:

var id = connection.QuerySingle<int>( @"
INSERT INTO [MyTable] ([Stuff])
OUTPUT INSERTED.Id
VALUES (@Stuff);", new { Stuff = mystuff});

More Related Contents:

  1. C#: SQL Server Connection String
  2. Delete from two tables? [closed]
  3. Using stored procedure output parameters in C#
  4. Correct use of multimapping in Dapper
  5. Insert entire DataTable into database at once instead of row by row?
  6. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  7. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  8. SqlParameter does not allows Table name – other options without sql injection attack?
  9. Any way to SQLBulkCopy “insert or update if exists”?
  10. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  11. What SqlDbType maps to varBinary(max)?
  12. How to keep single SQL Server connection instance open for multiple request in C#?
  13. Delete a single record from Entity Framework?
  14. How to pass XML from C# to a stored procedure in SQL Server 2008?
  15. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  16. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  17. Failed to update .mdf database because the database is read-only (Windows application)
  18. What size do you use for varchar(MAX) in your parameter declaration?
  19. Pros and Cons of using SqlCommand Prepare in C#?
  20. GO statements blowing up sql execution in .NET
  21. How to Identify the primary key duplication from a SQL Server 2008 error code?
  22. Provider named pipes provider error 40 could not open a connection to SQL Server error 2 [duplicate]
  23. Is it possible to use SqlGeography with Linq to Sql?
  24. How to get efficient Sql Server deadlock handling in C# with ADO?
  25. Cyrillic encoding in C#
  26. Generating sql code programmatically
  27. Accessing System Databases/Tables using LINQ to SQL?
  28. ‘Must Declare the Scalar Variable’ Error When Passing a Table-Valued Parameter to a Parameterized SQL Statement
  29. What causes “extension methods cannot be dynamically dispatched” here?
  30. What does a timestamp in T-Sql mean in C#?

Leave a Comment