title: How to use dapper with ASP.Net core Identity?
body: <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>