Исключение Sql: неверное имя столбца «NormalizedUserName». ⇐ C#

[Anonymous]

Я новичок в asp.net core, и я создал приложение с Asp.Net Core 2.2 +EF, используя Identity Core для создания страницы регистрации, и я получил эту ошибку после того, как запустил приложение и ввел некоторые тестовые данные (электронная почта, пароль):

SqlException: Invalid column name 'NormalizedUserName'.
Invalid column name 'AccessFailedCount'.
Invalid column name 'ConcurrencyStamp'.
Invalid column name 'Email'.
Invalid column name 'EmailConfirmed'.
Invalid column name 'LockoutEnabled'.
Invalid column name 'LockoutEnd'.
Invalid column name 'NormalizedEmail'.
Invalid column name 'NormalizedUserName'.
Invalid column name 'PasswordHash'.
Invalid column name 'PhoneNumber'.
Invalid column name 'PhoneNumberConfirmed'.
Invalid column name 'SecurityStamp'.
Invalid column name 'TwoFactorEnabled'.
Invalid column name 'UserName'.


Я создал таблицу, и у меня нет столбцов с такими названиями, как указано выше (у меня только «Адрес электронной почты» и «Пароль»)

Контроллер учетной записи (игнорируйте методы ВХОДА):

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.AspNetCore.Mvc;
using XmlViewer.Models;
using XmlViewer.ViewModels;

namespace XmlViewer.Controllers
{
public class AccountController : Controller
{
private readonly UserManager _userManager;
private readonly SignInManager _signInManager;

public AccountController(UserManager userManager, SignInManager signInManager)
{
_userManager = userManager;
_signInManager = signInManager;
}

[HttpGet]

[HttpGet]

public IActionResult Login()
{
return View();
}
[HttpPost]

public async Task Login(LoginViewModel vm)//model binding
{
//date din vm sunt bune:
if(ModelState.IsValid)
{
var result = await _signInManager.PasswordSignInAsync(vm.Email, vm.Password, vm.RememberMe, false);//folosit para pt IsPersistent(BOOL)
if(result.Succeeded)
{
return RedirectToAction("Privacy", "Home");
}
ModelState.AddModelError("","Invalid Login. Please Check your username/email or password.");
return View(vm);
}
return View(vm);
}

public IActionResult Register()
{
return View();
}

[HttpPost]

public async Task Register(RegisterViewModel vm)//model binding
{
if (ModelState.IsValid)
{

var user = new ApplicationUser { UserName = vm.Email, Email = vm.Email };
var result = await _userManager.CreateAsync(user, vm.Password);

if (result.Succeeded)
{
await _signInManager.SignInAsync(user, false);
return RedirectToAction("Index", "Home");

}
else
{
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error.Description); //erori de inregistrare in cont
}//iterare prin fiecare eroare

}
}
return View(vm);
}
}
}


Контекстная модель:

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

namespace XmlViewer.Models
{
public class XmlViewerContext : IdentityDbContext
{
//constructor
//added migration Initial-Migration:tabelul de date in DB se creeaza dupa
public XmlViewerContext(DbContextOptions options) : base(options)
{

}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);

modelBuilder.Entity().ToTable("Register").Property(p => p.Id).HasColumnName("EmailAddress"); ;
modelBuilder.Entity().ToTable("Register").Property(p => p.Id).HasColumnName("Password");

}
}
}


Запуск:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.HttpsPolicy;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.EntityFrameworkCore;
using XmlViewer.Models;
using Microsoft.AspNetCore.Identity;

namespace XmlViewer
{
public class Startup
{
public static int Progress { get; set; }
public Startup(IConfiguration configuration)
{
Configuration = configuration;
}

public IConfiguration Configuration { get; }

// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.Configure(options =>
{
// This lambda determines whether user consent for non-essential cookies is needed for a given request.
options.CheckConsentNeeded = context => true;
options.MinimumSameSitePolicy = SameSiteMode.None;
});
services.AddIdentity()
.AddEntityFrameworkStores()
.AddDefaultTokenProviders();
services.AddDbContext(options => options.UseSqlServer(@"Data Source = (localdb)\ProjectsV13; Initial Catalog = XmlViewer; Integrated Security = True; Connect Timeout = 30;"));
//Alta baza de date nu master
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);

}

// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseAuthentication();
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();

app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Account}/{action=Register}/{id?}");
});
}
}
}


Подробнее здесь: https://stackoverflow.com/questions/580 ... edusername