I know I'm prematurely asking, I really didn't do much digging on why, but I was hoping that someone might have a quick response to this question. This dilemma arose when building all the SPROC's for my data schema and got to needing a "GetEntities" SPROC which includes paging and sorting...

Can anyone tell me why in the SqlArticleProvider Marco put the function of GetArticles() in a SPROC, but in SqlStoreProvider, the GetProducts() (the query) is within the method?

From first look, both GetArticles() & GetProducts() seem quite similar, they get all data fields and include params for pageIndex and pageSize, the only difference I see is that GetProducts() includes a sortExpression. Is that the reason? Though it can be passed on to a SPROC too..

Is there a specific reason for this, or is it just meant to break up the rhythm and show variations of what can be done?


Thank you all,
Ronnie

You pretty much guessed it -- it is exactly because of the sortExpression. The query needs to support sorting on various fields, such as UnitPrice, Title, etc.

You mention that the sortExpression "can be passed on to a SPROC too", but this isn't really the case, as the ORDER BY clause doesn't support the use of parameters. That's the specific reason behind doing it with a String.Format() instead.

Thanks for the quick response Lee. As for passing to the SPROC, I was sure it was possible because I've done it before. BUT, I just dug through my SQL projects and reviewed the SPROC that included a sortExpression... It was dynamic, and now I remember why I had to put it in a dynamic query... Exactly because of your response.

While sticking with SPROC's for my queries as much as possible, and since I'm using ASP 3.5 in this project, I'll use LINQ for these type of queries (NO dynamic SPROC's ).

Thanks again,
Ronnie