Adding an object with a foreign key in Entity Framework

c# entity-framework sql-server

Question

I have 2 tables Jobs and Schedule

Jobs

JobId - int,PK, Identity
ScheduleId - int, FK
Title - varchar
Description - varchar

Schedules

ScheduleId - int,PK, Identity
Name - varchar

There is a relationship one to many with cascade on delete.

When I create Entity model, the generated Jobs model removes the ScheduleId field.

The Problem is that I can't Insert new Job with specified ScheduleId!

 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();

Note: I have a row in Schedules table with 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

You can assign Schedule without actually loading Schedule object. Something 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);

I don't like this approach, case you have to hardcode entity types in string :/ If anyone know how to do this without such hardcoding - please comment.

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

Related Questions

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

I have three classes, like so:...[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>The de...
c# code-first entity-framework
asked by MartinHN

How to add foreign key relationship in Entity Framework?

If you are using the database first approach, it's better to create the foreign key on the database and update the model. Of course, this is true if you can modify the database; if not, you're stuck with the option of creating the referential constraint on the model.
entity-framework visual-studio
asked by Carles Company

SQLBulkCopy inserts using Entity Framework with Foreign Key object

So,...Provided your EF user has the ability to alter schema on the database, you can pursue this method of solving the problem:...Add a GUID column to the table...Identify each object in memory by the GUID...Insert the values via bulk Insert including the identifying GUID...Select them back and map them to the inserted GUIDs...Drop the GUID column....
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

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...On the Order table, there is a foreign key defined on the PersonId and CompanyId columns, th...
entity-framework entity-framework-6 insert
asked by WerkingWill

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

I'm using EF 6.1 new feature - Code first from existing DB - and I'd like to add a foreign key in addition to each navigation property. I added the default T4 templates from nuget but I cannot figure out how to edit it. I guess it should be a quite common task, but I wasn't able to find any example... 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 have a issue with updating value on a foreign key which is inheriting from another class. I am working with detached object in Entity Framework, so I'm using graphdiff to handle it....I've simplified the code to make it easier to read...Project class:...public class Project { public Guid Id { get; set; } public virtual List<Activity> Act...
c# ef-code-first entity-framework graphdiff
asked by Arne H. Bitubekk

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

I'm using EF with database first approach....I would like to add attribute to the generated code to mark property as primary key / foreign key when it's the case....For example, if I have a table ...User... in my database...CREATE TABLE User ( Id int PRIMARY KEY ); ...I would like my generated code to include an attribute that indicate that ...I...
c# code-generation entity-framework-6
asked by Gudradain

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

I am working on ASP.NET application with Entity Framework 6. I have already database and I am using Code First existing Database approach....I am two table and second table has Foriegn key along with its own primary key. I have used Column order but still getting following error. I have search online, tried different combination but still getting e...
c# composite-key data-annotations entity-framework-6
asked by Toxic

Entity Framework 6 adds additional foreign key with underscore

I'm having a trouble with Entity Framework 6....The Migration generates additional foreignkey with underscore....I have a table for Person and PersonRelative...Person Table...Id...Name...PersonRelative Table...Id...PersonId...RelativeId (Person type)...Relationship (Additional Table, to determine what is the relationship of the Person to its Relati...
c# ef-migrations entity-framework-6 mysql
asked by mikro

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

I am trying to learn about Entity Framework 6, and I am running into an issue, that I have been able to reproduce in a test project:...A ...Movie... has a ...Name...and a ...Revenue.... A ...Revenue... has a ...GrossIncome...:...public class Movie { [Key] public int Id { get; set; } public string Name { get; set; } p...
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