AnantLabs / dotnetkicks

Automatically exported from code.google.com/p/dotnetkicks
0 stars 1 forks source link

Add support for Sql Server 2000 #37

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Please make it possible to run dotnetkicks on top of SQL Server 2000 by
rewriting the stored procedures to eliminate calls to the 2005 row_number
function.

Original issue reported on code.google.com by spam%bol...@gtempaccount.com on 7 Aug 2007 at 10:21

GoogleCodeExporter commented 9 years ago
I meant to log it as an enhancement... not a defect.

Original comment by spam%bol...@gtempaccount.com on 7 Aug 2007 at 10:22

GoogleCodeExporter commented 9 years ago
Hi, perhaps this sproc could be replaced with a SubSonic query? Can you please
investigate?

Original comment by gavinjo...@gmail.com on 8 Aug 2007 at 12:49

GoogleCodeExporter commented 9 years ago
Do you want to drop sp's in favor of queries performed on the app layer?

Original comment by simone.b...@gmail.com on 30 Sep 2007 at 11:26

GoogleCodeExporter commented 9 years ago
Doesn't most of the SPs use row_number for paging?

We could rewrite them to use SubSonic's paging right?

Or is there a SQL Server 2000 function that we can use to create alternate SQL
scripts with the same functionality?

Original comment by james.e....@gmail.com on 2 Oct 2007 at 12:28

GoogleCodeExporter commented 9 years ago
I think we should go with Subsonic queries.

Original comment by simone.b...@gmail.com on 2 Oct 2007 at 1:12

GoogleCodeExporter commented 9 years ago
We should use SubSonic queries wherever we can. If you can replace a sproc with 
one,
please do so.

Once SubSonic migrations are available, we can replace the create db sql 
scripts with
SubSonic migrations.

Original comment by gavinjo...@gmail.com on 3 Oct 2007 at 8:05