LINQ Read Distinct Record from Data Table

By Using LINQ how we can read distinct values. Below is my Data Table from which I will read distinct column value.

Image 1.

If I write query to fetch City column values:

public JsonResult getEmpCity()
{
        using (CompanyDBEntities dc = new CompanyDBEntities())
        {
            var query = (from p in dc.Emp_Information
                         select p.City).ToList();
            return new JsonResult
                {
                    Data = query.ToList(),
                    JsonRequestBehavior = JsonRequestBehavior.AllowGet
                };
            }
        }
 

Debug this call and see result.

Image 2.

Now write your code like below:

public JsonResult getEmpCity()
        {
            using (CompanyDBEntities dc = new CompanyDBEntities())
            {
                var query = (from p in dc.Emp_Information
                             select p.City).Distinct().ToList();
                return new JsonResult
                {
                    Data = query.ToList(),
                    JsonRequestBehavior = JsonRequestBehavior.AllowGet
                };
            }
        }
 

And See result.

Image 3.