So I finally convinced the rest of the developers and database admins to use subsonic and all the fast sweet love that comes with it. However I ran into a snag when trying to setup multiple databases using subsonic. Maybe I should clarify:
<SubSonicService Default"">
<providers>
<clear/>
<add name="DefaultDB" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="ConnectionString" generatedNamespace="DefaultDB"/>
<add name="DefaultDB2" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="ConnectionString" generatedNamespace="DefaultDB2"/>
</providers>
</SubSonicService>
It simply doesn't like more than one.
I have been sifting through all the forums for answers and having issues finding some answers.
Anyone know better than this? Let me know.
***Update:
So after a few weeks of serious digging into subsonic I found I was wrong about the multiple database setup. Have a look:Subsonic Without a Website
Don't let the name fool you it is very much for websites and all other .net apps. Enjoy.