private static void DataBaseCallMethod() { try { Database.SetInitializer(new MigrateDatabaseToLatestVersion <PracticeContext, Migrations.Configuration>()); //Database.SetInitializer(new DropCreateDatabaseIfModelChanges<PracticeContext>()); //DataBaseCall.SearchStudentByIQuerable(); //DataBaseCall.SearchStudentByIEnumerable(); //DataBaseCall.SearchStudentByToList(); //DataBaseCall.CreateStudent(); //DataBaseCall.GetStudents(); //DataBaseCall.Insert(new Student { Name = "Pratik Hero" }); //var students = DataBaseCall.Students; //DataBaseCall.Insert(new Branch { Name = "ME" }); //DataBaseCall.Insert(new Teacher { Name = "English Teacher" }); //DataBaseCall.Insert(new Teacher { Name = "Nepali Teacher" }); DataBaseCall.GetTeachers((teacher) => teacher.ID == 2).ForEach(b => Console.WriteLine($"Teacher Id: {b.ID}, Teacher Name: {b.Name}")); DataBaseCall.GetStudents((student) => true).ForEach(b => Console.WriteLine($"Student Id: {b.ID}, Student Name: {b.Name}")); DataBaseCall.Branches.ForEach(b => Console.WriteLine($"Branch Id: {b.ID}, Branch Name: {b.Name}")); } catch (Exception ex) { Console.WriteLine("Error occured while performing student operation.", ex.ToString()); } }
private static async void DataBaseCallMethod() { try { Database.SetInitializer(new MigrateDatabaseToLatestVersion <PracticeContext, Migrations.Configuration>()); //Database.SetInitializer(new DropCreateDatabaseIfModelChanges<PracticeContext>()); //DataBaseCall.SearchStudentByIQuerable(); //DataBaseCall.SearchStudentByIEnumerable(); //DataBaseCall.SearchStudentByToList(); //DataBaseCall.CreateStudent(); //DataBaseCall.GetStudents(); //DataBaseCall.Insert(new Student { Name = "Pratik Hero" }); //var result = DataBaseCall.InsertAsync(new Student { Name = "Pratik Hero" }); //Console.WriteLine(result.Result.Name); //DataBaseCall.Insert(new Branch { Name = "ME" }); //DataBaseCall.Insert(new Teacher { Name = "Math Teacher", Salary = 1000, Email = "*****@*****.**" }); //DataBaseCall.Insert(new Teacher { Name = "Nepali Teacher", Salary = 2000 }); //Func<Teacher, bool> func = (teacher) => true; //DataBaseCall.GetList(func).ForEach(b => Console.WriteLine($"Teacher Id: {b.ID}, Teacher Name: {b.Name}")); //DataBaseCall.GetStudentsByDynamicExpression().ForEach(b => Console.WriteLine($"Student Id: {b.ID}, Student Name: {b.Name}")); //DataBaseCall.GetStudentsByDynamicExpression<Student, bool>(DbClause.WhereThenOrderBy, (student) => true).ForEach(b => Console.WriteLine($"Student Id: {b.ID}, Student Name: {b.Name}")); //var students = new List<Student>(); //var results = await DataBaseCall.InsertListAsync(students); //Console.WriteLine(); //Console.WriteLine(); //DataBaseCall.GetStudents(); var results = await DataBaseCall.GetListAsync <Student>(); Console.WriteLine("Student Records."); foreach (var result in results) { Console.WriteLine($"ID: {result.ID}, Name: {result.Name}"); } } catch (Exception ex) { Console.WriteLine("Error occured while performing student operation.", ex.ToString()); } }