private static void UpdateStudent(CollegeDBContext collegeDBContext)
{
Student student = collegeDBContext.Students.Find(2);
student.Name = "Yogeshkumar";
student.Standard = 5;
student.MobileNumber = 9517538426;
collegeDBContext.Update(student);
collegeDBContext.SaveChanges();
}
private static void GetStudents(CollegeDBContext collegeDBContext)
{
Console.WriteLine("====== Student List =======");
foreach (var student in collegeDBContext.Students)
{
Console.WriteLine("ID :\t" + student.ID);
Console.WriteLine("Name :\t" + student.Name);
Console.WriteLine("Standard :\t" + student.Standard);
Console.WriteLine("Mobile Number:\t" + student.MobileNumber);
Console.WriteLine();
}
}
private static void AddStudent(CollegeDBContext collegeDBContext)
{
collegeDBContext.Students.Add(new Student {
Name = "Sumit", Standard = 10, MobileNumber = 7600965621
});
collegeDBContext.Students.Add(new Student {
Name = "Yogesh", Standard = 8, MobileNumber = 9517538426
});
collegeDBContext.Students.Add(new Student {
Name = "Ajay", Standard = 12, MobileNumber = 9874563215
});
collegeDBContext.SaveChanges();
}
static void Main(string[] args)
{
CollegeDBContext _collegeDBContext = new CollegeDBContext();
AddStudent(_collegeDBContext);
Console.WriteLine("After Adding Student...\n");
GetStudents(_collegeDBContext);
UpdateStudent(_collegeDBContext);
Console.WriteLine("After Updating Student name Yoeshkumar and standard is 5...\n");
GetStudents(_collegeDBContext);
DeleteStudent(_collegeDBContext);
Console.WriteLine("After Removing Student which id is 2\n");
GetStudents(_collegeDBContext);
}
private static void DeleteStudent(CollegeDBContext collegeDBContext)
{
collegeDBContext.Students.Remove(collegeDBContext.Students.Find(2));
collegeDBContext.SaveChanges();
}
