Using Asp.Net Identity DataBase first approach

by

A possible solution which works for me, basically I am able to integrate Asp.Net Identity User Profiles with an existing Database.

Getting the Asp.Identity Tables:

  • Create an MVC Project with Authentication Individual User Account
  • Open the DB listed under the DefaultConnection in Web.config. It will be called (aspnet-[timestamp] or something like that.)
  • Script the database tables using SQL Server Management Studio (attach database for mdc).

Alternatively use something like http://identity.codeplex.com/

Integrating with your existing db:

  • Insert the scripted tables into existing database in SQL Server Management Studio.
  • Customize and add relationships to ApplicationUser (if necessary).
  • Create new Web Project > MVC > DB First Project > Import DB with EF … .
  • In IdentityModels.cs change the ApplicationDbContext :base(“DefaltConnection”) to use your project’s DbContext.

Now you have the Asp.Identity Tables in your db with ER model in your application.

Asp.Identity Profile Adding new properties:

  • Enable Entity Framework Code First Database Migrations, just in VS go under Tools ‘Package Manager Console’,

  • Execute the command “Enable-Migrations”; Once we enabled the database migrations, we can go ahead and add new properties for our UserProfile

  • To Add new properties modify IdentityModels.cs file, example:

public class ApplicationUser : IdentityUser
{
public string FirstName { get; set; }
public string LastName { get; set; }
public string EmailID { get; set; }
}

Add New Migration

  • Once we added the properties, bring the Package Manager Console and execute the following command.

    Add-Migration “YouMigrationName”

This command will generate a database script file, now execute following command to run this script file against the database.

Update-Database

Now, all the new properties will turn into table fields in the same database table.

I hope it can help others, if you have a better idea please let me know.

More Related Contents:

  1. ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value
  2. Why does the EF 6 tutorial use asynchronous calls?
  3. How to add/update child entities when updating a parent entity in EF
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. Non-static method requires a target
  7. Implementing Audit Log / Change History with MVC & Entity Framework
  8. How to do a Bulk Insert — Linq to Entities
  9. How to group by on 2 child entities and get total of both this child entities?
  10. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  11. When should I create a new DbContext()
  12. Questions about Entity Framework Context Lifetime
  13. The operation cannot be completed because the DbContext has been disposed using MVC 4
  14. Is Deferred Execution in Asp.net MVC View a very bad thing?
  15. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  16. Export Model to DataTable
  17. ASP.NET Identity – Multiple object sets per type are not supported
  18. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  19. Set database timeout in Entity Framework
  20. Only primitive types or enumeration types are supported in this context
  21. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  22. Keyword Not Supported: Metadata
  23. Entities VS Domain Models VS View Models
  24. How to create custom additional fields in UserProfile in MVC4
  25. How should I set up my integration tests to use a test database with Entity Framework?
  26. Where to convert business model to view model?
  27. Repository Pattern, POCO, and Business Entities
  28. MVC 4 – Many-to-Many relation and checkboxes
  29. .NET Managing Layers Relationships
  30. Entity Framework Many to many through containing object

Leave a Comment