public void TestDbCoonection() { using (var dbContext = new CountriesDBContext()) { var countries = dbContext.TblCountries; Assert.IsTrue(countries.Count() > 100); } }
public void Test_Add_Country() { using (var dbContext = new CountriesDBContext()) { var countryName = dbContext.TblCountries.FromSqlRaw("SELECT * FROM public.tbl_countries").Select(r => r.Countryname).FirstOrDefault(); System.Diagnostics.Debug.WriteLine(countryName); } }
public void Test_Search_Country() { using (var dbContext = new CountriesDBContext()) { var countries = dbContext.TblCountries.Where(c => c.Countryname.StartsWith("P")).Select(c => c.Countryname); var countrList = countries.ToList(); Assert.IsTrue(countrList.Contains("Poland")); } }
public Countries(CountriesDBContext context) { _context = context; }
public HomeController(CountriesDBContext context) { _context = context; }