First, you need to create a schema that will store information about users. To do it, execute the Install_identity_tables.sql script, which goes with dotConnect for MySQL. By default, this script is in the Program Files\Devart\dotConnect\MySQL\Web\ASP.NET Identity 1 folder. You can also copy this script from the Identity Database Script chapter of this topic. You may use any tool to execute this script, for example phpMyAdmin or dbForge Fusion for MySQL. After this perform the following steps:

1. In Visual Studio remove the IdentityModels.cs (or IdentityModels.vb for Visual Basic) file that is in the Models folder, from the project.

2. In the Controllers project folder open the AccountController.cs (or AccountController.vb for Visual Basic) file.

   Replace

   • C#

   using Microsoft.AspNet.Identity.EntityFramework;
   

   • Visual Basic

   
   Imports Microsoft.AspNet.Identity.EntityFramework
   
   

   with:

   • C#

   using Devart.Common.Web.Identity;
   using Devart.Data.MySql.Web.Identity;
   using ApplicationUser = Devart.Common.Web.Identity.IdentityUser;
   

   • Visual Basic

   
   Imports Devart.Common.Web.Identity
   Imports Devart.Data.MySql.Web.Identity
   Imports ApplicationUser = Devart.Common.Web.Identity.IdentityUser
   
   

   Replace the constructor code:

   • C#

           public AccountController()
               : this(new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new ApplicationDbContext())))
           {
           }
   

   • Visual Basic

   
   	Public Sub New()
   		Me.New(New UserManager(Of ApplicationUser)(New UserStore(Of ApplicationUser)(New ApplicationDbContext())))
   	End Sub
   
   

   with

   • C#

   	public AccountController()
   		: this(new UserManager<ApplicationUser>(new MySqlUserStore()))        
   	{
   	}
   

   • Visual Basic

   
   	Public Sub New()
   		Me.New(New UserManager(Of ApplicationUser)(New MySqlUserStore()))
   	End Sub
   
   

3. In the web.config file of your project, replace the default connection string with your MySQL one.

   <add name="DefaultConnection" connectionString="User Id=root;Host=localhost;Database=Test;" providerName="Devart.Data.MySql" />
   	

If you want to extend the out-of-the-box ASP.NET Identity functionality, you may inherit from the standard ASP.NET Identity classes. In our tutorial we will create a new user class that stores additional information about users - their emails.

To implement email storing, please perform the following steps:

1. Open the IdentityModels.cs (or IdentityModels.vb for Visual Basic) file from the Models project folder.

2. Replace the imported namespace

   • C#

   using Microsoft.AspNet.Identity.EntityFramework;
   

   • Visual Basic

   
   Imports Microsoft.AspNet.Identity.EntityFramework
   
   

   with:

   • C#

   using Devart.Common.Web.Identity;
   using Devart.Data.MySql.Web.Identity;
   

   • Visual Basic

   
   Imports Devart.Common.Web.Identity
   Imports Devart.Data.MySql.Web.Identity
   
   

3. Remove the code of the ApplicationDbContext class.

4. Add the Email property to the ApplicationUser class that is inherited from the IdentityUser class.

   Code before:

   • C#

   
       // You can add profile data for the user by adding more properties to your ApplicationUser class, please visit http://go.microsoft.com/fwlink/?LinkID=317594 to learn more.
       public class ApplicationUser : IdentityUser
       {
       }
    
       public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
       {
           public ApplicationDbContext()
               : base("DefaultConnection")
           {
           }
       }
   
   

   • Visual Basic

   
   	' You can add profile data for the user by adding more properties to your ApplicationUser class, please visit http://go.microsoft.com/fwlink/?LinkID=317594 to learn more.
   	Public Class ApplicationUser
   		Inherits IdentityUser
   	End Class
   
   	Public Class ApplicationDbContext
   		Inherits IdentityDbContext(Of ApplicationUser)
   		Public Sub New()
   			MyBase.New("DefaultConnection")
   		End Sub
   	End Class
   
   

   Code after:

   • C#

   
     public class ApplicationUser : IdentityUser {
    
       public ApplicationUser() {
       }
    
       public string Email { get; set; }
     }
   

   • Visual Basic

   
   
   	Public Class ApplicationUser
   		Inherits IdentityUser
   
   		Public Sub New()
   		End Sub
   
   		Public Property Email() As String
   			Get
   				Return m_Email
   			End Get
   			Set
   				m_Email = Value
   			End Set
   		End Property
   		Private m_Email As String
   	End Class
   
   

5. After this we need to create a database that will store the user information. Modify the Install_identity_tables.sql script, which goes with dotConnect for MySQL. By default, this script is in the Program Files\Devart\dotConnect\MySQL\Web\ASP.NET Identity 1 folder. You can also copy this script from the Identity Database Script chapter of this topic. You may use any tool to execute this script, for example phpMyAdmin or dbForge Fusion for MySQL.. Add a column for storing emails to the AspNetUsers table.

   Before adding the column:

   CREATE TABLE AspNetUsers ( 
     Id varchar(128) NOT NULL,
     UserName varchar(166) NOT NULL,
     PasswordHash varchar(256) NULL,
     SecurityStamp varchar(256) NULL,
     PRIMARY KEY (Id)
   );
   

   After adding the column:

   CREATE TABLE AspNetUsers ( 
     Id varchar(128) NOT NULL,
     UserName varchar(166) NOT NULL,
     PasswordHash varchar(256) NULL,
     SecurityStamp varchar(256) NULL,
     Email varchar(256) NULL,
     PRIMARY KEY (Id)
   );
   

6. Execute this script. You may use any tool to execute this script, for example phpMyAdmin or dbForge Fusion for MySQL.

7. After this we need to create a UserTable class descendant that will read/write the ApplicationUser objects from/to the database. It can be implemented in two ways. The first way is using SQL to read and update the database.

   • C#

     public class MyUserTable : UserTable<ApplicationUser> {
    
       public MyUserTable(DbDataSource dataSource)
         : base(dataSource) {
       }
    
       public override int Insert(ApplicationUser user) {
    
         return DataSource.ExecuteNonQuery("INSERT INTO MY_IDENTITY_SCHEMA.\"AspNetUsers\" (\"Id\", \"UserName\", \"PasswordHash\", \"SecurityStamp\", \"Email\") VALUES (:p0, :p1, :p2, :p3, :p4)",
                                           new object[] { user.Id, user.UserName, user.PasswordHash, user.SecurityStamp, user.Email });
       }
    
       public override int Update(ApplicationUser user) {
    
         return DataSource.ExecuteNonQuery("UPDATE MY_IDENTITY_SCHEMA.\"AspNetUsers\" SET \"UserName\" = :p0, \"PasswordHash\" = :p1, \"SecurityStamp\" = :p2, \"Email\" = :p3 WHERE \"Id\" = :p4",
                                           new object[] { user.UserName, user.PasswordHash, user.SecurityStamp, user.Email, user.Id });
       }
    
       protected override ApplicationUser Materialize(DataRecord record) {
    
         ApplicationUser user = base.Materialize(record);
    
         if (user != null)
           user.Email = (string)record["Email"];
    
         return user;
       }
    
     }
   

   • Visual Basic

   
   Public Class MyUserTable
   	Inherits UserTable(Of ApplicationUser)
   
   	Public Sub New(dataSource As DbDataSource)
   		MyBase.New(dataSource)
   	End Sub
   
   	Public Overrides Function Insert(user As ApplicationUser) As Integer
   
   		Return DataSource.ExecuteNonQuery("INSERT INTO MY_IDENTITY_SCHEMA.""AspNetUsers"" (""Id"", ""UserName"", ""PasswordHash"", ""SecurityStamp"", ""Email"") VALUES (:p0, :p1, :p2, :p3, :p4)", New Object() {user.Id, user.UserName, user.PasswordHash, user.SecurityStamp, user.Email})
   	End Function
   
   	Public Overrides Function Update(user As ApplicationUser) As Integer
   
   		Return DataSource.ExecuteNonQuery("UPDATE MY_IDENTITY_SCHEMA.""AspNetUsers"" SET ""UserName"" = :p0, ""PasswordHash"" = :p1, ""SecurityStamp"" = :p2, ""Email"" = :p3 WHERE ""Id"" = :p4", New Object() {user.UserName, user.PasswordHash, user.SecurityStamp, user.Email, user.Id})
   	End Function
   
   	Protected Overrides Function Materialize(record As DataRecord) As ApplicationUser
   
   		Dim user As ApplicationUser = MyBase.Materialize(record)
   
   		If user IsNot Nothing Then
   			user.Email = DirectCast(record("Email"), String)
   		End If
   
   		Return user
   	End Function
   
   End Class
   
   

   Alternatively we can create a class, which provides the same functionality, but uses the functionality of the UserTable class, inherited from AspNetTable, instead of performing SQL statements.

   • C#

   public class MyUserTable : UserTable<ApplicationUser> {
    
       public MyUserTable(DbDataSource dataSource)
         : base(dataSource) {
       }
    
       protected override List<string> GetInsertColumns() {       
           var columns = base.GetInsertColumns();      
           columns.Add("Email");      
           return columns;    
       } 
       public override int Insert(ApplicationUser user) {
    
         return Insert(user.Id, user.UserName, user.PasswordHash, user.SecurityStamp, user.Email);    
       }
    
       public override int Update(ApplicationUser user) {
    
           return Update(user.UserName, user.PasswordHash, user.SecurityStamp, user.Email, // SET                    
               user.Id // WHERE                   
           );    
       }
    
       protected override ApplicationUser Materialize(DataRecord record) {
    
           ApplicationUser user = base.Materialize(record);
    
           if (user != null)
               user.Email = (string)record["Email"];
    
           return user;
       }
    
   }
   

   • Visual Basic

   
   Public Class MyUserTable
   	Inherits UserTable(Of ApplicationUser)
   
   	Public Sub New(dataSource As DbDataSource)
   		MyBase.New(dataSource)
   	End Sub
   
   	Protected Overrides Function GetInsertColumns() As List(Of String)
   		Dim columns = MyBase.GetInsertColumns()
   		columns.Add("Email")
   		Return columns
   	End Function
   	Public Overrides Function Insert(user As ApplicationUser) As Integer
   
   		Return Insert(user.Id, user.UserName, user.PasswordHash, user.SecurityStamp, user.Email)
   	End Function
   
   	Public Overrides Function Update(user As ApplicationUser) As Integer
   
   		Return Update(user.UserName, user.PasswordHash, user.SecurityStamp, user.Email, user.Id)
   	End Function
   
   	Protected Overrides Function Materialize(record As DataRecord) As ApplicationUser
   
   		Dim user As ApplicationUser = MyBase.Materialize(record)
   
   		If user IsNot Nothing Then
   			user.Email = DirectCast(record("Email"), String)
   		End If
   
   		Return user
   	End Function
   
   End Class
   

   In this example we have overridden the GetInsertColumns() method to add the "Email" column to the list of the columns, used for generating the INSERT command. Since we haven't overridden the GetUpdateColumns() method, the same "Email" column will also be present in the column list used for generating the UPDATE command. We pass the parameter values for the commands, generated automatically, in the Insert and Update methods.

8. After you have created the MyUserTable class in one or another way, create a TableFactory descendant that returns our custom UserTable implementation, that reads and saves ApplicationUser objects from/to database.

   • C#

     public class MyTableFactory : TableFactory<ApplicationUser, IdentityRole>, ITableFactory<ApplicationUser, IdentityRole> {
    
       public MyTableFactory(DbDataSource dataSource)
         : base(dataSource) {
       }
    
       public override UserTable<ApplicationUser> CreateUserTable() {
    
         return new MyUserTable(DataSource);
       }
     }
   

   • Visual Basic

   
   Public Class MyTableFactory
   	Inherits TableFactory(Of ApplicationUser, IdentityRole)
   	Implements ITableFactory(Of ApplicationUser, IdentityRole)
   
   	Public Sub New(dataSource As DbDataSource)
   		MyBase.New(dataSource)
   	End Sub
   
   	Public Overrides Function CreateUserTable() As UserTable(Of ApplicationUser)
   
   		Return New MyUserTable(DataSource)
   	End Function
   End Class
   
   

9. Create a MySqlDataSource descendant, that creates our custom TableFactory.

   • C#

     public class MyDataSource : MySqlDataSource {
    
       public MyDataSource()
         : base() {
       }
    
       public override ITableFactory<MyIdentityUser, IdentityRole> CreateTableFactory<MyIdentityUser, IdentityRole>() {
    
         return (ITableFactory<MyIdentityUser, IdentityRole>)new MyTableFactory(this);
       }
     }
   

   • Visual Basic

   
   Public Class MyDataSource
   	Inherits MySqlDataSource
   
   	Public Sub New()
   		MyBase.New()
   	End Sub
   
   	Public Overrides Function CreateTableFactory(Of MyIdentityUser, IdentityRole)() As ITableFactory(Of MyIdentityUser, IdentityRole)
   
   		Return DirectCast(New MyTableFactory(Me), ITableFactory(Of MyIdentityUser, IdentityRole))
   	End Function
   End Class
   
   

   We also can modify the MyDataSource class constructor in order to specify connection string name instead of DefaultConnection in the config file or a custom name of the schema where the identity tables reside. The MyDataSource class constructor for it can be the following:

   • C#

       public MyDataSource()
         : base("name=MyConnection", "MY_IDENTITY_SCHEMA") {    }
   

   • Visual Basic

   
   Public Sub New()
   	MyBase.New("name=MyConnection", "MY_IDENTITY_SCHEMA")
   End Sub
   
   

10. In the web.config file of your project, replace the default connection string with your MySQL one.

    <add name="DefaultConnection" connectionString="User Id=root;Host=localhost;Database=Test;" providerName="Devart.Data.MySql" />
    	

    Or, if you are going to use another connection string name, add the new connection string.

11. Create a MySqlUserStore class descendant, that will be used in our application. We will pass it in the AccountController to the UserManager being created.

    • C#

      public class MyUserStore : MySqlUserStore<ApplicationUser, IdentityRole> {
     
        public MyUserStore()
          : base(new MyDataSource()) {
        }
      }
    

    • Visual Basic

    
    Public Class MyUserStore
    	Inherits MySqlUserStore(Of ApplicationUser, IdentityRole)
    
    	Public Sub New()
    		MyBase.New(New MyDataSource())
    	End Sub
    End Class
    
    

12. In the Controllers project folder open the AccountController.cs (or AccountController.vb for Visual Basic) file.

13. Replace the imported namespace

    • C#

    using Microsoft.AspNet.Identity.EntityFramework;
    

    • Visual Basic

    
    Imports Microsoft.AspNet.Identity.EntityFramework
    
    

    with:

    • C#

    using Devart.Common.Web.Identity;
    using Devart.Data.MySql.Web.Identity;
    

    • Visual Basic

    
    Imports Devart.Common.Web.Identity
    Imports Devart.Data.MySql.Web.Identity
    
    

14. Replace the constructor code

    • C#

            public AccountController()
                : this(new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new ApplicationDbContext())))
            {
            }
    

    • Visual Basic

    
    Public Sub New()
    	Me.New(New UserManager(Of ApplicationUser)(New UserStore(Of ApplicationUser)(New ApplicationDbContext())))
    End Sub
    
    

    with:

    • C#

            public AccountController()
                : this(new UserManager<ApplicationUser>(new MyUserStore()))        {
            }
    

    • Visual Basic

    
    Public Sub New()
    	Me.New(New UserManager(Of ApplicationUser)(New MyUserStore()))
    End Sub
    
    

15. After this we need to update our application and add code for specifying user's email. Open the Models\AccountViewModels.cs (or Models\AccountViewModels.vb for Visual Basic) file and add the email field to the RegisterViewModel class.

    Code before:

    • C#

    	public class RegisterViewModel
    	{
    		[Required]
    		[Display(Name = "User name")]
    		public string UserName { get; set; }
    
    		[Required]
    		[StringLength(100, ErrorMessage = "The {0} must be at least {2} characters long.", MinimumLength = 6)]
    		[DataType(DataType.Password)]
    		[Display(Name = "Password")]
    		public string Password { get; set; }
    
    		[DataType(DataType.Password)]
    		[Display(Name = "Confirm password")]
    		[Compare("Password", ErrorMessage = "The password and confirmation password do not match.")]
    		public string ConfirmPassword { get; set; }
    	}
    

    • Visual Basic

    
    	Public Class RegisterViewModel
    		<Required> _
    		<Display(Name := "User name")> _
    		Public Property UserName() As String
    			Get
    				Return m_UserName
    			End Get
    			Set
    				m_UserName = Value
    			End Set
    		End Property
    		Private m_UserName As String
    
    		<Required> _
    		<StringLength(100, ErrorMessage := "The {0} must be at least {2} characters long.", MinimumLength := 6)> _
    		<DataType(DataType.Password)> _
    		<Display(Name := "Password")> _
    		Public Property Password() As String
    			Get
    				Return m_Password
    			End Get
    			Set
    				m_Password = Value
    			End Set
    		End Property
    		Private m_Password As String
    
    		<DataType(DataType.Password)> _
    		<Display(Name := "Confirm password")> _
    		<Compare("Password", ErrorMessage := "The password and confirmation password do not match.")> _
    		Public Property ConfirmPassword() As String
    			Get
    				Return m_ConfirmPassword
    			End Get
    			Set
    				m_ConfirmPassword = Value
    			End Set
    		End Property
    		Private m_ConfirmPassword As String
    	End Class
    
    

    Code after:

    • C#

    	public class RegisterViewModel
    	{
    		[Required]
    		[Display(Name = "User name")]
    		public string UserName { get; set; }
     
    		[Required]
    		[StringLength(100, ErrorMessage = "The {0} must be at least {2} characters long.", MinimumLength = 6)]
    		[DataType(DataType.Password)]
    		[Display(Name = "Password")]
    		public string Password { get; set; }
     
    		[DataType(DataType.Password)]
    		[Display(Name = "Confirm password")]
    		[Compare("Password", ErrorMessage = "The password and confirmation password do not match.")]
    		public string ConfirmPassword { get; set; }
     
    		[DataType(DataType.EmailAddress)]        
    		[Display(Name = "E-mail")]        
    		public string Email { get; set; }    
    	}
    

    • Visual Basic

    
    Public Class RegisterViewModel
    	<Required> _
    	<Display(Name := "User name")> _
    	Public Property UserName() As String
    		Get
    			Return m_UserName
    		End Get
    		Set
    			m_UserName = Value
    		End Set
    	End Property
    	Private m_UserName As String
    
    	<Required> _
    	<StringLength(100, ErrorMessage := "The {0} must be at least {2} characters long.", MinimumLength := 6)> _
    	<DataType(DataType.Password)> _
    	<Display(Name := "Password")> _
    	Public Property Password() As String
    		Get
    			Return m_Password
    		End Get
    		Set
    			m_Password = Value
    		End Set
    	End Property
    	Private m_Password As String
    
    	<DataType(DataType.Password)> _
    	<Display(Name := "Confirm password")> _
    	<Compare("Password", ErrorMessage := "The password and confirmation password do not match.")> _
    	Public Property ConfirmPassword() As String
    		Get
    			Return m_ConfirmPassword
    		End Get
    		Set
    			m_ConfirmPassword = Value
    		End Set
    	End Property
    	Private m_ConfirmPassword As String
    
    	<DataType(DataType.EmailAddress)> _
    	<Display(Name := "E-mail")> _
    	Public Property Email() As String
    		Get
    			Return m_Email
    		End Get
    		Set
    			m_Email = Value
    		End Set
    	End Property
    	Private m_Email As String
    End Class
    
    

16. Open the Views\Account\Register.cshtml file and edit the Register method. Add a field for email.

        <div class="form-group">
            @Html.LabelFor(m => m.Email, new { @class = "col-md-2 control-label" })
            <div class="col-md-10">
                @Html.TextBoxFor(m => m.Email, new { @class = "form-control" })
            </div>
        </div>
    		

17. Open the Controllers\AccountController.cs (or Models\AccountController.vb for Visual Basic) file and add code for passing email to the Register method of the AccountController class.

    Code before:

    • C#

    		public async Task<ActionResult> Register(RegisterViewModel model)
    		{
    			if (ModelState.IsValid)
    			{
    				var user = new ApplicationUser() { UserName = model.UserName };
    				var result = await UserManager.CreateAsync(user, model.Password);
    				if (result.Succeeded)
    				{
    					await SignInAsync(user, isPersistent: false);
    					return RedirectToAction("Index", "Home");
    				}
    				else
    				{
    					AddErrors(result);
    				}
    			}
    
    			// If we got this far, something failed, redisplay form
    			return View(model);
    		}

    • Visual Basic

    
    		Public Function Register(model As RegisterViewModel) As Task(Of ActionResult)
    			If ModelState.IsValid Then
    				Dim user = New ApplicationUser() With { _
    					Key .UserName = model.UserName _
    				}
    				Dim result = Await UserManager.CreateAsync(user, model.Password)
    				If result.Succeeded Then
    					Await SignInAsync(user, isPersistent := False)
    					Return RedirectToAction("Index", "Home")
    				Else
    					AddErrors(result)
    				End If
    			End If
    
    			' If we got this far, something failed, redisplay form
    			Return View(model)
    		End Function
    
    

    Code after:

    • C#

    		public async Task<ActionResult> Register(RegisterViewModel model)
    		{
    			if (ModelState.IsValid)
    			{
    				var user = new ApplicationUser() { UserName = model.UserName, Email = model.Email };
    				var result = await UserManager.CreateAsync(user, model.Password);
    				if (result.Succeeded)
    				{
    					await SignInAsync(user, isPersistent: false);
    					return RedirectToAction("Index", "Home");
    				}
    				else
    				{
    					AddErrors(result);
    				}
    			}
    
    			// If we got this far, something failed, redisplay form
    			return View(model);
    		}

    • Visual Basic

    
    		Public Function Register(model As RegisterViewModel) As Task(Of ActionResult)
    			If ModelState.IsValid Then
    				Dim user = New ApplicationUser() With { _
    					Key .UserName = model.UserName, _
    					Key .Email = model.Email _
    				}
    				Dim result = Await UserManager.CreateAsync(user, model.Password)
    				If result.Succeeded Then
    					Await SignInAsync(user, isPersistent := False)
    					Return RedirectToAction("Index", "Home")
    				Else
    					AddErrors(result)
    				End If
    			End If
    
    			' If we got this far, something failed, redisplay form
    			Return View(model)
    		End Function
    
    

Now we can run our application and check if everything works correctly.

1. Run the application by pressing CTRL+F5.
   
   
2. Switch to the Register tab on the top of the page.
   
   
   
   For an example with extended ASP.NET Identity functionality the page looks like the following:
   
   
3. Enter a new user name and password (and email - if you have created an example with extended ASP.NET Identity functionality) to the corresponding boxes and click the Register button.
4. The new user is now registered and logged in.
   
   
5. After this you may use an appropriate database tool to connect to the database where the user data is stored and verify that the data is stored correctly.

CREATE TABLE AspNetRoles ( 
  Id varchar(128) NOT NULL,
  Name varchar(166) NOT NULL,
  PRIMARY KEY (Id)
);

CREATE TABLE AspNetUsers ( 
  Id varchar(128) NOT NULL,
  UserName varchar(166) NOT NULL,
  PasswordHash varchar(256) NULL,
  SecurityStamp varchar(256) NULL,
  PRIMARY KEY (Id)
);

CREATE TABLE AspNetUserClaims ( 
  Id int AUTO_INCREMENT UNIQUE NOT NULL,
  ClaimType varchar(256) NULL,
  ClaimValue varchar(256) NULL,
  UserId varchar(128) NOT NULL,
  PRIMARY KEY (Id)
);

CREATE TABLE AspNetUserLogins ( 
  UserId varchar(128) NOT NULL,
  LoginProvider varchar(128) NOT NULL,
  ProviderKey varchar(128) NOT NULL,
  PRIMARY KEY (UserId, LoginProvider, ProviderKey)
);

CREATE TABLE AspNetUserRoles ( 
  UserId varchar(128) NOT NULL,
  RoleId varchar(128) NOT NULL,
  PRIMARY KEY (UserId, RoleId)
);

CREATE INDEX IX_AspNetUserClaims_UserId ON AspNetUserClaims (UserId);

CREATE INDEX IX_AspNetUserLogins_UserId ON AspNetUserLogins (UserId);

CREATE INDEX IX_AspNetUserRoles_RoleId ON AspNetUserRoles (RoleId);

CREATE INDEX IX_AspNetUserRoles_UserId ON AspNetUserRoles (UserId);

ALTER TABLE AspNetUserClaims
  ADD CONSTRAINT FK_AspNetUserClaims_AspNetUsers_UserId FOREIGN KEY (UserId) REFERENCES AspNetUsers (Id)
  ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE AspNetUserLogins
  ADD CONSTRAINT FK_AspNetUserLogins_AspNetUsers_UserId FOREIGN KEY (UserId) REFERENCES AspNetUsers (Id)
  ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE AspNetUserRoles
  ADD CONSTRAINT FK_AspNetUserRoles_AspNetRoles_RoleId FOREIGN KEY (RoleId) REFERENCES AspNetRoles (Id)
  ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE AspNetUserRoles
  ADD CONSTRAINT FK_AspNetUserRoles_AspNetUsers_UserId FOREIGN KEY (UserId) REFERENCES AspNetUsers (Id)
  ON DELETE CASCADE ON UPDATE NO ACTION;