Dapper Tutorial - Knowledge Base (KB)

Using EF and other Dapper ORM in same project - drawbacks

I am about to start a new project and I have a little dillema. App require asp identity for security and dapper as orm. My plan is to use default asp web app template with identity that use entity framework and for all business data access use dapper. Thi...

Getter property with async method doesn't finish executing

Problem...: method doesn't finish executing (no exception, http request in ...pending... status)....I have to implement next interface: ...public interface IQueryableUserStore<TUser, in TKey> : IUserStore<TUser, TKey>, IDisposable where TUser : class, IU...

ASP .Net Identity, Dapper & stored procedures Best Practices

I am currently following this ...guide... to learn Dapper micro ORM and ASP.NET identity. I thought to mix it up a bit by implementing a generic repository pattern that will help me do basic CRUD operations....Here are my classes:...User.cs...public class...

Create KeyValuePair<TKey, TValue> from columns in a single data row

I have the following table in Sql Server that stores the permissions the Foreign Key ...UserId... has to the Foreign Keyed ...BlogId.... What I would like to do is write a query with Dapper that takes each column after ...BlogId... and returns it as a ...

How to use dapper with ASP.Net core Identity?

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:...public class User : IdentityUser { } ...The with a making a custom user s...

Has ASP.NET Identity UserManager.CreateAsync() been updated with breaking changes recently?

A few months ago I created my own implementation of ASP.NET Identity, overriding the UserStore to use dapper and a custom sql connection instead of Entity Framework. It worked fine at the time....Now I updated all of the nuget packages today and I've been...

Setting up Dapper with Identity Aspnetcore 2.0

I've found what seems to be a pretty neat little package that lets you use dapper + identity core 2.0. However, since I am very new to core development, I am getting a little confused about something and I'm not sure how to resolve it. The package in ques...

Dapper MySQL return value

i got a problem using dapper and MySql in a ASP.net Identity project. I want to insert a user to a table users and want the autogenerated id from this insertation back. But i get a syntax error and i don´t know why....this is my code for the method inser...

Mvc Core Get UserId after ExternalLoginSignInAsync

I login my user via third part such as google in the following way:...var info = await _signInManager.GetExternalLoginInfoAsync(); var result = await _signInManager.ExternalLoginSignInAsync(info.LoginProvider, info.ProviderKey, false); ...Should the above...