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