Padination in repeator

See more:

C#

ASP.NET

entity-framework

from n in dc.Jobs
                        .OrderBy(o => o.LocationName==location1)
                        .Take(take)
                        .Skip(pageSize)
                        select new
                        {
                             Title = n.Title,

                              Name = n.CompanyName,
                              LName=n.LocationName,
                              Description=n.JobDescription,
                              Count = dc.Jobs.Count()
};

I had written the query for pagination but it is loading all the records from the database,i want to load the records related to location1 value plz help me how to modify the query am new to entity framework