SubSonic missing stored procedures in StoredProcedures.cs when generated with SubCommander sonic.exe
- by Mark
We have been using SubSonic to generate our DAL with a lot of success on VS2005 and SubSonic Tools 2.0.3.
SubSonic Tools do not work on VS2008 (as far as we can work out) so we have tried to use SubCommander\sonic.exe and are now hitting some problems.
When we regenerate the project using SubCommander\sonic.exe and try to compile we get some errors reporting missing members (which should have been automatically generated based on the stored procedures we have).
On closer inspection it looks like my StoredProcedures.cs file is missing some (not all) automatically generated methods for my classes.
As an example, I have 2 procs:
[dbo]._ClassA_Func1
[dbo]._ClassA_Func2
Only one of these is being generated in the StoredProcedures.cs file.
These methods generate fine using the SubSonic Tools plugin.
We have tried now with versions 2.1 and 2.2 of SubSonic with the same issue.
We are still on .NET 2.0 so cannot use SubSonic 3.0.
I have checked the permissions of both procs using fn_my_permissions and they seem identical.
Does anyone have any ideas on what I can check?
Thanks -- Mark