Support for ASP.NET Core Identity?

[RobertK]

Other than modifying the built in EFCore Template, is there any way to specify support for ASP.NET Core Identity?

[Shalex]

We are investigating ASP.NET Core Identity and working on its support "out of the box" by Devart EF Core providers.

The corresponding support will be implemented in the dotConnect providers, i.e. Entity Developer will not include any special templates for this feature.

[RobertK]

"out of the box" support for ASP.NET Core Identity, how likely and when would this feature be implemented?

[Shalex]

"out of the box" means the minimum steps to set up ASP.NET Core Identity for using it via dotConnect providers. The investigation is in progress. There is no any timeframe at the moment. We will notify you when the feature is implemented.

[RobertK]

"out of the box" means the minimum steps to set up ASP.NET Core Identity for using it via dotConnect providers. The investigation is in progress. There is no any timeframe at the moment. We will notify you when the feature is implemented.

Shalex

How do you use Entity Developer with ASP.NET Core Identity in its current state?

Our app has its own custom class models and ASP.NET Identity has its own class models
User
UserLogin
UserRole
UserClaim
RoleClaim
UserToken

Our class model reference User identity model, so now we have a problem!?

[RobertK]

I worked out how to add asp.net identity support to the context code generator template.

But now the class model, every time the generator detects a predefined identity class model name, it would add code that looks something like the code shown below, in addition to this the code generator would have to remove properties that have already been defined by identity. (it might be best if devart let us configure the code generators behaviour for specific class models???)

Code: Select all

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;

namespace MyApp.Models
{
    public partial class User : IdentityUser<long>
    {
        public DateTime? Created { get; set; }
        public DateTime? Updated { get; set; }

    }
    public partial class UserLogin : IdentityUserLogin<long>
    {
    }
    public partial class UserRole : IdentityUserRole<long>
    {
    }
    public partial class UserClaim : IdentityUserClaim<long>
    {
    }
    public partial class Role : IdentityRole<long>
    {
    }
    public partial class RoleClaim : IdentityRoleClaim<long>
    {
    }
    public partial class UserToken : IdentityUserToken<long>
    {
    }

}

[Shalex]

1. You are working with PostgreSQL Server via dotConnect for PostgreSQL, aren't you?

2. The ASP.NET Core Identity support will be implemented at the provider level (via EF Code-First). The predefined PostgreSQL shema will be created by EF Code-First Migrations via dotConnect for PostgreSQL. There is no need to employ Entity Developer for this task. We will notify you when the feature is implemented.

[RobertK]

1. You are working with PostgreSQL Server via dotConnect for PostgreSQL, aren't you?

2. The ASP.NET Core Identity support will be implemented at the provider level (via EF Code-First). The predefined PostgreSQL shema will be created by EF Code-First Migrations via dotConnect for PostgreSQL. There is no need to employ Entity Developer for this task. We will notify you when the feature is implemented.

I am using npgsql npgsql.org would this be a problem?

[Shalex]

We do not provide support for Npgsql provider (please contact its vendor).

Concerning dotConnect for PostgreSQL, the next public build will include the following improvements:
* The support of EF Core models with string columns, which are defined without length limit and participate in PKs, FKs, indices, is improved
* The compatibility with ASP.NET Core Identity is improved

[Shalex]

dotConnect for PostgreSQL 7.9 is released: viewtopic.php?f=3&t=35438.

[RobertK]

dotConnect for PostgreSQL 7.9 is released: viewtopic.php?f=3&t=35438.

I'm unable to determine how to turn on support for asp.net core identity?

[Shalex]

Simple walkthrough:

* install dotConnect for PostgreSQL v7.9 Professional Trial

* create File > New > Project > Installed > Visual C# > Web > ASP.NET Core Web Application (.NET Core), select Web Application and set Authentication: Individual User Accounts

* run command via Package Manager Console
PM> install-package Devart.Data.PostgreSql.EFCore -Source:"https://www.nuget.org/api/v2/"

* replace
options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
with
options.UsePostgreSql(Configuration.GetConnectionString("DefaultConnection")));
in Startup.cs

* set your DefaultConnection for PostgreSQL in appsettings.json

* execute command via Package Manager Console
PM> update-database

[RobertK]

Simple walkthrough:

* install dotConnect for PostgreSQL v7.9 Professional Trial

* create File > New > Project > Installed > Visual C# > Web > ASP.NET Core Web Application (.NET Core), select Web Application and set Authentication: Individual User Accounts

* run command via Package Manager Console
PM> install-package Devart.Data.PostgreSql.EFCore -Source:"https://www.nuget.org/api/v2/"

* replace
options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
with
options.UsePostgreSql(Configuration.GetConnectionString("DefaultConnection")));
in Startup.cs

* set your DefaultConnection for PostgreSQL in appsettings.json

* execute command via Package Manager Console
PM> update-database

Thanks for the prompted response.

I'm slightly confused. isn't this the way you always set it up?...Even so, if you do this, Entity developer, still would not automatically add identity framework inherenance to custom tables. The software is unable to determine which is an identity framework entity vs regular entity.... Unless there's someway to tag the class model in entity developer?

[Shalex]

Our current roadmap for Entity Developer doesn't include any template for extending standard ASP.NET Core Identity functionality. Please submit your suggestion at https://devart.uservoice.com/forums/386 ... -developer.

[RobertK]

Our current roadmap for Entity Developer doesn't include any template for extending standard ASP.NET Core Identity functionality. Please submit your suggestion at https://devart.uservoice.com/forums/386 ... -developer.

What does the current ASP.NET Core Identity support include?