FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

To insert data, including the identity value, you have 2 choices:
<ol>
<li>Use the <code>Execute</code> method and turn on the <a href="https://learn.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql-server-ver16">identity insert</a></li>
<li>Use <a href="https://dapper-plus.net/">Dapper Plus</a> with the <code>InsertKeepIdentity</code> option</li>
</ol>
Solution 1
<pre><code class="language-csharp">using (var connection = new SqlConnection(connectionString))
{
	var sql = @&quot;
SET IDENTITY_INSERT Customers ON

INSERT INTO Customers (CustomerID, Name, Email) VALUES (@CustomerID, @Name, @Email)
&quot;;

var customer = new Customer() { CustomerID = 13, Name = &quot;Learn Dapper&quot;, Email = &quot;learndapper@example.com&quot; };

connection.Execute(sql, customer);

Console.WriteLine(customer.CustomerID);
}
</code></pre>
Solution 2
<pre><code class="language-csharp">// global context mapping: https://dapper-plus.net/getting-started-mapping#global-context-mapping
DapperPlusManager.Entity&lt;Customer&gt;().Identity(x =&gt; x.CustomerID);

using (var connection = new SqlConnection(connectionString))
{
	var customer = new Customer() { CustomerID = 13, Name = &quot;Learn Dapper&quot;, Email = &quot;learndapper@example.com&quot; };

connection.UseBulkOptions(x =&gt; x.InsertKeepIdentity = true).BulkInsert(customer);

Console.WriteLine(customer.CustomerID);
}
</code></pre>

Advertising Break! 5 seconds left

Did you know...