Linq Dot Notation Joins multiple(3) tables inner and outer
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.