public void herseyiSil()
{
string pk = "TR";
CountriesBs bs = new CountriesBs();
bs.Sil(pk);
}
public void Ekle()
{
Countries a = new Countries();
CountriesBs bs = new CountriesBs();
a.CountryId = "TR";
a.CountryName = "Turkey";
bs.Ekle(a);
}
static void Main(string[] args)
{
CountriesBs bs = new CountriesBs();
List <Countries> liste = bs.SorgulaHepsiniGetir();
foreach (var item in liste)
{
Console.WriteLine(item.CountryId + " " + item.CountryName + " " + item.RegionId);
}
Countries c = new Countries();
c.CountryId = "TR";
c.CountryName = "TURKEY";
bs.Ekle(c);
}
public void Guncelle()
{
CountriesBs bs = new CountriesBs();
List <Countries> liste = bs.SorgulaHepsiniGetir();
if (liste.Count > 0)
{
Countries m = liste[0];
string pk = m.CountryId;
m.CountryName = m.CountryName + "2";
bs.Guncelle(m);
Countries veritabanindakiRow = bs.SorgulaCOUNTRY_IDIle(pk);
Assert.AreEqual(veritabanindakiRow.CountryName, m.CountryName);
}
}
