Linq and C# - Join example

join01.cs

long tblUnitID = 808;   

          var _rec = (from u in _db.tblUnits
                     join ut in _db.tblUnitTypes on u.tblUnitTypeID equals ut.tblUnitTypeID into gj                    
                     from subset in gj.DefaultIfEmpty()
                     where u.tblUnitID == tblUnitID
                     select new { u.tblUnitID, u.tblUnitName, u.tblUnitTypeID, tblUnitTypeName = (subset == null ? String.Empty : subset.tblUnitTypeName) }).FirstOrDefault();

            Console.WriteLine("{0} {1} {2} {3}",_rec.tblUnitID, _rec.tblUnitName, _rec.tblUnitTypeID, _rec.tblUnitTypeName);