Во время создания модели обнаружены ошибки проверки

Я использую Sql 2008 r2 и Visual Studio 2010 и EF 4.4. И я получаю эту ошибку, выполняя код дольше. Кодекс должен объяснять отношения базы данных.

Во время создания модели были обнаружены одна или несколько ошибок валидации:
tSystem.Data.Entity.Edm.EdmAssociationConstraint: : Количество свойств в зависимых и основных ролях в ограничении отношения должно быть одинаковым.

Я хочу решить это, используя аннотацию данных. Что я делаю?

‘Предложение

    Public Class Offer

        <Key(), DatabaseGenerated(DatabaseGeneratedOption.None)>
        Public Property Offer_ID As Integer
        Public Property Name As String

    End Class

‘Глава

Public Class Head

    <Key(), Column(Order:=0), DatabaseGenerated(DatabaseGeneratedOption.None)>
    Public Property Head_ID As Integer

    <ForeignKey("Offer_ID")>
    Public Property Offer As Offer

    <Key(), Column(Order:=1)>
    Public Property Offer_ID As Integer

    Public Property Name As String


End Class

‘Линия

   Public Class Line

        <Key(), Column(Order:=0), DatabaseGenerated(DatabaseGeneratedOption.None)>
        Public Property Line_ID As Integer

        <ForeignKey("Head_ID")>
        Public Property Head As Head

        <Key(), Column(Order:=1)>
        Public Property Head_ID As Integer

        <ForeignKey("Offer_ID")>
        Public Property Offer As Offer

        <Key(), Column(Order:=2)>
        Public Property Offer_ID As Integer

        Public Property Name As String

   End Class

‘Дбконтекст

    Public Class DatabaseContext
        Inherits DbContext

        Public Sub New(p_ConnectionString As String)
            MyBase.New(p_ConnectionString)
        End Sub

        Public Property Offers As DbSet(Of Offer)
        Public Property Heads As DbSet(Of Head)
        Public Property Lines As DbSet(Of Line)

    End Class

‘Создать простой пример

    Private Shared Sub CreateME()

        Dim offer As New Offer
        offer.Name = "Offer1"
        offer.Offer_ID = 1

        Dim head As New Head
        head.Head_ID = 1
        head.Name = "head1"
        head.Offer = offer
        head.Offer_ID = offer.Offer_ID

        Dim line As New Line
        line.Head = head
        line.Head_ID = head.Head_ID
        line.Line_Id = 1
        line.Name = "line1"
        line.Offer = offer
        line.Offer_ID = offer.Offer_ID

        Using context = New DatabaseContext(GetConnectionString())

            context.Offers.Add(offer)
            context.Heads.Add(head)
            context.Lines.Add(line)
            context.SaveChanges()
        End Using

    End Sub

Итак, вопрос в том, могу ли я решить это, используя аннотацию данных?

Должен ли я использовать конструктор моделей, описанный здесь:
Как исправить: количество свойств в зависимых и основных ролях в ограничении отношения должно быть одинаковым?

I am getting validation errors when using Entity Framework 6.2. The code was generated by using code-first from an existing database. The primary key and foreign key are both composite and use version. The code has been sanitized to just show the relevant parts. It looks like it is trying to swap the version and ID values. Any suggestions would be greatly appreciated.

public partial class MyParent
{
    public MyParent()
    {
        MyChild = new HashSet< MyChild >();
    }

    [Key]
    [Column(Order = 0)]
    [StringLength(50)]
    public string MyID { get; set; }

    [Key]
    [Column(Order = 1)]
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public int MyVersion { get; set; }
}

public partial class MyChild
{
    [Key]
    [Column(Order = 0)]
    [StringLength(50)]
    public string ChildID { get; set; }

    [Required]
    [StringLength(50)]
    [ForeignKey("MyParent) Column(Order = 1)]
    public string MyID { get; set; }

    public string NextChild { get; set;}

    [Key]
    [Column(Order = 2)]
    [ForeignKey("MyParent")]
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public int MyVersion { get; set; }

    public virtual MyParent MyParent { get; set; }
    public virtual ICollection<MyChild> MyChilds1 { get; set; }

    public virtual MyChild MyChild1 { get; set; }
}

public partial class MyContext : DbContext
{
    public MyContext()
        : base("name= MyContext ")
    {
    }

    public MyContext (string connectionString) : base(connectionString)
    {
    }

    public virtual DbSet<MyParent> MyParent { get; set; }
    public virtual DbSet<MyChild> myChild { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<MyParent>()
            .HasMany(e => e.MyChild)
            .WithRequired(e => e.MyParent)
            .HasForeignKey(e => new { e.MyID, e.MyVersion })
            .WillCascadeOnDelete(false);

        modelBuilder.Entity<MyChild>()
            .HasMany(e => e.MyChilds1)
            .WithOptional(e => e.MyChild1)
            .HasForeignKey(e => new { e.ChildID, e.MyVersion });
    }
}

Error:

«One or more validation errors were detected during model generation: MyParent_MyChild: : The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property MyVersion on entity ‘MyChild’ does not match the type of property ‘MyID’ on entity ‘MyParent’ in the referential constraint ‘MyParent_MyChild’.

MyParent_MyChild: The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property ‘ChildID’ on entity ‘MyChild’ does not match the type of property ‘MyVersion’ on entity ‘MyParent’ in the referential constraint ‘MyParent_MyChild’.

I have added a fix for the simple case. It was to add ForeignKey tags and adjust the column sequence. This does not work on more complex models i.e. self referencing tables (NextChild).

New Error:

$exception{«The navigation property ‘MyChild’ declared on type ‘MyChild.MyChilds1 has been configured with conflicting foreign keys.»} System.InvalidOperationException

The db code for the foreign keys is:

    [PK_MyChild] PRIMARY KEY CLUSTERED ([ChildID] ASC, [MyVersion] ASC),
    [FK_MyChild_MyParent] FOREIGN KEY ([MyID], [MyVersion]) REFERENCES [dbo].[MyParent]([MyID], [MyVersion]),
    [FK_MyChild_MyChild] FOREIGN KEY ([NextChild], [MyVersion]) REFERENCES [dbo].[MyChild] ([ChildID], [MyVersion])

I am getting validation errors when using Entity Framework 6.2. The code was generated by using code-first from an existing database. The primary key and foreign key are both composite and use version. The code has been sanitized to just show the relevant parts. It looks like it is trying to swap the version and ID values. Any suggestions would be greatly appreciated.

public partial class MyParent
{
    public MyParent()
    {
        MyChild = new HashSet< MyChild >();
    }

    [Key]
    [Column(Order = 0)]
    [StringLength(50)]
    public string MyID { get; set; }

    [Key]
    [Column(Order = 1)]
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public int MyVersion { get; set; }
}

public partial class MyChild
{
    [Key]
    [Column(Order = 0)]
    [StringLength(50)]
    public string ChildID { get; set; }

    [Required]
    [StringLength(50)]
    [ForeignKey("MyParent) Column(Order = 1)]
    public string MyID { get; set; }

    public string NextChild { get; set;}

    [Key]
    [Column(Order = 2)]
    [ForeignKey("MyParent")]
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public int MyVersion { get; set; }

    public virtual MyParent MyParent { get; set; }
    public virtual ICollection<MyChild> MyChilds1 { get; set; }

    public virtual MyChild MyChild1 { get; set; }
}

public partial class MyContext : DbContext
{
    public MyContext()
        : base("name= MyContext ")
    {
    }

    public MyContext (string connectionString) : base(connectionString)
    {
    }

    public virtual DbSet<MyParent> MyParent { get; set; }
    public virtual DbSet<MyChild> myChild { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<MyParent>()
            .HasMany(e => e.MyChild)
            .WithRequired(e => e.MyParent)
            .HasForeignKey(e => new { e.MyID, e.MyVersion })
            .WillCascadeOnDelete(false);

        modelBuilder.Entity<MyChild>()
            .HasMany(e => e.MyChilds1)
            .WithOptional(e => e.MyChild1)
            .HasForeignKey(e => new { e.ChildID, e.MyVersion });
    }
}

Error:

«One or more validation errors were detected during model generation: MyParent_MyChild: : The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property MyVersion on entity ‘MyChild’ does not match the type of property ‘MyID’ on entity ‘MyParent’ in the referential constraint ‘MyParent_MyChild’.

MyParent_MyChild: The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property ‘ChildID’ on entity ‘MyChild’ does not match the type of property ‘MyVersion’ on entity ‘MyParent’ in the referential constraint ‘MyParent_MyChild’.

I have added a fix for the simple case. It was to add ForeignKey tags and adjust the column sequence. This does not work on more complex models i.e. self referencing tables (NextChild).

New Error:

$exception{«The navigation property ‘MyChild’ declared on type ‘MyChild.MyChilds1 has been configured with conflicting foreign keys.»} System.InvalidOperationException

The db code for the foreign keys is:

    [PK_MyChild] PRIMARY KEY CLUSTERED ([ChildID] ASC, [MyVersion] ASC),
    [FK_MyChild_MyParent] FOREIGN KEY ([MyID], [MyVersion]) REFERENCES [dbo].[MyParent]([MyID], [MyVersion]),
    [FK_MyChild_MyChild] FOREIGN KEY ([NextChild], [MyVersion]) REFERENCES [dbo].[MyChild] ([ChildID], [MyVersion])

public class ManufacturerModelContext : DbContext
{

    public DbSet<Manufacturer> Manufacturers { get; set; }
    public DbSet<ManufacturerModel> ManufacturerModels { get; set; }
}

//Populate the cascading dropdowns for manufacturer and model
    ManufacturerModelContext mm = new ManufacturerModelContext();
    [HttpGet]
    public JsonResult GetManufacturers()
    {

        var manufacturer = from a in mm.Manufacturers
                           select a.Manufacturer1;

        return Json(manufacturer.ToList(), JsonRequestBehavior.AllowGet);

    }

    public JsonResult GetModelsByManufacturerID(string manufacturerId)
    {

        int Id = Convert.ToInt32(manufacturerId);

        var models = from a in mm.ManufacturerModels where a.ManufacturerID == Id select a;

        return Json(models);
    }

public partial class Manufacturer
{
    public Manufacturer()
    {
        this.ManufacturerModels = new HashSet<ManufacturerModel>();
    }

    public int ManufacturerID { get; set; }
    [Display(Name="Manufacturer")]
    public string Manufacturer1 { get; set; }
    [Display(Name="Manufacturer Description")]
    public string ManufacturerDescription { get; set; }
    public System.DateTime DATE_CREATED { get; set; }
    public string CREATED_BY { get; set; }
    public Nullable<System.DateTime> DATE_MODIFIED { get; set; }
    public string MODIFIED_BY { get; set; }

    public virtual ICollection<ManufacturerModel> ManufacturerModels { get; set; }

public partial class ManufacturerModel
{
    public ManufacturerModel()
    {
        this.Devices = new HashSet<Device>();
    }

    public int ManufacturerModelID { get; set; }
    [Display(Name="Manufacturer")]
    public int ManufacturerID { get; set; }
    public string Model { get; set; }
    [Display(Name="Model Description")]
    public string ModelDescription { get; set; }
    public System.DateTime DATE_CREATED { get; set; }
    public string CREATED_BY { get; set; }
    public Nullable<System.DateTime> DATE_MODIFIED { get; set; }
    public string MODIFIED_BY { get; set; }

    public virtual ICollection<Device> Devices { get; set; }
    public virtual Manufacturer Manufacturer { get; set; }

 public partial class Device
{
    public Device()
    {
        this.DeviceLocations = new HashSet<DeviceLocation>();
        this.DeviceLogs = new HashSet<DeviceLog>();
        this.DeviceStatus = new HashSet<DeviceStatu>();
    }


    public int DeviceID { get; set; }
    [Display(Name = "Device Type")]
    public int DeviceTypeID { get; set; }
    public int ManufacturerModelID { get; set; }
    [Display(Name="Inventory Number")]
    public string InventoryNumber { get; set; }
    [Display(Name = "Serial Number")]
    public string SerialNumber { get; set; }
    [Display(Name = "State ID")]
    public string StateID { get; set; }
    [Display(Name = "Date Received")]
    [DisplayFormat(DataFormatString = "{0:d}", ApplyFormatInEditMode = true)]
    public DateTime? DateReceived { get; set; }
    public Nullable<decimal> Price { get; set; }
    public string Notes { get; set; }
    public System.DateTime DATE_CREATED { get; set; }
    public string CREATED_BY { get; set; }
    public Nullable<System.DateTime> DATE_MODIFIED { get; set; }
    public string MODIFIED_BY { get; set; }


    public virtual DeviceType DeviceType { get; set; }
    public virtual ManufacturerModel ManufacturerModel { get; set; }
    public virtual ICollection<DeviceLocation> DeviceLocations { get; set; }
    public virtual ICollection<DeviceLog> DeviceLogs { get; set; }
    public virtual ICollection<DeviceStatu> DeviceStatus { get; set; }

1 ответ

Я работаю над тем, что, как мне кажется, является реализацией кода EF 4.1. База данных уже существует, и базовые модели уже существуют (созданные XSD.exe для моих входящих XML-данных). Я написал свои собственные сопоставления и обновил модели, чтобы они правильно работали с Entity Framework.

Когда я пытаюсь запустить код, я получаю следующую ошибку:

Во время создания модели были обнаружены одна или несколько ошибок проверки:

System.Data.Edm.EdmEntityType: Name: имя каждого типа в схеме должно быть уникальным. Имя типа «CourtCase» уже определено.

Я проверил и дважды проверил, и определенно этот класс определен только в одном месте. Я также использовал строку ниже, чтобы DbContext не пытался создавать свои собственные модели.

Database.SetInitializer<LoadContext>(null);

Мои XML-данные десериализуются в мои модели, а затем я просто пытаюсь сохранить их в базе данных:

var serializer = new XmlSerializer(typeof (CourtCase));
var xmlReader = new XmlTextReader(
   new MemoryStream(Encoding.Default.GetBytes(_itemText)));

_deserializedCase = (CourtCase) serializer.Deserialize(xmlReader);

Database.SetInitializer<LoadContext>(null);
using (var dbContext = new LoadContext())
{
  dbContext.Cases.Add(_deserializedCase);
  dbContext.SaveChanges();
}

Дбконтекст:

public class LoadContext : DbContext
{
  public DbSet<CourtCase> Cases { get; set; }

  protected override void OnModelCreating(DbModelBuilder modelBuilder)
  {
     modelBuilder.Conventions.Remove<IncludeMetadataConvention>();
     modelBuilder.Configurations.Add(new CaseMap());
     etc.
  }
}

Мне не хватает еще одного ключевого компонента конфигурации Entity Framework?

Полная трассировка стека

at System.Data.Entity.ModelConfiguration.Edm.EdmModelExtensions.ValidateAndSerializeCsdl(EdmModel model, XmlWriter writer)
   at System.Data.Entity.DbModelBuilder.Build(DbProviderManifest providerManifest, DbProviderInfo providerInfo)
   at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
   at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
   at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
   at System.Data.Entity.Internal.Linq.InternalSet`1.ActOnSet(Action action, EntityState newState, Object entity, String methodName)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Add(Object entity)
   at System.Data.Entity.DbSet`1.Add(TEntity entity)