FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

To insert data and return the id, you have 2 choices:
<ol>
<li>Use the <code>Execute</code> method and select the identity inserted with <a href="https://learn.microsoft.com/en-us/sql/t-sql/functions/scope-identity-transact-sql">SCOPE_IDENTITY()</a></li>
<li>Use <a href="https://dapper-plus.net/">Dapper Plus</a> with the property mapped as identity or output</li>
</ol>
Solution 1
<pre><code class="language-csharp">using (var connection = new SqlConnection(connectionString))
{
	var sql = @&quot;
INSERT INTO Customers (Name, Email) VALUES (@Name, @Email)
SELECT SCOPE_IDENTITY()
&quot;;

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

var customerID = connection.Execute(sql, customer);
	customer.CustomerID = customerID;

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() { Name = &quot;Learn Dapper&quot;, Email = &quot;learndapper@example.com&quot; };

connection.BulkInsert(customer);

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

Advertising Break! 5 seconds left

Did you know...