Merge Dapper and Entity Framework

Question

Dear
I create Blazor project use Dapper as my ORM.and all my CRUD
i want to use Entity Framework for Identity with the same project
I need to be able to implement roles as well as accept logins from third party services i.e. Facebook & Twitter.
Does it affect the program?
Thanks

Sachin Singh · Accepted Answer

Yes, you can easily use both, start with EF so that you have connection strings set, use the same connection string in Dapper. For example suppose this is your connection string for EF Core   "ConnectionStrings" : {      "DefaultConnection" :  "Data Source="sachin-PC";Initial Catalog=demoDb;Integrated Security=True;MultipleActiveResultSets=True"    },   public   void  ConfigureServices(IServiceCollection services)   {       services.AddDbContext (options =>           options           .UseSqlServer(Configuration.GetConnectionString( "DefaultConnection" ))           );       }   You can get the CS as  public  ApplicationReadDbConnection(IConfiguration configuration)       {           connection =  new  SqlConnection(configuration.GetConnectionString( "DefaultConnection" ));            return connection;     }     IDbConnection connection = null;
public  IDbConnection GetDbConnection( IConfiguration configuration )           {                 connection = new SqlConnection(configuration.GetConnectionString( "DefaultConnection" ));                connection.Open();                return  connection;           }

ahmad abukhalil · Answer

Thanks for all but how can add(Identity Scaffolding) with my local database I mean created befor working with dapper
"ConnectionStrings": {
"SqlDBConnection": "Data Source=AHMADPC\MYSERVER;Initial Catalog=schoolpro;Integrated Security=True" Not with sqlserver in visual studio

Muhammad Imran Ansari · Answer

Yes. You can share the EF connection with Dapper . With this you can improve the performance in certain scenarios. You can follow the step-by-step tutorial to achieve your task:
https://www.c-sharpcorner.com/article/combine-ado-net-ef-core-and-dapper-in-same-blazor-app/

ahmad abukhalil · Answer

Thanks
Sachin Singh