Left Outer Join in DBLinq

Nov 13, 2011 at 9:26 PM

No matter what I do I cannot get a left outer join to work.

Here is the latest attempt:

var returnValue = from customer in database.Customers                             

join customerType in database.CustomerTypes                              

on customer.CustomerTypeID equals customerType.CustomerTypeID into tblCtype                             

from ctype in tblCtype.DefaultIfEmpty()

 

select new CustomerData                              {

                                  Customer = customer,                                 

CustomerType = ctype

}

I get -> Nullable object must have a value

Any trick?  This all worked against a SQLServer database and I am trying to convert against a mysql database.

Thanks!

Linda