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();
}
