An Entity with Key (PK) will not round-trip

c# entity-framework

Question

I have two tables: <subjects> and <prerequisites>. The primary key of prerequisite table is a composite key: pr_subject_id and pr_prerequisite_subject_id . They are both foreign keys from the <subjects> table. I can map the pr_subject_id in a association but i can't map the return trip (pr_prerequisite_subject_id). See image. How should i solve this?

note: When i made the associations in sql server it was fine but when i loaded the database in the entity framework, the entity framework dropped the prerequisite table because of this return trip association.

enter image description here

enter image description here

1
0
5/23/2013 6:20:37 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I looked around but i think this is a common problem with the Entity Framework. I found two workarounds here. Basically what i did was adding a third column er_id and let that be the primary key. Then to enforce that there will be no double of the other two columns i added a unique constraint.

3
5/23/2013 7:06:26 AM

Related Questions

From a foreign key in a table, EF does not construct a foreign key association.

I have a table tblEvent and another table tblContact. There is a field ContactID in tblEvent that is linked by a foreign key to ContactID in tblContact. I've triple checked; the foreign key is in the database....The Entity Framework model DOES NOT generate a navigation property and foreign key association for it as it does for the other foreign k...
entity-framework
asked by rsteckly

Error with Entity Framework Associations Because the attributes of the Dependent Role are not the most important ones.

If you have a link table with a column with identity specification, remove that (it would restrict the link table to only one copy of the ID for that linked table).
c# dns domain-driven-design entity entity-framework
asked by Graham Laight

Entity Framework - The foreign key component ... is not a declared property on type

I get this error:...The foreign key component 'SubdivisionHOAId' is not a declared property on type 'SubdivisionHOA'. Verify that it has not been explicitly excluded from the model and that it is a valid primitive property....Here is my model. I don't understand what I need to do, as my understanding is that if I've specified [ForeignKey("Subdivis...
c# entity-framework entity-framework-6
asked by Chris Halcrow

Entity Framework - The foreign key component … is not a declared property on type

I have the following Model...public class FilanthropyEvent : EntityBase, IDeleteable { public int Id { get; set; } public string Name { get; set; } public DateTime EventDate { get; set; } public string Description { get; set; } public decimal Target { get; set; } public decimal EntryFee { get; set; } public bool Delet...
.net c# code-first ef-code-first entity-framework
asked by MrBliz

Entity framework issue "The table/view ' does not have a primary key defined."

I am new to Entity Framework. I am using an existing database and a table doesn't have primary key defined. When I use Entity Framework, I get the error "The table/view ' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.". I looked up a few stack overflow solutions / google, I s...
.net c# entity-framework sql-server
asked by user2613228

EF6 MySQL StrongTypingException When Column is not PK

We are using MySql and Entity FrameWork with VS 2013 those are the tools installed:...MySql Server 5.7.8...MySql WorkBench 6.3....MySql for Visual Studio 1.2.4...Connector/NET 6.9....VS 2013 Ultimate...Entity FrameWork 6.1.3 installed via NuGet...We have imported the necesary libraries into the project MySQLWeb, MySQL.Data, Mysql.Data.Emtity.EF6...
c# entity-framework mysql
asked by Juan

Entity Framework 6 Runtime Error: "given key was not present in the dictionary"

I am writing an ASP.Net app using EF6 code-first and table per hierarchy...I get this error whenever I attempt to do anything meaningful with my dbcontext (such as a query, update, etc.):...{ "Message": "An error has occurred.", "ExceptionMessage": "An error occurred while preparing the command definition. See the inner exception for details.",...
asp.net c# entity-framework entity-framework-6 inheritance
asked by jth41

Entity Framework code-first set foreign key with primary key in same table

I have this ...WdUser... class inherited from ...SysModelBase...:...[Serializable] public class WdUser : SysDomainModelBase, IWdUser { [Display(Name = "UserName")] [MaxLength(25)] [Required] public string UserName { get; set; } [Required] [Index(IsUnique = true)] [MaxLength(25)] [Display(Name = "LoginName ")] pu...
asp.net c# entity-framework-6
asked by Autyan

Entity Framework foreign key that is not a primary key

If you still want to us the unique identifier, you need to take note on the below two things...Set the tenants.tenantGuid to UNIQUE KEY and also set the users.tenantGuid as the same data type...Modify the tables as below...CREATE TABLE tenants ( tenantId INT PRIMARY KEY, tenantGuid UNIQUEIDENTIFIER UNIQUE, tenantName VARCHAR ) CREATE T...
c# entity-framework entity-framework-6 guid sql
asked by Suraj KV

Entity Framework with code first not initializing Foreign Key class member

I am using EF 6, with code first and I have a domain model class which has 2 FKs and the related objects as class members. The insertion is working fine but when it comes to get the values from within the database, the FKs objects related to this object are null. ...I've tried to set Lazy Initialization to false and to mark the FK class members as ...
c# ef-code-first entity-framework-6
asked by Adrian Chiritescu

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