Custom ASP.NET Identity Storage Providers using ADO.NET
| Database | Status | Supported Versions | ADO.NET Driver | NuGet Package |
|---|---|---|---|---|
| MySql | Planned | (TBD) | ||
| Oracle | Beta | Only 11g tested | Oracle.ManagedDataAccess | AspNet.Identity.AdoNet.Oracle |
| PostgreSQL | Planned | (TBD) | ||
| SQL Server | Planned | (TBD) |
If you would like a database provider implemented that isn't already completed, please submit an issue, or even better, submit a pull request with your changes.
Note: Currently, only a provider for Oracle has been implemented so these instructions explain the changes necessary for using that package. Although, the steps should be identical for other providers with only the NuGet package and
usingnamespaces differing.
-
Install the
Install-Package AspNet.Identity.AdoNet.Oraclepackage from NuGet.Note: Make sure to include the
PreReleaseoption, as this package hasn't been tested for a full 1.0 release yet.
You can also uninstall the Microsoft.AspNet.Identity.EntityFramework package. And if you're not using Entity Framework at all, you can remove that package as well.
-
In your
App_Start/IdentityConfig.csfile, update the using statements like so:using AspNet.Identity.AdoNet; // <== Add this // using Microsoft.AspNet.Identity.EntityFramework; // <== Comment out/remove this
-
In your
Models/IdentityModels.csfile, update the usings statements like so:using AspNet.Identity.AdoNet; // <== Add this using AspNet.Identity.AdoNet.Oracle; // <== Add this // using Microsoft.AspNet.Identity.EntityFramework; // <== Comment out/remove this
Configure your
ApplicationDbContextclass to look like this:public class ApplicationDbContext : OracleIdentityDbContext { static readonly string connectionString = System.Configuration.ConfigurationManager .ConnectionStrings["DefaultConnection"].ConnectionString; public ApplicationDbContext() : base(connectionString) { } public static ApplicationDbContext Create() { return new ApplicationDbContext(); } }
Don't like the default names used for the database objects, or have an existing database you need to use? No problem!
You can can customize the names of the database objects by providing a custom nomenclature for each table when creating the database context. Here's an example of providing custom table and column names for each table with the Oracle provider:
public class ApplicationDbContext : OracleIdentityDbContext
{
static readonly string connectionString =
System.Configuration.ConfigurationManager
.ConnectionStrings["DefaultConnection"].ConnectionString;
// The OracleContextNomenclature will use the default nomenclature
// if we don't specify a custom nomenclature for any of the tables.
static readonly OracleContextNomenclature nomenclature = new OracleContextNomenclature
{
RolesTableNomenclature =
new RolesTableNomenclature(tableName: "APP_ROLES",
roleIdColumnName: "ID",
roleNameColumnName: "NAME"),
UserClaimsTableNomenclature =
new UserClaimsTableNomenclature(tableName: "APP_USERCLAIMS",
claimIdColumnName: "ID",
userIdColumnName: "USERID",
claimTypeColumnName: "CLAIMTYPE",
claimValueColumnName: "CLAIMVALUE"),
UserLoginsTableNomenclature =
new UserLoginsTableNomenclature(tableName: "APP_USERLOGINS",
userIdColumnName: "USERID",
providerNameColumnName: "LOGINPROVIDER",
providerKeyColumnName: "PROVIDERKEY"),
UserRolesTableNomenclature =
new UserRolesTableNomenclature(tableName: "APP_USERROLES",
userIdColumnName: "USERID",
roleIdColumnName: "ROLEID"),
UsersTableNomenclature =
new UsersTableNomenclature(tableName: "APP_USERS",
userIdColumnName: "ID",
userNameColumnName: "USERNAME",
emailAddressColumnName: "EMAIL",
emailConfirmedColumnName: "EMAILCONFIRMED",
passwordHashColumnName: "PASSWORDHASH",
securityStampColumnName: "SECURITYSTAMP",
phoneNumberColumnName: "PHONENUMBER",
phoneNumberConfirmedColumnName: "PHONENUMBERCONFIRMED",
twoFactorAuthorizationEnabledColumnName: "TWOFACTORENABLED",
lockoutEndDateUtcColumnName: "LOCKOUTENDDATEUTC",
lockoutEnabledColumnName: "LOCKOUTENABLED",
accessFailedCountColumnName: "ACCESSFAILEDCOUNT")
};
public ApplicationDbContext() : base(connectionString, nomenclature) { }
public static ApplicationDbContext Create()
{
return new ApplicationDbContext();
}
}