public void Test1() { var SqLite = new SqliteConnection("Filename=:memory:"); var DBOptions = new DbContextOptionsBuilder <DBContextClass>().UseSqlite(SqLite).Options; SqLite.Open(); using (var db = new DBContextClass(DBOptions)) { db.Database.Migrate(); var clients = new Client(); clients.FName = "John"; clients.LName = "Smith"; clients.UserName = "******"; clients.Password = "******"; db.Add(clients); db.SaveChanges(); } using (var db = new DBContextClass(DBOptions)) { var clients = db.Clients .Where(b => b.FName == "John") .OrderBy(b => b.ClientID) .ToList() .First(); Assert.Equal("John", clients.FName); } }
public Country GetCountryById(int?id) { DBContextClass db = new DBContextClass(); using (db) { return((from c in db.Countries where c.Id == id select c).FirstOrDefault()); } }
public List <Country> GetCountries() { DBContextClass db = new DBContextClass(); using (db) { return((from u in db.Countries select u).ToList()); } }
public int OrderCount() { DBContextClass db = new DBContextClass(); using (db) { return((from c in db.FinalOrders select c).Count()); } }
//Garbage Colector and Disposing off Method protected override void Dispose(bool disposing) { DBContextClass db = new DBContextClass(); if (disposing) { db.Dispose(); } base.Dispose(disposing); }
public void AddCountry(Country country) { DBContextClass db = new DBContextClass(); using (db) { db.Countries.Add(country); db.SaveChanges(); } }
// GET: Admin public ActionResult AdminPanel() { DBContextClass db = new DBContextClass(); User u = (User)Session[WebUtil.CURRENT_USER]; if (!(u != null && u.IsInRole(WebUtil.ADMIN_ROLE))) { return(RedirectToAction("Login", "User", new { ctl = "Admin", act = "AdminPanel" })); } return(View()); }
public void AddCity(City city) { DBContextClass db = new DBContextClass(); using (db) { db.Entry(city.Country).State = EntityState.Unchanged; db.Cities.Add(city); db.SaveChanges(); } }
public List <City> GetCitiesByCountryId(int id) { DBContextClass db = new DBContextClass(); using (db) { return((from c in db.Cities where c.Country.Id == id select c).ToList()); } }
public List <City> GetCities(Country country) { DBContextClass db = new DBContextClass(); using (db) { return((from u in db.Cities where u.Country.Id == country.Id select u).ToList()); } }
public void DeleteCountry(Country country) { DBContextClass db = new DBContextClass(); using (db) { db.Entry(country).State = EntityState.Deleted; db.Countries.Remove(country); db.SaveChanges(); } }
public TestRepository(DBContextClass context) : base(context) { this.Context = context; }
public NotesController(DBContextClass context) { _context = context; }
public TableRepository(DBContextClass context) : base(context) { }