如何在ASP.NET MVC 5 Identity 2.0中使用ASP.NET MVC 5 Identity 2.0中的AspNetUser表（Id列）的Customer表（CreatedBy列）中添加外键 [英] How to add a Foreign key in Customer table (CreatedBy column) for AspNetUser table (Id column) in ASP.NET MVC 5 Identity 2.0 using Code First

问题描述

我已经使用Visual Studio 2013 Update 2 RC
& amp;然后添加AspNet身份样本：

I have created Empty MVC (ASP.NET Web Application) project using Visual Studio 2013 Update 2 RC & then added AspNet Identity Samples using:

PM>安装包Microsoft.AspNet.Identity.Samples -Pre

PM>Install-Package Microsoft.AspNet.Identity.Samples -Pre

我启用并添加了迁移和然后更新数据库，创建默认表。

I have enabled and added migrations & then updated database, which created default tables.

I要创建包含2列作为外键的Customer表：

I want to create Customer table which contains 2 columns as Foreign Keys to:

• 组表（GroupId列）


• AspNetUsers表（Id列）

所以我创建了2个类Customer&使用数据注释组合并添加外键，如下所示：

So I have created 2 classes Customer & Group and added Foreign Keys using Data-annotations as shown below:

namespace IdentitySample.Models
{
    // 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 async Task<ClaimsIdentity> GenerateUserIdentityAsync(UserManager<ApplicationUser> manager)
        {
            // Note the authenticationType must match the one defined in CookieAuthenticationOptions.AuthenticationType
            var userIdentity = await manager.CreateIdentityAsync(this, DefaultAuthenticationTypes.ApplicationCookie);
            // Add custom user claims here
            return userIdentity;
        }
    }

    public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
    {
        public ApplicationDbContext()
            : base("DefaultConnection", throwIfV1Schema: false)
        {
        }

        static ApplicationDbContext()
        {
            // Set the database intializer which is run once during application start
            // This seeds the database with admin user credentials and admin role
            Database.SetInitializer<ApplicationDbContext>(new ApplicationDbInitializer());
        }

        public static ApplicationDbContext Create()
        {
            return new ApplicationDbContext();
        }
        public DbSet<Customer> Customers { get; set; }
        public DbSet<Group> Groups { get; set; }
    }

    public class Customer
    {
        public int CustomerId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public int Age { get; set; }
        public int GroupId { get; set; }
        public string CreatedBy { get; set; }



        [ForeignKey("GroupId")]
        public Group Groups { get; set; }

        [ForeignKey("CreatedBy")]
        public ApplicationUser ApplicationUsers { get; set; }
    }

    public class Group
    {
        public int GroupId { get; set; }
        public string GroupName { get; set; }
    }
}

一切似乎都很好，ApplicationDbContext.edmx图创建使用EF电动工具也看起来很好项目正确构建。

Everything seems fine, the ApplicationDbContext.edmx diagram created using EF Power tools also looks fine & project builds properly.

然后，我使用MVC 5控制器的视图，使用实体框架脚手架模板添加了CustomersController。

I have then added CustomersController using "MVC 5 Controller with views, using Entity Framework" scaffolding template.

img src =https://i.stack.imgur.com/WGFGF.pngalt =enter image description here>

现在我正在编译错误（在db.ApplicationUsers）

Now I am getting compilation error (at db.ApplicationUsers)

// GET: Customers/Create
public ActionResult Create()
{
    ViewBag.CreatedBy = new SelectList(db.ApplicationUsers, "Id", "Email");
    ViewBag.GroupId = new SelectList(db.Groups, "GroupId", "GroupName");
    return View();
}

错误详细信息：
'IdentitySample.Models.ApplicationDbContext'不包含'ApplicationUsers'的定义和没有扩展方法'ApplicationUsers'接受类型'IdentitySample.Models.ApplicationDbContext'的第一个参数可以找到（你缺少一个using指令或程序集引用吗？）

当我在 ApplicationDbContext 中添加以下代码

public DbSet<ApplicationUser> ApplicationUsers { get; set; }

我收到错误：

不支持每种类型的多个对象集。对象集
'ApplicationUsers'和'Users'都可以包含
'IdentitySample.Models.ApplicationUser'

Multiple object sets per type are not supported. The object sets 'ApplicationUsers' and 'Users' can both contain instances of type 'IdentitySample.Models.ApplicationUser'

$ b $的实例b

我想添加CreatedBy作为AspNetUsers的外键，使用该模板生成类似于GroupId下拉列表的CreatedBy下拉列表：

< img src =https://i.stack.imgur.com/Pnj4S.pngalt =在此输入图像说明>

我们如何使用身份生成的表与其他用户创建的表，其中用户创建的表具有对Identity生成的表的外键引用。并且具有使用MVC 5控制器与视图，使用实体框架的一级脚手架代码生成体验？

（类似于我们对Customers& Groups表的使用，客户表具有GroupId外键引用）

推荐答案

RTFE：您没有属性ApplicationUsers在您的 ApplicationDbContext class。

RTFE: you do not have a property ApplicationUsers on your ApplicationDbContext class.

只需添加：

    public DbSet<ApplicationUser> ApplicationUsers { get; set; }

这篇关于如何在ASP.NET MVC 5 Identity 2.0中使用ASP.NET MVC 5 Identity 2.0中的AspNetUser表（Id列）的Customer表（CreatedBy列）中添加外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！