EntityFramework 之 1 - 1关联

最新推荐文章于 2019-06-30 20:04:24 发布

weixin_30920091

最新推荐文章于 2019-06-30 20:04:24 发布

阅读量108

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/two/p/5264864.html

本文详细介绍了如何在C#中创建包含项目、基本信息和资金信息的复杂实体关系模型，并通过配置实现双向依赖关系。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public class Project
    {
        public string Id { get; set; }
        public string Name { get; set; }

        public virtual BaseInfo BaseInfo { get; set; }
        public virtual MoneyInfo MoneyInfo { get; set; }

        public Project()
        {
            this.Id = Guid.NewGuid().ToString();
            this.BaseInfo = new BaseInfo();
            this.BaseInfo.ProjectId = this.Id;
            this.MoneyInfo = new MoneyInfo();
            this.MoneyInfo.ProjectId = this.Id;
        }
    }

    public class BaseInfo
    {
        public string ProjectId { get; set; }
        public string No { get; set; }
        public double Area { get; set; }

        public virtual Project Project { get; set; }
    }

    public class MoneyInfo
    {
        public string ProjectId { get; set; }
        public string Unit { get; set; }
        public double Total { get; set; }

        public virtual Project Project { get; set; }
    }

    public class ProjectEntityTypeConfiguration : EntityTypeConfiguration<Project>
    {
        public ProjectEntityTypeConfiguration()
        {
            ToTable("_Project");
            HasKey(t => t.Id);

            // 这种配置必须手工先删除Info项，再删除Project
            HasOptional(p => p.BaseInfo).WithRequired(i => i.Project);
            HasOptional(p => p.MoneyInfo).WithRequired(i => i.Project);


            // 这种配置无法删除对象
            //HasRequired(p => p.BaseInfo).WithRequiredDependent(i => i.Project);
            //HasRequired(p => p.MoneyInfo).WithRequiredDependent(i => i.Project);
        }
    }

    public class MoneyInfoEntityTypeConfiguration : EntityTypeConfiguration<MoneyInfo>
    {
        public MoneyInfoEntityTypeConfiguration()
        {
            ToTable("_MoneyInfo");
            HasKey(t => t.ProjectId);
        }
    }

    public class BaseInfoEntityTypeConfiguration : EntityTypeConfiguration<BaseInfo>
    {
        public BaseInfoEntityTypeConfiguration()
        {
            ToTable("_BaseInfo");
            HasKey(t => t.ProjectId);
        }
    }

转载于:https://www.cnblogs.com/two/p/5264864.html