vb.net - Linq to Sql: Multiple left outer joins -

I understand how to use LINQ from SQL using external external than multiple left I understand that How to use a left external joiner I am using VB.NET below is my SQL syntax.

T-SQL

  Select o.OrderNumber, v.VendorName, s.StatusName from O Left External Order Join Vendors V v.Id = o.VendorId go outside the outer position s.Id = o.StatusId ou o.OderDumber & gt; = 100000 and o.OderDumber & lt; = 200000    
 
 
 This can be cleaner ( to you in all   statement  is not needed):  
  var query = dc.vendors in order from the seller in dc.Orders. Where (v = & gt; v.id == order.VendorId). Default ifEmpty () in the state from .status. Where (s => order.StatusId) .DefaultIfEmpty () Select new {command = command, vendor = vendor, status = status} // vendor And the status property will be null if left in the null to join the null   
 Here is another example left to join  
  expenseDataContext.ExpenseDtos From the result of the result = where expense.Id == expenseId // has some expense ID it was passed from CAT indifferent // Exchange Datatunex S When present in the Characters, leave the categories on the table. Where (C = & gt; c.Id == expense.CategoryId) .DefaultIfEmpty () // Exclude the expense type to be included on the table if expenseDataContext.ExpenseTypeDtos .Where the expenseType exists (e = & gt; e. Id == expense.ExpenseTypeId) .DefaultIfEmpty () / / expenseDataContext.CurrencyDtos.Where (c => c.CurrencyID == expense.FKCurrencyID) exists on the currency if the currency is included on the table) .DefaultIfEmpty (selection) New {expense = expenditure} // if the class does not, if it does not exist then the category = category does not exist, // Xpress Aim will be void if not included Express Type = Express Type, // currency zero will be if it does not include currency = currency}