tag:blogger.com,1999:blog-11646261.post9134044284078929605..comments2024-01-02T00:43:44.344-08:00Comments on OakLeaf Systems: Dynamic ORDER BY Clauses for ASP.NET Server-Side Paging with Stored ProceduresRoger Jennings (--rj)http://www.blogger.com/profile/01700526164060680385noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-11646261.post-14138652414603586912009-12-18T07:51:21.393-08:002009-12-18T07:51:21.393-08:00Does anybody know why Microsoft hasn't come up...Does anybody know why Microsoft hasn't come up with an eval() function in SQL server? It's a common method that almost every language has. This shouldn't be a problem in first place and yet it is. They should come up with a cleaner/painless way for us to do this before they come up with another version.Johnnyhttps://www.blogger.com/profile/06828660989199978085noreply@blogger.comtag:blogger.com,1999:blog-11646261.post-55386295122427449232008-07-21T09:09:00.000-07:002008-07-21T09:09:00.000-07:00@Anon,My experience is that LINQ to SQL queries be...@Anon,<BR/><BR/>My experience is that LINQ to SQL queries become quite suboptimal as they increase in complexity. This is particularly the case with queries that involve associated entities in many:one and one:many relationships.<BR/><BR/>Microsoft is promoting Entity Framework to the exclusion of LINQ to SQL, so it's not likely that it will receive further updates.<BR/><BR/>--rjRoger Jennings (--rj)https://www.blogger.com/profile/01700526164060680385noreply@blogger.comtag:blogger.com,1999:blog-11646261.post-55286544101730135672008-07-21T08:31:00.000-07:002008-07-21T08:31:00.000-07:00Hey --rj,This is a open for debate I guess, I like...Hey --rj,<BR/><BR/>This is a open for debate I guess, I like the solution, but I have to agree with Anonymous 1 on this one. In your instance users need Select priviliges anyway, to create a dynamic piece of SQL in a varchar(max) variable and then execute it will reduce compilation time and execution time heavily. I'm assuming you are not typing this piece of SP out anyway (that would just be Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11646261.post-56004879938702183242007-09-19T10:44:00.000-07:002007-09-19T10:44:00.000-07:00Anonymous,How would you propose to provide ad-hoc ...Anonymous,<BR/><BR/>How would you propose to provide ad-hoc sorts with server-side paging for ADO.NET?<BR/><BR/>Enable dynamic SQL with SELECT privileges for users?<BR/><BR/>--rjRoger Jennings (--rj)https://www.blogger.com/profile/01700526164060680385noreply@blogger.comtag:blogger.com,1999:blog-11646261.post-46766545419797834902007-09-18T22:48:00.000-07:002007-09-18T22:48:00.000-07:00Thanks for sharing the information.However, I hope...Thanks for sharing the information.<BR/><BR/>However, I hope I never see such bloated SPROCs in my team - ever :-)<BR/><BR/>In my oppinion, this is a clear example of how *not* to use SPROCs with LINQ to SQL.Anonymousnoreply@blogger.com