public static void deleteData() { Model_EmpContainer m = new Model_EmpContainer(); EmpDemo e = m.EmpDemoes.Find(3); m.EmpDemoes.Remove(e); m.SaveChanges(); }
public static void updateData() { Model_EmpContainer m = new Model_EmpContainer(); EmpDemo e = m.EmpDemoes.Find(4); e.Name = "Paresh"; m.SaveChanges(); }
public static void insertData() { Model_EmpContainer m = new Model_EmpContainer(); EmpDemo e = new EmpDemo(); e.Id = 01; e.Name = "Ajay"; e.Salary = 30000; e.DeptDemoId = 01; m.EmpDemoes.Add(e); m.SaveChanges(); }
static void Main(string[] args) { Model_EmpContainer m1 = new Model_EmpContainer(); List <EmpDemo> e = m1.EmpDemoes.ToList <EmpDemo>(); foreach (EmpDemo ee in e) { Console.WriteLine("{0} {1} {2} {3}", ee.Id, ee.Name, ee.Salary, ee.DeptDemoId); } // insertData(); //updateData(); deleteData(); }
public static void deptWiseEmp() { Model_EmpContainer m = new Model_EmpContainer(); var v = from dt in m.EmpDemoes group dt by dt.DeptDemoId; foreach (var s in v) { Console.WriteLine("{0}", s.Key); foreach (var rs in s) { Console.WriteLine("{0} {1} {2} ", rs.Name, rs.Salary, rs.DeptDemo.Name); } } }
static void Main(string[] args) { Model_EmpContainer m1 = new Model_EmpContainer(); List <EmpDemo> e = m1.EmpDemoes.ToList <EmpDemo>(); foreach (EmpDemo ee in e) { Console.WriteLine("{0} {1} {2} {3}", ee.Id, ee.Name, ee.Salary, ee.DeptDemoId); } // insertData(); //updateData(); //deleteData(); //deptWiseEmp(); var rs = (from c in m1.EmpDemoes select c).Count <EmpDemo>(); Console.WriteLine("Number of Employees = {0}", rs); var mx = (from cs in m1.EmpDemoes select cs.Salary).Max(); Console.WriteLine("Maximum Salary = {0}", mx); }