static void Insert() { Employee_dbEntities empdb = new Employee_dbEntities(); Employee e = new Employee(); e.Name = "Prashant"; e.Salary = 70000; empdb.Employees.Add(e); empdb.SaveChanges(); }
static void Delete(int id) { Employee_dbEntities empdb = new Employee_dbEntities(); Employee e = new Employee(); Employee emp = empdb.Employees.Find(id); empdb.Employees.Remove(emp); empdb.SaveChanges(); }
static void Update(int id) { Employee_dbEntities empdb = new Employee_dbEntities(); Employee e = new Employee(); Employee emp = empdb.Employees.Find(id); emp.Name = "Piyu"; empdb.SaveChanges(); }
static void Main(string[] args) { Employee_dbEntities empdb = new Employee_dbEntities(); var result = empdb.Employees.ToList <Employee>(); foreach (var x in result) { Console.WriteLine("{0} {1} {2} ", x.Id, x.Name, x.Salary); } // Insert(); Update(2002); Delete(2002); Console.ReadLine(); }