Is it possible to use the new Asp.net Identity with Database First and EDMX? Or only with code first?
Here's what I did:
1) I made a new MVC5 Project and had the new Identity create the new User and Roles tables in my database.
2) I then opened my Database First EDMX file and dragged in the new Identity Users table since I have other tables that relate to it.
3) Upon saving the EDMX, the Database First POCO generator will auto create a User class. However, UserManager and RoleManager expects a User class inheriting from the new Identity namespace (Microsoft.AspNet.Identity.IUser), so using the POCO User class won't work.
I guess a possible solution is to edit my POCO Generation Classes to have my User class inherit from IUser?
Or is ASP.NET Identity only compatible with Code First Design?
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Update: Following Anders Abel's suggestion below, this is what I did. It work's, but I'm wondering if there is a more elegant solution.
1) I extended my entity User class by creating a partial class within the same namespace as my auto generated entities.
namespace MVC5.DBFirst.Entity { public partial class AspNetUser : IdentityUser { } }
2) I changed my DataContext to inherit from IdentityDBContext instead of DBContext. Note that every time you update your EDMX and regenerate the DBContext and Entity classes, you'll have to set this back to this.
public partial class MVC5Test_DBEntities : IdentityDbContext<AspNetUser> //DbContext
3) Within your auto generated User entity class, you must add the override keyword to the following 4 fields or comment these fields out since they are inherited from IdentityUser (Step 1). Note that every time you update your EDMX and regenerate the DBContext and Entity classes, you'll have to set this back to this.
override public string Id { get; set; } override public string UserName { get; set; } override public string PasswordHash { get; set; } override public string SecurityStamp { get; set; }
Step 1 − Let's create a new console project with DatabaseFirstDemo name. Step 2 − To create the model, first right-click on your console project in solution explorer and select Add → New Items… Step 3 − Select ADO.NET Entity Data Model from middle pane and enter name DatabaseFirstModel in the Name field.
In this article, I will cover the two most popular approaches used by the programmers in domain driven applications. The main difference between Code First approach and Database First approach is that the Code First enables you to write entity classes and its properties first without creating the database design first.
Step 1 − First, create the console application from File → New → Project… Step 2 − Select Windows from the left pane and Console Application from the template pane. Step 3 − Enter EFCodeFirstDemo as the name and select OK. Step 4 − Right-click on your project in the solution explorer and select Manage NuGet Packages…
In code first approach we will first create entity classes with properties defined in it. Entity framework will create the database and tables based on the entity classes defined. So database is generated from the code. When the dot net code is run database will get created.
It should be possible to use the identity system with POCO and Database First, but you'll have to make a couple of tweaks:
partial
. That will make it possible for you to supply additional implementation in a separate file.User
class in another file
partial User : IUser { }
That will make the User
class implement the right interface, without touching the actual generated files (editing generated files is always a bad idea).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With