private static void MasterDetayOrnek()
{
MusteriDal dal = new MusteriDal();
List <Musteri> musteriListesi = dal.SorgulaHepsiniGetir();
foreach (Musteri m in musteriListesi)
{
Console.WriteLine(m.Adi + " " + m.Soyadi);
Console.WriteLine("SIPARISLERI");
List <MusteriSiparis> siparisler = dal.SorgulaDetayTabloGetir <MusteriSiparis>(m.MusteriKey);
foreach (MusteriSiparis ms in siparisler)
{
Console.WriteLine(ms.MusteriSiparisKey);
}
}
}
public void Guncelle()
{
MusteriDal dal = new MusteriDal();
List <Musteri> musteriList = dal.SorgulaHepsiniGetir();
if (musteriList.Count > 0)
{
Musteri m = musteriList[0];
Guid pk = m.MusteriKey;
m.Soyadi = "deneme";
dal.Guncelle(m);
Musteri veritabanindakiRow = dal.SorgulaMusteriKeyIle(pk);
Assert.AreEqual(m.Soyadi, veritabanindakiRow.Soyadi);
Assert.AreEqual(m.Adi, veritabanindakiRow.Adi);
}
}
private static void listeHepsiniGetir()
{
MusteriDal dal = new MusteriDal();
List <Musteri> liste = dal.SorgulaHepsiniGetir();
var sonuc = from m in liste
where ((m.Adi.Contains("a")) && (m.Soyadi.Contains("Ö")))
orderby m.MusteriKey
select m;
IEnumerable <Musteri> sonucListesi = liste
.Where(m => m.Adi.Contains("a"))
.OrderBy(m => m.Adi)
.Select(m => m);
Musteri[] mList = sonucListesi.ToArray();
foreach (var item in sonuc)
{
Console.WriteLine(item.Adi + " " + item.Soyadi);
}
}
