Two entities mapped to the same rows

ef-database-first entity-framework entity-framework-6

Question

I'm getting the following error on my database first model in Entity Framework:

Error 3032: Problem in mapping fragments starting at lines 3434, 4312:EntityTypes Model.Docent, Model.Student are being mapped to the same rows in table Attendee. Mapping conditions can be used to distinguish the rows that these types are mapped to.

While I already added conditions to these models:

<EntityTypeMapping TypeName="IsTypeOf(Model.Student)">
  <MappingFragment StoreEntitySet="Attendee">
    <ScalarProperty Name="Id" ColumnName="atnId" />
    <Condition ColumnName="atnTypeId" Value="1" />
  </MappingFragment>
</EntityTypeMapping>

And

<EntityTypeMapping  TypeName="IsTypeOf(Model.Docent)">
  <MappingFragment StoreEntitySet="Attendee">
    <ScalarProperty Name="AvailabilityApprovedByType" ColumnName="atnAvailabilityApprovedByAttId" />
    <ScalarProperty Name="Id" ColumnName="atnId" />
    <Condition ColumnName="atnTypeId" Value="2" />
  </MappingFragment>
</EntityTypeMapping>

Their is a more complex hierarchy, possibly that's the problem. But I'm unsure how to proceed. This a the hierarchy:

Attendee                (Abstract)
  -> Facility           (Type = 3)
  -> AttendeeCollection (Abstract)
      -> Team           (Type = 4)
      -> Group          (Type = 5)
  -> Person             (Abstract)
      -> Student        (Type = 1)
      -> Docent         (Type = 2)
1
0
12/9/2016 7:48:02 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Well I figured out the problem. The Person entity had mapped scalar properties and associations. The associations where the problem. Because they could be of two types. I could not write in a condition for them because they could map to two properties. So I removed the scalar properties and the table mapping for the Person class altogether.

After that I implemented private versions of these scalar properties on the Docent en Student class. And exposed them via a partial implementation. Where I added them as abstract to the Person class.

I hope this is clear and helps somebody else. Possibly somebody else can write it down more legible.

0
12/9/2016 8:29:11 AM

Related Questions

How should two entity framework entities be compared?

Override the Equals method of your object and write an implementation that compares the properties that make it equal. ... public override bool Equals(object obj) { return MyProperty == ((MyObject)obj).MyProperty }
comparison entity-framework
asked by Mark Dickinson

Changes to a new entity with a two-level connection are not saved by Entity Framework.

I'm building an ASP.NET MVC site using the ADO.NET Entity Framework. I have an entity model that includes these entities, associated by foreign keys:...Report(ID, Date, Heading, Report_Type_ID, etc.)...SubReport(ID, ReportText, etc.) - one-to-one relationship with Report. ...ReportSource(ID, Name, Description) - one-to-many relationship with Sub_R...
entity-framework savechanges
asked by Tim Rourke

Row size exceeds the maximum row size of 8060 in Entity Framework.

The only way I can see you getting this error with that table definition is if you have previously had a large fixed width column that has since been dropped....CREATE TABLE [dbo].[Attachments] ( [Id] int IDENTITY(1,1) NOT NULL, [FileName] nvarchar(255) NOT NULL, [Attachment] varbinary(max) NOT NULL, Filler char(8000), Filler2 c...
entity-framework sql-server sql-server-2008
asked by Martin Smith

Framework for Entities A nullable entity property is mapped to a non-nullable column.

I am getting this nullable column error message in Entity Framework 4.1 - when the column is not actually nullable: ...Non-nullable column MyView.RunningTotal in table TransactionListView is mapped to a nullable entity property. ...But you can see from the screenshots below that the column is not nullable and that the entity property is not nullab...
c# entity-framework mapping nullable poco
asked by JK.

How to join two table from two different edmx using linq query

Update...As per your comment, EF wasn't able to parse a combined Expression tree across 2 different contexts....If the total number of records in the tables is relatively small, or if you can reduce the number of records in the join to a small number of rows (say < 100 each), then you can materialize the data (e.g. ....ToList() / .ToArray() / .AsEn...
edmx entity-framework linq
asked by StuartLC

How can I map two tables to one entity in an EntityTypeConfiguration?

It turns out that the answer I linked which did it in ModelBuilder was really, really close to what I needed to simply put in my EntityTypeConfiguration file. I'd just never used Map() in EntityTypeConfiguration before so I was a bit clueless....The following seems to work for me:...public class EquipmentMapping : EntityTypeConfiguration<Equipment>...
entity-framework-6
asked by Sterno

Saving AutoMapper mapped Collections of Entities using Entity Framework

I have the following Entity Framework Entities:...public class Region { public int RegionId { get; set; } // Primary Key public string Name { get; set; } public virtual ICollection<Country> Countries { get; set; } // Link Table } public class Country { public int CountryId { get; set; } // Primary Key public string Name { get; s...
.net automapper c# entity-framework entity-framework-6
asked by Muhammad Rehan Saeed

Dynamically querying two kinds of entities and mapping the results back to a specified entity collection

I hope this can help you...To search all cars by fueltype, use:...private static List<Car> SearchCars(List<Vehicle> vehicles, FuelType fueltype) { return vehicles.Where(f =>f is Car && (f as Car).FuelType == fueltype) .Select(x => (Car)x).ToList(); } ...If you want also filter by SerialNumber Use:...private static List<Car> SearchCar...
c# dapper entity-framework linq
asked by elfranchu

Entity Framework 6 Creating Two table from the same entity object

You cannot have multiple ...DbSet... pointing to the same class in one ...DbContext.... Your options are:...Creating new class with same properties ...Inheritance...Using different ...DBContext...s
asp.net c# code-first ef-code-first entity-framework-6
asked by DDan

EF6 two contexts vs. single context with two awaits

As you found out, the DbContext is not thread safe, therefore the only option to really run the queries in parallel would be to create a new DbContext for each Thread/Task....The overhead of creating a new DbContext is pretty low. ...https://msdn.microsoft.com/en-us/library/cc853327.aspx...Since the object will come from different DbContexts and t...
c# entity-framework entity-framework-6 performance
asked by Chris

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow