public static void delete()
{
EmployeeEFDBEntities context = new EmployeeEFDBEntities();
var employee = new Employee()
{
EmpID = 4
};
context.Employees.Attach(employee);
context.Employees.Remove(employee);
context.SaveChanges();
}
public static void ModifyEmployee()
{
EmployeeEFDBEntities context = new EmployeeEFDBEntities();
var employe = context.Employees;
var emlist = from emp in employe
orderby emp.Salary
select emp;
foreach (var em in emlist)
{
if (em.EmpID == 1)
{
em.Name = "Mathew Mcdonald";
}
}
context.SaveChanges();
}
static void Main(string[] args)
{
EmployeeEFDBEntities context = new EmployeeEFDBEntities();
var employee = new Employee()
{
EmpID = 1,
Name = "Vicky lanz",
Salary = 35000,
SSN = 23454,
DepID = 3
};
var employee1 = new Employee()
{
EmpID = 2,
Name = "John Snow",
Salary = 35000,
SSN = 23452,
DepID = 2
};
var employee2 = new Employee()
{
EmpID = 3,
Name = "Arya Stark",
Salary = 35000,
SSN = 234454,
DepID = 1
};
context.Employees.Add(employee1);
context.Employees.Add(employee2);
context.SaveChanges();
LinqToEntity();
ModifyEmployee();
delete();
}