static void Main(string[] args) { EmployeeEFDBEntities1 context = new EmployeeEFDBEntities1(); //var Employee = new Employee() //{ // EmpID = 1, // Name = "Shiva", // Salary = 35000, // DepID = 3, //}; //context.Employees.Add(Employee); //var Employee1 = new Employee() //{ // EmpID = 2, // Name = "SAI", // Salary = 35000, // SSN = 5, // DepID = 3, //}; //context.Employees.Add(Employee1); //var Employee2 = new Employee() //{ // EmpID = 3, // Name = "Surya", // Salary = 35000, // SSN = 2, // DepID = 12, //}; //context.Employees.Add(Employee2); LinqtoEntity(); ModifiyEmp(); DeleteEmp(); }
public static void DeleteEmp() { EmployeeEFDBEntities1 context = new EmployeeEFDBEntities1(); var employees = context.Employees; var Employee = new Employee { EmpID = 4 }; employees.Attach(Employee); employees.Remove(Employee); context.SaveChanges(); }
public static void LinqtoEntity() { EmployeeEFDBEntities1 context = new EmployeeEFDBEntities1(); var employees = context.Employees; var emplist = from Employee in employees orderby Employee.EmpID select Employee; foreach (var employee in emplist) { Console.WriteLine("EmpID {0} Name {1} Salary {2} SSN {3}", employee.EmpID, employee.Name, employee.Salary, employee.SSN); } }
public static void ModifiyEmp() { EmployeeEFDBEntities1 context = new EmployeeEFDBEntities1(); var employees = context.Employees; var emplist = from Employee in employees orderby Employee.EmpID select Employee; foreach (var employee in emplist) { if (employee.EmpID == 1) { employee.SSN = 99; } } context.SaveChanges(); }