A quick getting started guide to SubSonic

This is a post originally published on my previous blog over on Blogger. I have copied it here as I very rarely go to my old blog anymore and this info may be of some use to someone out there.

Subsonic; an ORM which just works. I cannot believe how simple this was to set up.

1. Download it from CodePlex and run the executable.

2. Once it has installed create a link to the command in Visual Studio by going to Tools>>External Tools>>Add

This will generate the code for the DAL based on your settings in the web.config file.

3. Speaking of which here is a sample of the important parts of the web.config

   1: <configSections>

   2: <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false" />

   3:  

   4: <connectionStrings>

   5: <add name="connectionname" connectionString="Data Source=servername; Database=databasename; Integrated Security=true;" />

   6: </connectionStrings>

   7:  

   8: <SubSonicService defaultProvider="providername">

   9: <providers>

  10: <clear/>

  11: <add name="providername" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="connectionname" generatedNamespace="yournamespace"/>

  12: </providers>

  13: </SubSonicService>

  14: </configuration>

Just swap out connectionname, databasename, providername and yournamespace with your values.

4. Now the fun bit. Run Tools>>SubSonic. This will automatically generate the code for your ORM classes in a directory called Generated within your VS project. That is all you need to get up and running.

References:-

Getting started with SubSonic
For Web Sites - Using the BuildProvider
Video on getting started with SubSonic
Setting up SubSonic