Adding an object with a foreign key in Entity Framework

c# entity-framework sql-server

Question

My tables are Jobs and Schedule.

Jobs

Identity, PK, and JobId
ScheduleId: FK, int
Input type: varchar
Character type: varchar

Schedules

ScheduleId is an int, PK, and identity.
the varchar name

With cascade on delete, there is a one to many connection.

The ScheduleId column is removed from the produced Jobs model when I construct an Entity model.

My inability to insert new jobs with provided ScheduleId is the issue!

 Job job = new Job();
 job.title= "blabla";
 job.description="xyz";
 job.scheduleId=1// can't have this!

 if (job.EntityState == EntityState.Detached)
 {
      myContext.AddToJobs(job);
 }
 myContext.SaveChanges();

I have an entry in the Schedules database with the identifier scheduleId=1.

1
3
8/12/2010 3:15:33 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Without actually loading the Schedule object, you may allocate the Schedule. Possibly like this:

db = new OneToManyEntities(); 
var address = new Address { Address1 = "Oakumber st", City = "Dallas", State = "Tx", Zip = "76111" }; 
address.CustomerReference.EntityKey = new EntityKey("OneToManyEntities.Customer","CustomerId",2); 
db.AddToAddresses(address);

This method, if you have to hardcode entity types in a string, is not something I appreciate. Please leave a comment if you know how to achieve this without using such hardcoding.

1
8/13/2010 9:40:30 AM

Related Questions

First, foreign keys/objects should not be saved in Entity Framework code.

I'm taking three courses, as follows:...[DataContract] public class ApplicationDto : BusinessBase<int> { /// <summary> /// Gets or sets the name. /// </summary> /// <value>The name.</value> [DataMember] public string Name { get; set; } /// <summary> /// Gets or sets the description. /// </summary> /// <value...
c# code-first entity-framework
asked by MartinHN

How to add foreign key relationship in Entity Framework?

It is preferable to build the foreign key on the database and update the model if you are utilizing the database first technique. Of course, this is only true if you have the ability to alter the database; otherwise, your only choice is to build the referential constraint into the model.
entity-framework visual-studio
asked by Carles Company

SQLBulkCopy inserts using Entity Framework with Foreign Key object

So,...If your EF user has the authority to modify database structure, you may try this approach to issue solving:...The table should now include a GUID field....By using the GUID, locate each item in memory....Bulk-insert the values Add the GUID for identification....Map them to the added GUIDs by selecting them once again....Eliminate the GUID col...
c# entity-framework sqlbulkcopy sql-server
asked by David Colwell

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

Sorry if this is repetitive; I'm having trouble locating the precise response to this query....I have three tables set up as follows:...FirstName, LastName, PersonId...Business: CompanyId, BusinessName...Order: PersonId, OrderId, and CompanyId...My Order entity class, which was created by EF, includes navigation properties of type Person (not Perso...
entity-framework entity-framework-6 insert
asked by WerkingWill

Entity Framework 6.1 Code first from existing DB - add foreign key to T4 template

In order to add a foreign key in addition to each navigation property, I would like to use the new EF 6.1 capability called "Code first from existing DB." I downloaded the basic T4 templates from Nuget and uploaded them, but I'm not sure how to alter them. I suppose it should be a fairly typical work, but I couldn't find any examples. Thanks Matteo...
ef-code-first entity-framework entity-framework-6 t4
asked by Matteo Sganzetta

Setting association to foreign key to inherited object using graphdiff and Entity Framework

I'm having trouble updating a value on a foreign key that is descended from a different class. I'm using graphdiff to manage disconnected objects that I'm working with in Entity Framework....To make the code easier to read, I've simplified it....Project type:...public class Project { public Guid Id { get; set; } public virtual List<Activit...
c# ef-code-first entity-framework graphdiff
asked by Arne H. Bitubekk

Code Generation : Add primary key / foreign key to Entity Framework

With a database-first strategy, I'm utilizing EF....When appropriate, I would like to add an attribute to the produced code to designate a property as a main key or foreign key....If I have a table, for instance...User... from my database...CREATE TABLE User ( Id int PRIMARY KEY ); ...I would like an attribute in my created code to show that...I...
c# code-generation entity-framework-6
asked by Gudradain

How to add composite foreign key in data annotation for Entity Framework 6

Entity Framework 6 is being used in an ASP.NET application I'm working on. I am utilising the Code First existing Database strategy and I already have a database....I have two tables, and the second table contains both a foreign key and a primary key of its own. Despite using Column order, I continue to see the following issue. I searched online an...
c# composite-key data-annotations entity-framework-6
asked by Toxic

Entity Framework 6 adds additional foreign key with underscore

ZZZ_tmp
c# ef-migrations entity-framework-6 mysql
asked by mikro

How can I query the foreign key objects using Entity Framework?

ZZZ_tmp
c# entity-framework entity-framework-6 sql-server
asked by Maxime

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