Friday, January 16, 2009

linq and left join

var datas = from m in db.Musteris
join n in db.Urunlers
on m.ID equals n.musteriID into records
from r in records.DefaultIfEmpty()Metin Rengi
select new { Ad=m.ad, Urun=r.urun ?? "Urun Yok." };

No comments:

Post a Comment