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