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);
            }
        }