Creating an identity 2 database

Question

User-973886032 posted
Hi guys
I am finally moving from membership provider to identity 2

I have been reading up resources on it and though I understand it. I can't seem to find the application equivalent to reg_sql which would create the identity database

How do I go about this ?

Thanks

Ehi

Answer 1

User475983607 posted

Identity uses code first so the easiest method is simply create a new project and login.  The new project template will build the required tables.  Once you have the tables built the way you like then use SSMS to create the CREATE scripts, if needed.

http://www.asp.net/identity

If you are attempting to integrate Identity into ASP membership schema, then you'll need to implement a custom User Store by implementing the various Identity Interfaces.

http://www.asp.net/identity/overview/extensibility/overview-of-custom-storage-providers-for-aspnet-identity

Or take a look at ASP.NET's recommendation for migrating.

http://www.asp.net/identity/overview/migrations/migrating-an-existing-website-from-sql-membership-to-aspnet-identity

If you looking for SQL to create the tables then see the following.

http://danieleagle.com/blog/2014/05/setting-up-asp-net-identity-framework-2-0-with-database-first-vs2013-update-2-spa-template/

Answer 2

User36583972 posted

Hi afrika,

I found some tutorials in the below for your reference.

1: SQL Database Project for ASP.NET Identity 2.0

http://identity.codeplex.com/

2: Database First:

https://msdn.microsoft.com/en-us/data/jj206878.aspx

Best Regards,

Yohann Lu

Answer 3

User-1780421697 posted

Easy approach is to create a new project with authentication option. As Identity uses Code First approach you need to add/update attributes in ApplicationUser class according to your needs when all done change the connection string of application and point to your database, Now tricky step is that you have to perform migration.

Migration is process in which you actually perform database related operation.