public List <Domain.Models.RegisteredUser> Read() { using (var context = new RegisteredUserEFContext()) { context.Database.Log = Console.WriteLine; var users = context.RegisteredUserEF.ToList(); return(users); } }
public Domain.Models.RegisteredUser Read(int identifier) { using (var context = new RegisteredUserEFContext()) { context.Database.Log = Console.WriteLine; var user = context.RegisteredUserEF.Find(identifier); return(user); } }
//private static void InsertToDoTask() //{ // var toDoTask_A = new ToDoTask // { // Description = "Task_A", // CreatedOn = DateTime.Now, // RequiredBy = DateTime.Now, // CompletedOn = DateTime.Now // }; // var toDoTask_B = new ToDoTask // { // Description = "Task_B", // CreatedOn = DateTime.Now, // RequiredBy = DateTime.Now, // CompletedOn = DateTime.Now // }; // using (var context = new TryItOutEFContext() ) // { // context.Database.Log = Console.WriteLine; // context.ToDoTasksEF.AddRange(new List<ToDoTask> { toDoTask_A, toDoTask_B }); // context.SaveChanges(); // } //} //private static void InsertRegisteredUser() //{ // var user_A = new RegisteredUser // { // Username = "******", // Password = "******", // Firstname = "David", // Lastname = "Morton", // IsActive = "True", // LastLoggedIn = "", // NumberOfAttemps = 0, // Locked = false // }; // var user_B = new RegisteredUser // { // Username = "******", // Password = "******", // Firstname = "Yogi", // Lastname = "Mistry", // IsActive = "True", // LastLoggedIn = "", // NumberOfAttemps = 0, // Locked = false // }; // using (var context = new TryItOutEFContext()) // { // context.Database.Log = Console.WriteLine; // context.RegisteredUserEF.AddRange(new List<RegisteredUser> { user_A, user_B }); // context.SaveChanges(); // } //} //private static void ReadToDoTask() //{ // using (var context = new ToDoTasksEFContext()) // { // context.Database.Log = Console.WriteLine; // var tasks = context.ToDoTasksEF.ToList(); // var task = context.ToDoTasksEF.Where(x => x.Identifier == 5); // } // var keyval = 1; // using (var context = new TryItOutEFContext()) // { // context.Database.Log = Console.WriteLine; // var task = context.ToDoTasksEF.Find(keyval); // } //} //private static void ReadandUpdateToDoTask() { // using (var context = new ToDoTasksEFContext()) // { // context.Database.Log = Console.WriteLine; // ToDoTask task = context.ToDoTasksEF.FirstOrDefault(); // task.CompletedOn = DateTime.Now; // context.SaveChanges(); // } //} private static void InsertRegisteredUser() { var user_A = new RegisteredUser { Username = "******", Password = "******", Firstname = "David", Lastname = "Morton", IsActive = "True", LastLoggedIn = "", NumberOfAttemps = 0, Locked = false }; var user_B = new RegisteredUser { Username = "******", Password = "******", Firstname = "Yogi", Lastname = "Mistry", IsActive = "True", LastLoggedIn = "", NumberOfAttemps = 0, Locked = false }; using (var context = new RegisteredUserEFContext()) { context.Database.Log = Console.WriteLine; context.RegisteredUserEF.AddRange(new List <RegisteredUser> { user_A, user_B }); context.SaveChanges(); } }