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