private static void InsertStudent() { var s1 = new Student() { Id = Guid.NewGuid(), Name = "Akash", Cgpi = "8.6", Location = "Mumbai" }; var s2 = new Student() { Id = Guid.NewGuid(), Name = "Dhruv", Cgpi = "9.6", Location = "MiraRode" }; var s3 = new Student() { Id = Guid.NewGuid(), Name = "Sanal", Cgpi = "9.8", Location = "Raigad" }; db.Students.Add(s1); db.Students.Add(s2); db.Students.Add(s3); db.SaveChanges(); }
static void Main(string[] args) { // Create(); // ienumerableQuery(); // Update(); //var deleteQuery = dbcontext.Students.First<Student>(); //dbcontext.Students.Remove(deleteQuery); //dbcontext.SaveChanges(); var stud = dbcontext.Students.Find("176ED643 - 3FF4 - 4130 - 989A - 192FAE877C42"); dbcontext.Students.Remove(stud); dbcontext.SaveChanges(); }
private static void UpdateOPeration(SwabhavEFDBContext db) { var student = db.Students.Where((student1) => student1.Name.Equals("SANAL")); foreach (Student stud in student) { stud.CGPA = 9.5f; } db.SaveChanges(); Console.WriteLine("Data updated!"); }
private static void DeleteOpertion(SwabhavEFDBContext db) { var student = db.Students.Where((student1) => student1.Name.Equals("MANISH")); foreach (Student stud in student) { db.Students.Remove(stud); } db.SaveChanges(); Console.WriteLine("Data deleted!"); }
private static void InsertOPeration(SwabhavEFDBContext db) { db.Students.Add(new Student { Id = Guid.NewGuid(), Name = "MANISH", CGPA = 8f }); db.Students.Add(new Student { Id = Guid.NewGuid(), Name = "AKASH", CGPA = 8.5f }); db.Students.Add(new Student { Id = Guid.NewGuid(), Name = "SANAL", CGPA = 7.5f }); db.SaveChanges(); Console.WriteLine("Data Saved!"); }