You must Sign In to post a response.

Category: LINQ

08 Sep 2015 00:55

Joined:	29/06/2011
Level:	Silver
Points:	333

Points:	4

Please suggest correct patter for best in performance

hi,
i am write a code for fetching records using stored procedure.
pattern 1:-
var objList = db.SP_GetHotelcustomseting(propertyId, modulebyId).ToList();
return objList;
pattern 2:-
var objList = (from P in _db.SP_GetHotelcustomseting(propertyId, modulebyId)
select P).ToList();
return objList;

please suggest to me which is best.

thanks & regards,
Atul Sharma

#762182

08 Sep 2015 01:18

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	3

Hi

I think this is best

pattern 1:-
var objList = db.SP_GetHotelcustomseting(propertyId, modulebyId).ToList();
return objList;

because Stored procedure pre compiler so we have fetch data quickly

your pattern 2 like select query so this is execute normal query so this we no need use this type

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

Submit New Thread

Return to Return to Discussion Forum

Please suggest correct patter for best in performance

About dotnetspider.com

Quick Links

General

Services