Need some help with this one. I'm working on a site for a company that uses SubSonic 2.1, VS 2008, MySQL and C#.
Their current SubSonic build doesn't support MySQL paging. In order to correct this, I've attempted to upgrade the project to 2.2. I've tried two different methods.
Attempt #1 - Upgraded to 2.2 binary available on the site
If I replace the assemblies required and generate my code (using the build provider, or subcommander), SubSonic will not generate the stored procedures. StoredProcedures.cs is empty. Permissions are fine. The result is the same if I generate the code using the root user.
Attempt #2 - Built source myself using the 2.x github repos
If I build the most current source myself, and replace the assemblies, it generates the stored procedures. However, when I attempt to hit a page that uses a generate stored procedure I get this fun error message
System.ArgumentException: Parameter 'in_$PARAMETER_NAME_HERE$' not found in the collection.
Note: $PARAMETER_NAME_HERE$ is the name of the in param for the specific stored procedure.
Any ideas/suggestions?