C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?

by

You can use Include() first, then retrieve a single object from the resulting query:

Item item = db.Items
              .Include(i => i.Category)
              .Include(i => i.Brand)
              .FirstOrDefault(x => x.ItemId == id);

More Related Contents:

  1. ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value
  2. Why does the EF 6 tutorial use asynchronous calls?
  3. How to add/update child entities when updating a parent entity in EF
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. Non-static method requires a target
  7. Using Asp.Net Identity DataBase first approach
  8. Implementing Audit Log / Change History with MVC & Entity Framework
  9. How to do a Bulk Insert — Linq to Entities
  10. How to group by on 2 child entities and get total of both this child entities?
  11. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  12. Questions about Entity Framework Context Lifetime
  13. The operation cannot be completed because the DbContext has been disposed using MVC 4
  14. Is Deferred Execution in Asp.net MVC View a very bad thing?
  15. Entity vs Model vs View Model
  16. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  17. Export Model to DataTable
  18. ASP.NET Identity – Multiple object sets per type are not supported
  19. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  20. Set database timeout in Entity Framework
  21. Only primitive types or enumeration types are supported in this context
  22. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  23. Keyword Not Supported: Metadata
  24. Entities VS Domain Models VS View Models
  25. How to create custom additional fields in UserProfile in MVC4
  26. How should I set up my integration tests to use a test database with Entity Framework?
  27. Where to convert business model to view model?
  28. Repository Pattern, POCO, and Business Entities
  29. MVC 4 – Many-to-Many relation and checkboxes
  30. .NET Managing Layers Relationships

Leave a Comment