public static void Main(string[] args) { MyDbEntities db = new MyDbEntities(); Area newArea = new Area() { AreaName = "Oxford Street", CityId = 4, Pincode = "123456" }; db.Areas.Add(newArea); Console.WriteLine("After Adding"); foreach (var tracker in db.ChangeTracker.Entries <Area>()) { Console.WriteLine(tracker.State); } Area modifiedArea = db.Areas.Find(3); if (modifiedArea != null) { modifiedArea.Pincode = "124522"; Console.WriteLine("After Modification"); foreach (var tracker in db.ChangeTracker.Entries <Area>()) { Console.WriteLine(tracker.State); } } Area delArea = db.Areas.Find(1); if (delArea != null) { db.Areas.Remove(delArea); } Console.WriteLine("After Deletion"); foreach (var tracker in db.ChangeTracker.Entries <Area>()) { Console.WriteLine(tracker.State); } Console.ReadLine(); }
public static void Main(string[] args) { MyDbEntities db = new MyDbEntities(); Area areaObj = new Area(); int opt, id; do { Console.WriteLine("1:New Record\n 2:Display\n3:Update Record \n4:Delete Record\n 5:Exit"); Console.Write("Enter Your Option"); opt = Convert.ToInt32(Console.ReadLine()); switch (opt) { case 1: // add new Record Console.WriteLine("Enter Area Name, CityId and Pincode:"); areaObj.AreaName = Console.ReadLine(); areaObj.CityId = Convert.ToInt32(Console.ReadLine()); areaObj.Pincode = Console.ReadLine(); db.Areas.Add(areaObj); db.SaveChanges(); break; case 2: // read all Records foreach (Area a in db.Areas) { Console.WriteLine("{0}\t{1}\t{2}\t{3}", a.AreaId, a.AreaName, a.Pincode, a.City.CityName); } break; case 3: // update Records Console.Write("Enter Id to Update:"); id = Convert.ToInt32(Console.ReadLine()); areaObj = db.Areas.Find(id); if (areaObj == null) { Console.WriteLine("Invalid Area Id, Try Again"); } else { Console.WriteLine("Enter Modified Area Name, CityId and Pincode:"); areaObj.AreaName = Console.ReadLine(); areaObj.CityId = Convert.ToInt32(Console.ReadLine()); areaObj.Pincode = Console.ReadLine(); db.SaveChanges(); } break; case 4: // delete Records Console.Write("Enter Id to Delete:"); id = Convert.ToInt32(Console.ReadLine()); areaObj = db.Areas.Find(id); if (areaObj == null) { Console.WriteLine("Invalid Area Id, Try Again"); } else { db.Areas.Remove(areaObj); db.SaveChanges(); } break; case 5: break; default: Console.WriteLine("Invalid Option "); break; } }while(opt != 5); }