public List <HinhSanPham> GetListHinhSP()
{
List <HinhSanPham> list = new List <HinhSanPham>();
var query = from sp in db.SanPhams
join d in db.HinhSanPhams
on new { sp.MaSP } equals new { d.MaSP } into details
from d in details
select new { sp.MaSP, d.MaHinh, d.LinkHinh };
foreach (var item in query)
{
HinhSanPham hinhSP = new HinhSanPham();
hinhSP.MaSP = item.MaSP;
hinhSP.MaHinh = item.MaHinh;
hinhSP.LinkHinh = item.LinkHinh;
list.Add(hinhSP);
}
return(list);
}
private void attach_HinhSanPhams(HinhSanPham entity)
{
this.SendPropertyChanging();
entity.SanPham = this;
}
partial void DeleteHinhSanPham(HinhSanPham instance);
partial void UpdateHinhSanPham(HinhSanPham instance);
partial void InsertHinhSanPham(HinhSanPham instance);
private void detach_HinhSanPhams(HinhSanPham entity)
{
this.SendPropertyChanging();
entity.SanPham = null;
}
