public static void Insert(Empdemo obj)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
model_Emp_DB.Empdemoes.Add(obj);
model_Emp_DB.SaveChanges();
}
//Q2.Using model first approach generate database, and classes.
// [complete emp dept task] perform insert, delete, update
static void Main(string[] args)
{
Print();
// Creating Object
Empdemo emp = new Empdemo {
Name = "tshank", Salary = 45000, DeptdemoId = 2
};
//insert object as an entry into the database
Insert(emp);
//Updating the values(name and salary) of the employee in database using Id
UpdateName(10, "Tushank");
UpdateSalary(10, 48000);
//Deleting the employee in database using Id
Delete(7);
Console.WriteLine("\nAfter Modification:");
Print();
//Adding new Department
AddNewDept("FrontEnd");
PrintDept();
//Updating new Department
UpdateDept(4, "Backend");
PrintDept();
//Delete(6);
PrintDept();
}
public static void Delete(int id)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
Empdemo todelete = model_Emp_DB.Empdemoes.Find(id);
model_Emp_DB.Empdemoes.Remove(todelete);
model_Emp_DB.SaveChanges();
}
public static void UpdateSalary(int id, float salary)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
Empdemo update = model_Emp_DB.Empdemoes.Find(id);
update.Salary = salary;
model_Emp_DB.SaveChanges();
}
