Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
387 views
in Technique[技术] by (71.8m points)

entity framework - EF Core Fluent API statement as Data Annotation

Can I write this with data annotations in EF Core?

modelBuilder.Entity<DiagramComponent>()
                .HasOne(c => c.Compressor)
                .WithMany(c => c.Components);
question from:https://stackoverflow.com/questions/65882725/ef-core-fluent-api-statement-as-data-annotation

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

You will have to create one more class:

public class DiagramComponentComponent
    {
        public int DiagramComponentId { get; set; }
        public int ComponentId { get; set; }

        [ForeignKey(nameof(DiagramComponentId))]
        public virtual DiagramComponent DiagramComponent { get; set; }

        [ForeignKey(nameof(ComponentId))]
        public virtual Component Component { get; set; }
    }

and add attributes to existing classes:

public class DiagramComponent
    {
        public int CompressorId { get; set; }

        [ForeignKey(nameof(CompressorId))]
        [InverseProperty("DiagramComponents")]
        public virtual Compressor Compressor { get; set; }

[InverseProperty(nameof(DiagramComponentComponent.DiagramComponent))]
public virtual ICollection<DiagramComponentComponent> DiagramComponentComponents { get; set; }
    }
    public class Compressor
    {
        [InverseProperty(nameof(DiagramComponent.Compressor))]
        public virtual ICollection<DiagramComponent> DiagramComponents { get; set; }

    }
    public class Component
    {
[InverseProperty(nameof(DiagramComponentComponent.Component))]
public virtual ICollection<DiagramComponentComponent> DiagramComponentComponents { get; set; }

    }

and add to dbcontext:

modelBuilder.Entity<DiagramComponentComponent>(entity =>
            {
                entity.HasOne(d => d.DiagramComponent )
                    .WithMany()
                    .HasForeignKey(d => d.DiagramComponentId )
                    .OnDelete(DeleteBehavior.ClientSetNull)
          .HasConstraintName("FK_DiagramComponentComponent_Component_Diagram");

                entity.HasOne(d => d.Component)
                    .WithMany()
                    .HasForeignKey(d => d.ComponentId )
                    .OnDelete(DeleteBehavior.ClientSetNull)
                    .HasConstraintName("FK_DiagramComponentComponent_Component");
            });

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...