Lawrence Pond

Lawrence Pond

  • NA
  • 164
  • 0

Linq Dot Notation Joins multiple(3) tables inner and outer

Feb 5 2014 10:38 PM
Using the LINQ Dot Notation can someone provide an sample of a join of multiple table one with a inner join the other with an outer join with only using Dot notation not using Query Expressions or mixing both together.

Let say you have three tables
Orders.CustomerID
Customers.CustomerID (only customers with orders) inner
Preference.CustomerID (see all customers with or without a record in Preference.

Using .Dot Notation  select all orders  and join customers and show preference for customers  even if no record exists.

As Always this is greatly appreciated.