ASP.NET Core Identity with ClearDB MySql

Separation of concerns and n-tiered architecture in ASP.NET 5/ASP.NET Core 1

I'm struggling to find a graceful way to keep my DAL layer separate to my MVC/UI layer in ASP.NET 5 thanks to the new built in Dependency Injection which I want to use....For example I have an ASP.NET 5 project, a Business Layer project and a Data Access Project where I have various Entity Framework code such as entities and contexts. in ASP.NET 5 ...

Entity framework Core with Identity and ASP.NET Core RC2 not creating user in database

I am working on an application with authentication. I am using the following frameworks:...ASP.NET Core RC2...Entity Framework Core...The Npgsql EFCore driver...For seeding I created a ...DataSeeder... class, that gets added as Transient Service in the ...ConfigureServices... function and later called in the Configure function. It checks whether a...

ASP.NET Core Identity: the base class (IdentityUser, IdentityRole, IdentityUserRole e.t.c.) Implementation

Context:...public class ApplicationDbContext : IdentityDbContext<ApplicationUser, ApplicationRole, Guid, UserClaim, UserRole, UserLogin, RoleClaim, UserToken> { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { } ...

NotImplemented Exceptions using MySQL Provider in ASP.NET Core With EF Core

I am building an ASP.NET Core 1.1.0 application that needs to access an existing MySQL database using Entity Framework Core, which I'm building in Visual Studio 2015 with all the latest updates. I started using the "official" MySQL provider (MySql.Data.EntityFrameworkCore), but have the same problem with the Pomelo prvider (Pomelo.EntityFrameworkCo...

asp.net core/EF-Core mysql update database error

I am absolutely new to asp.net core development. I am trying to create a simple asp.net core web api with a single model and mysql to store the model data and then I would want to retrieve it as REST API perhaps using Swagger....My current set up looks like following: ...Books.cs:...using Microsoft.EntityFrameworkCore; using MySQL.Data.EntityFramew...

Entity framework Core with Identity and ASP.NET Core 1.1 Seeding

I am try seeding initial data from my database, but the informacion for this tecnology is really poor. After seek many options, i find i can how send inicial data for IdentityRole and IdentityUser in this post...Entity framework Core with Identity and ASP.NET Core RC2 not creating user in database...But the user say after add service like Transient...

Different user types with ASP.NET Core 1.1 Identity and Entity Framework Core

Using ASP.NET Core Identity with Entity framework Core i need to add different types of users in my app:...Let's say that i need two types of users: "Student" and "Teacher"; both of them are also ApplicationUsers since they have to be authenticated to access the app....I have accomplish that creating two tables: one for Student and one for Teacher....

Force inherited classes in ASP.NET Core Entity Framework Core to dedicated MySQL table

Having a model ...Thread... that should countain all attributes of another model called ...Post... I use inheritance:...class Post { public int Id{get;set;} public string Title{get;set;} // ... } class Thread: Post { public int ForumId{get;set;} // ... } ...EF Core put both in a single table and adds the column ...Discriminator....

Call MySql stored procedure which take 2 parameters from asp.net core 2.2 web API controller

What is a proper way of calling a stored procedure with 2 parameters and getting result back which contain 10 columns and 403 records....Below is the code I have written....try { string startDate = procedureResource.StartDate.ToString("yyyy-MM-dd") + " 00:00:00"; string endDate = procedureResource.EndDate.ToString("yyyy-MM-dd") + " 23:59:5...

How to map columns in Custom model to Identity model in ASP.NET Core Identity

I am implementing ASP.NET Core Identity in an existing project with an existing Database....I have specified the Entities to use for ...IdentityUser... and ...IdentityRole... like this:...public partial class MyContext : IdentityDbContext<MyUser, MyRole, int> ...In ...Startup.cs...:...services.AddIdentity<MyUser, MyRole>(options => { ...