1   DataClasses1DataContext db = new DataClasses1DataContext();
 2             var linq = from _data in db.Res_Item
 3                        join data2 in db.Res_ItemCategory on _data.ID equals data2.ItemID
 4                        join data3 in db.Res_ItemPrice on _data.ID equals data3.ItemID into list
 5                        select new Res_Item_Ext
 6                        {
 7                            ID = _data.ID,    //列說明(ming): 產品編號
 8                            Name = _data.Name,    //列說明(ming): 商品名(ming)稱
 9                            Res_ItemPrice=list.ToList(),
10                        };
11             var linq2 = linq.Where(i => i.ID == 5104).OrderBy(i => i.ID).Distinct().ToList();
12             linq2.ForEach(i => Console.WriteLine(i.ID + i.Name));