Category: LINQ

10 Nov 2015 03:03

Joined:	07/03/2012
Level:	Silver
Points:	102

Points:	3

To make linq query faster

Hi All,

What should I do to make the following linq query faster? The database got heaps of records in it. This query actually followed by foreach loop and then again another query and foreach loop. It takes much time to load.
Help will be appreciated. Thank you.

var hours = from hr in objHours.Distinct()

where hr.EmployeeID == empGuid && hr.JobId == j.JID && hr.CatId == j.CatId.ToInt() && hr.Date.Year == DateTime.Now.Year
orderby hr.TID descending
select new
{
hr.Hour,
hr.Date,
hr.CatId
};

#763193

14 Nov 2015 01:46

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	2

Hai AP,
You can use instead lambda expression:


var hours = objHours.Distinct()
.Where(a=>a.EmployeeID == empGuid)
.Where(a =>a.JobId == j.JID)
.Where(a=>a.CatId == j.CatId.ToInt())
.Where(a =>a.Date.Year == DateTime.Now.Year)

Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#763206

16 Nov 2015 13:12

Joined:	07/03/2012
Level:	Silver
Points:	102

Points:	1

Hi,

Thank you very much Pawan. Could you please help me in doing that with IEnumerable?

Thank you once again.

To make linq query faster

About dotnetspider.com

Quick Links

General

Services