Entity Framework Join 3 Tables

by

I think it will be easier using syntax-based query:

var entryPoint = (from ep in dbContext.tbl_EntryPoint
                 join e in dbContext.tbl_Entry on ep.EID equals e.EID
                 join t in dbContext.tbl_Title on e.TID equals t.TID
                 where e.OwnerID == user.UID
                 select new {
                     UID = e.OwnerID,
                     TID = e.TID,
                     Title = t.Title,
                     EID = e.EID
                 }).Take(10);

And you should probably add orderby clause, to make sure Top(10) returns correct top ten items.

More Related Contents:

  1. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  2. Better way to query a page of data and get total count in entity framework 4.1?
  3. There is already an open DataReader associated with this Command which must be closed first
  4. Entity Framework Code First – two Foreign Keys from same table
  5. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  6. EF Including Other Entities (Generic Repository pattern)
  7. What are Independent Associations and Foreign Key Associations? [duplicate]
  8. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  9. LEFT JOIN in LINQ to entities?
  10. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  11. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  12. How to include a child object’s child object in Entity Framework 5
  13. The result of a query cannot be enumerated more than once
  14. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  15. Entity Framework – Add Navigation Property Manually
  16. Mapping Database Views to EF 5.0 Code First w/Migrations
  17. EF migration for changing data type of columns
  18. Navigation Property without Declaring Foreign Key
  19. Creating dynamic queries with entity framework
  20. EF4 Code First: how to add a relationship without adding a navigation property
  21. Entity Framework 4: How to find the primary key?
  22. An error occurred while saving entities that do not expose foreign key properties for their relationships
  23. Can you get the DbContext from a DbSet?
  24. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  25. How to Refresh DbContext
  26. Entity Framework Code First Date field creation
  27. Entity Framework Multiple Object Contexts
  28. Entity Framework Code First naming conventions – back to plural table names?
  29. Repository Pattern, POCO, and Business Entities
  30. Create association on non-primary key fields with Entity Framework 4.1 Fluent API

Leave a Comment