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