Creating a LINQ select from multiple tables

by

You can use anonymous types for this, i.e.:

var pageObject = (from op in db.ObjectPermissions
                  join pg in db.Pages on op.ObjectPermissionName equals page.PageName
                  where pg.PageID == page.PageID
                  select new { pg, op }).SingleOrDefault();

This will make pageObject into an IEnumerable of an anonymous type so AFAIK you won’t be able to pass it around to other methods, however if you’re simply obtaining data to play with in the method you’re currently in it’s perfectly fine. You can also name properties in your anonymous type, i.e.:-

var pageObject = (from op in db.ObjectPermissions
                  join pg in db.Pages on op.ObjectPermissionName equals page.PageName
                  where pg.PageID == page.PageID
                  select new
                  {
                      PermissionName = pg, 
                      ObjectPermission = op
                  }).SingleOrDefault();

This will enable you to say:-

if (pageObject.PermissionName.FooBar == "golden goose") Application.Exit();

For example 🙂

More Related Contents:

  1. Convert DateTime to Date string “dd/mm/yyyy”
  2. Is there a good LINQ way to do a cartesian product?
  3. Create a list from two object lists with linq
  4. How can I conditionally apply a Linq operator?
  5. LINQ to SQL – Left Outer Join with multiple join conditions
  6. LINQ Contains Case Insensitive
  7. “A lambda expression with a statement body cannot be converted to an expression tree”
  8. Proper Linq where clauses
  9. What is the use of Enumerable.Zip extension method in Linq?
  10. How can I return an anonymous type from a method?
  11. How can I sort a string of text followed by a number using LINQ
  12. Generic All Controls Method
  13. Differences between IQueryable, List, IEnumerator?
  14. Linq join iquery, how to use defaultifempty
  15. How to convert linq results to HashSet or HashedSet
  16. Why does the Linq Cast helper not work with the implicit cast operator?
  17. Unable to create a constant value – only primitive types
  18. Check for any element that exists in two collections
  19. Getting odd/even part of a sequence with LINQ
  20. C# Is there a LINQ to HTML, or some other good .Net HTML manipulation API?
  21. What does this C# code with an “arrow” mean and how is it called?
  22. Pair-wise iteration in C#, or sliding window enumerator
  23. Dynamic query with OR conditions in Entity Framework
  24. List.Except is not working
  25. Finding symmetric difference with LINQ
  26. Should the order of LINQ query clauses affect Entity Framework performance?
  27. Transform IEnumerable asynchronously by awaiting each task
  28. Map two lists into a dictionary in C#
  29. How to check if all list items have the same value and return it, or return an “otherValue” if they don’t?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment