static void Main()
{
sqlpracticeEntities entites = new sqlpracticeEntities();
int empno;
Console.WriteLine("Enter Employ No ");
empno = Convert.ToInt32(Console.ReadLine());
EMp result = entites.EMps.Where(x => x.Empno == empno).FirstOrDefault <EMp>();
Console.WriteLine(result.Empno);
Console.WriteLine(result.nam);
Console.WriteLine(result.dept);
}
static void Main()
{
EMp emp = new EMp();
Console.WriteLine("Enter Employ No ");
emp.Empno = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter Employ Name ");
emp.nam = Console.ReadLine();
Console.WriteLine("Enter Department ");
emp.dept = Console.ReadLine();
Console.WriteLine("Enter Designation ");
emp.desig = Console.ReadLine();
Console.WriteLine("Enter Basic ");
emp.basic = Convert.ToInt32(Console.ReadLine());
sqlpracticeEntities entities = new sqlpracticeEntities();
entities.EMps.Add(emp);
entities.SaveChanges();
Console.WriteLine("*** Record Inserted ***");
}
