static void searchonlocation()
{
Console.WriteLine("Enter the Location");
String loc = Console.ReadLine();
using (EmployeeEntities context = new EmployeeEntities())
{
try
{
employee emp = context.employees.FirstOrDefault(r => r.location == loc);
TextInfo format = CultureInfo.CurrentCulture.TextInfo;
Console.WriteLine("Name: " + format.ToTitleCase(emp.empname));
Console.WriteLine("ID: " + format.ToTitleCase(emp.empid));
Console.WriteLine("\n");
Console.WriteLine(emp.empid + "," + emp.empname + "," + emp.dob + "," + emp.doj);
}
catch (Exception e)
{
Console.WriteLine(loc + " Not found");
}
}
}
