How to use dapper with ASP.Net core Identity? : <p>I have a database and iam trying to use dapper with Core Identity to make queries to database. but i am stuck at this point. I am using a User from the interface of identityUser:</p>

<pre><code>public class User : IdentityUser
{

}
</code></pre>

<p>The with a making a custom user store for CRUD with dapper.</p>

<pre><code> public class UserStore : IUserStore&lt;User&gt;
{
    private readonly string connectionString;

    public UserStore(IConfiguration configuration)
    {
        connectionString = configuration.GetValue&lt;string&gt;("DBInfo:ConnectionString");
    }

    internal IDbConnection Connection
    {
        get
        {
            return new SqlConnection(connectionString);
        }
    }
    public Task&lt;IdentityResult&gt; CreateAsync(User user, CancellationToken cancellationToken)
    {
**// HOW TO I RETURN A USER WITH DAPPER HERE?**
    }

    public Task&lt;IdentityResult&gt; DeleteAsync(User user, CancellationToken cancellationToken)
    {
        throw new NotImplementedException();
    }

    public void Dispose()
    {
        throw new NotImplementedException();
    }

    public Task&lt;User&gt; FindByIdAsync(string userId, CancellationToken cancellationToken)
    {
        throw new NotImplementedException();
    }

    public Task&lt;User&gt; FindByNameAsync(string normalizedUserName, CancellationToken cancellationToken)
    {
        throw new NotImplementedException();
    }

    public Task&lt;string&gt; GetUserIdAsync(User user, CancellationToken cancellationToken)
    {
        throw new NotImplementedException();
    }

    public Task&lt;string&gt; GetUserNameAsync(User user, CancellationToken cancellationToken)
    {
        throw new NotImplementedException();
    }

    public Task&lt;IdentityResult&gt; UpdateAsync(User user, CancellationToken cancellationToken)
    {
        throw new NotImplementedException();
    }
</code></pre>

<p>thanks!</p>
