Entity Framework: Setting a Foreign Key Property

by

This missing feature seems to annoy a lot of people.

  • Good news: MS will address the issue with .NET 4.0.
  • Bad news: for now, or if you’re stuck on 3.5 you have to do a little bit of work, but it IS possible.

You have to do it like this:

Locker locker = new Locker();
locker.UserReference.EntityKey = new System.Data.EntityKey("entities.User", "ID", userID);
locker.LockerStyleReference.EntityKey = new EntityKey("entities.LockerStyle", "ID", lockerStyleID);
locker.NameplateReference.EntityKey = new EntityKey("entities.Nameplate", "ID", nameplateID);
entities.AddLocker(locker);
entities.SaveChanges();

More Related Contents:

  1. How to create “embedded” SQL 2008 database file if it doesn’t exist?
  2. Entity framework: StoreGeneratedPattern=”Computed” property
  3. An async/await example that causes a deadlock
  4. Could not load file or assembly or one of its dependencies
  5. How to apply an XSLT Stylesheet in C#
  6. Best Practice for Forcing Garbage Collection in C#
  7. C# variable scoping: ‘x’ cannot be declared in this scope because it would give a different meaning to ‘x’
  8. The cast to value type ‘Int32’ failed because the materialized value is null
  9. HTTP Error 500.30 – ANCM In-Process Start Failure
  10. Is there a downside to adding an anonymous empty delegate on event declaration?
  11. Sort ObservableCollection through C#
  12. Order of serialized fields using JSON.NET
  13. WPF Binding a ListBox to an enum, displaying the Description Attribute
  14. How can I treat the circle as a control after drawing it? – Moving and selecting shapes
  15. Raise event thread safely – best practice [duplicate]
  16. How to enable cross origin requests in ASP.NET MVC [duplicate]
  17. Turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server
  18. Encrypting/Decrypting large files (.NET)
  19. Inheritance on a constrained generic type parameter
  20. MVC 4 Edit modal form using Bootstrap
  21. How can I sort a List by multiple T.attributes?
  22. Very Simple definition of InitializeComponent(); Method
  23. How to get text from parent element and exclude text from children (C# Selenium)
  24. Why does Random.Next() always return the same number [duplicate]
  25. How to get Command Line info for a process in PowerShell or C#
  26. Multiple random numbers are the same [duplicate]
  27. Finding all classes with a particular attribute
  28. ScrollViewer mouse wheel not scrolling
  29. C# exception filter?
  30. EF Core takes a lot of time, sometimes, to perform SELECT query

Leave a Comment