Just another tech site

C# LINQ to Entity

Some interesting elements about LINQ to Entities.
dynamic query building


Let’s face it, in every situation we will need paging. Imaging that we want to show the data in tables.

public List<Client>
GetAllClients(bool? isActive, int pageNumber, int pageSize, out int totalPages)
//Actual query which returns large data
var query = dataContext.Clients.Where(p => isActive == null || p.IsActive == isActive);
//Calculating total number of pages by taking ceiling number of the fractional value
totalPages = (int)Math.Ceiling((decimal)query.Count() / (decimal)pageSize);
//Paging logic goes here
return query.Skip((pageNumber - 1)*pageSize).Take(pageSize).ToList();




Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Tag Cloud

%d bloggers like this: