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(string[] args)
{
sqlpracticeEntities entities = new sqlpracticeEntities();
// foreach(int x in emp)
var result = entities.EMps.Select(x => x);
Console.WriteLine("Employ Records are ");
foreach (var v in result)
{
Console.WriteLine("Employ No " + v.Empno);
Console.WriteLine("Employ Name " + v.nam);
Console.WriteLine("Department " + v.dept);
Console.WriteLine("Designation " + v.desig);
Console.WriteLine("Basic " + v.basic);
Console.WriteLine("--------------------------------------------");
}
}
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 ***");
}