public static ICollection<Category> GetAllCategories() { // The using statement prevents read/write errors with database. - Parsons // source: http://robertgreiner.com/2012/07/entity-framework-open-datareader-associated-with-command/ using (var ctx = new OrderingSystemDbContext()) { return ctx.Categories.ToList(); } }
public static User FindUserByEmailAndPassword(string email, string password, OrderingSystemDbContext db) { return db.Users.FirstOrDefault(x => x.Email.Equals(email) && x.Password.Equals(password)); }