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 Oracle. By default, this script is in the Program Files\Devart\dotConnect\Oracle\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 SQL*Plus or dbForge Fusion for Oracle. 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.Oracle.Web.Identity;
   using ApplicationUser = Devart.Common.Web.Identity.IdentityUser;
   

   • Visual Basic

   
   Imports Devart.Common.Web.Identity
   Imports Devart.Data.Oracle.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 OracleUserStore()))        
   	{
   	}
   

   • Visual Basic

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

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

   <add name="DefaultConnection" connectionString="User Id=Scott;Password=tiger;Data Source=Ora;" providerName="Devart.Data.Oracle" />
   	

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.Oracle.Web.Identity;
   

   • Visual Basic

   
   Imports Devart.Common.Web.Identity
   Imports Devart.Data.Oracle.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 Oracle. By default, this script is in the Program Files\Devart\dotConnect\Oracle\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 SQL*Plus or dbForge Fusion for Oracle.. Add a column for storing emails to the AspNetUsers table.

   Before adding the column:

     CREATE TABLE "AspNetUsers" ( 
       "Id" NVARCHAR2(128) NOT NULL,
       "UserName" NVARCHAR2(256) NOT NULL,
       "PasswordHash" NVARCHAR2(256) NULL,
       "SecurityStamp" NVARCHAR2(256) NULL,
       PRIMARY KEY ("Id")
     )
   

   After adding the column:

     CREATE TABLE "AspNetUsers" ( 
       "Id" NVARCHAR2(128) NOT NULL,
       "UserName" NVARCHAR2(256) NOT NULL,
       "PasswordHash" NVARCHAR2(256) NULL,
       "SecurityStamp" NVARCHAR2(256) NULL,
       "Email" NVARCHAR2(256) NULL,    
       PRIMARY KEY ("Id")
     )
   

6. Execute this script. You may use any tool to execute this script, for example SQL*Plus or dbForge Fusion for Oracle.

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 an OracleDataSource descendant, that creates our custom TableFactory.

   • C#

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

   • Visual Basic

   
   Public Class MyDataSource
   	Inherits OracleDataSource
   
   	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. You may need to specify the custom schema name, for example, if the user you connect to is different than the user, in whose schema the identity tables are stored. 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 Oracle one.

    <add name="DefaultConnection" connectionString="User Id=Scott;Password=tiger;Data Source=Ora;" providerName="Devart.Data.Oracle" />
    	

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

11. Create an OracleUserStore 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 : OracleUserStore<ApplicationUser, IdentityRole> {
     
        public MyUserStore()
          : base(new MyDataSource()) {
        }
      }
    

    • Visual Basic

    
    Public Class MyUserStore
    	Inherits OracleUserStore(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.Oracle.Web.Identity;
    

    • Visual Basic

    
    Imports Devart.Common.Web.Identity
    Imports Devart.Data.Oracle.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" NVARCHAR2(128) NOT NULL,
  "Name" NVARCHAR2(256) NOT NULL,
  PRIMARY KEY ("Id")
)
/

CREATE TABLE "AspNetUsers" ( 
  "Id" NVARCHAR2(128) NOT NULL,
  "UserName" NVARCHAR2(256) NOT NULL,
  "PasswordHash" NVARCHAR2(256) NULL,
  "SecurityStamp" NVARCHAR2(256) NULL,
  PRIMARY KEY ("Id")
)
/

CREATE TABLE "AspNetUserClaims" ( 
  "Id" NUMBER(10) NOT NULL,
  "ClaimType" NVARCHAR2(256) NULL,
  "ClaimValue" NVARCHAR2(256) NULL,
  "UserId" NVARCHAR2(128) NOT NULL,
  PRIMARY KEY ("Id")
)
/

CREATE SEQUENCE "AspNetUserClaims_SEQ"
/

CREATE OR REPLACE TRIGGER "AspNetUserClaims_INS_TRG"
  BEFORE INSERT ON "AspNetUserClaims"
  FOR EACH ROW
BEGIN
  SELECT "AspNetUserClaims_SEQ".NEXTVAL INTO :NEW."Id" FROM DUAL;
END;
/

CREATE TABLE "AspNetUserLogins" ( 
  "UserId" NVARCHAR2(128) NOT NULL,
  "LoginProvider" NVARCHAR2(128) NOT NULL,
  "ProviderKey" NVARCHAR2(128) NOT NULL,
  PRIMARY KEY ("UserId", "LoginProvider", "ProviderKey")
)
/

CREATE TABLE "AspNetUserRoles" ( 
  "UserId" NVARCHAR2(128) NOT NULL,
  "RoleId" NVARCHAR2(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_UserClaims_Users" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id")
  ON DELETE CASCADE
/

ALTER TABLE "AspNetUserLogins"
  ADD CONSTRAINT "FK_UserLogins_Users" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id")
  ON DELETE CASCADE
/

ALTER TABLE "AspNetUserRoles"
  ADD CONSTRAINT "FK_UserRoles_Roles" FOREIGN KEY ("RoleId") REFERENCES "AspNetRoles" ("Id")
  ON DELETE CASCADE
/

ALTER TABLE "AspNetUserRoles"
  ADD CONSTRAINT "FK_UserRoles_Users" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id")
  ON DELETE CASCADE
/