This is a followup post to my SubSonic & DotNetNuke post and will contain more details of what this module does and how it is setup.
Step 1. The first is to download the PA and then install it like any other DNN module.
Step 2. Modify DNN's web.config by registering and adding the SubSonicService sections and connection strings.
Step 2.1 - Register SubSonicService configuration section.
Add the below to the configSections node of the web.Config file.
<section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" allowDefinition="MachineToApplication" restartOnExternalChanges="true" requirePermission="false"/>
Step 2.2 - Add connection strings to the web.Config in the following code between the <connectionStrings>...</connectionStrings> node. In this case I'm using the default SubSonic connection strings Northwind and Southwind which are actually the same Northwind database connection string.
You can use whatever database you want so long as SubSonic knows how to connect to it and you can add as many connection strings (i.e. Databases) as SubSonic or ASP.Net can handle (I don't think there is a limit currently.). One other note is that I'm connecting to SQL Server 2005 and not the Express edition.
You will see the below connection string or something similar (Express edition is different). This is the DNN connection string for the Portal. Do not modify it.
<add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=dnn450;User ID=****;Password=****" providerName="System.Data.SqlClient"/>
If you are going to use a different database than the DNN database then you can add a connection string to each database you want to connect to. The following are the default connection string(s) for SubSonic using the Northwind example database. You will need to change initial catalog, userid and password to your Database, user id, and password.
<
add name="Northwind" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;User ID=****;Password=****;"/>
<
add name="Southwind" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;User ID=****;Password=****;"/>
Step 2.3 - Add the SubSonicService Section to the web.Config. I placed the following code after the <connectionStrings>...</connectionStrings> node. Make sure to change the providers to correspond to the connection string(s) you setup in 2.2. The SiteSqlProvider is the provider that corresponds to the DNN connection string in 2.2. I change the generated Namespace to SSDotNetNuke so that wouldn't be any confusion with DotNetNuke's namespace. I don't recommend, and I have not tried, editing DNN core database tables unless you know EXACTLY what you are doing.
<SubSonicService defaultProvider="Northwind" templateDirectory="C:\Downloads\SubSonic\SubSonic_2.0_Beta_3\SubSonic\CodeGeneration\Templates">
<providers>
<clear/>
<add name="SiteSqlServer" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="SiteSqlServer" generatedNamespace="SSDotNetNuke" fixPluralClassName="true"/>
<add name="Northwind" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="Northwind" generatedNamespace="Northwind" fixPluralClassName="true"/>
<add name="Southwind" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="Northwind" generatedNamespace="Southwind" fixPluralClassName="true"/>
</providers>
</SubSonicService>
Step 3. Add the SubSonic_Scaffold Module to a page.
Click image to enlarge.
Step 4. Edit the SubSonic_Scaffold Module Settings.
Step 4.1. Open the DNN_SubSonic_Scaffold Settings area.
Step 4.2. Select a SubSonic Provider. You should see whatever providers you added here. In this example there would be 3. Northwind, SiteSqlServer, and Southwind.
Step 4.3. Select the Database table that you want to scaffold.
Step 4.4. Click on "Update" link to update the module settings.
In the below image I have selected the Northwind provider and the Categories table.
Step 5. View the updated module with the selected provider and table. Click on "Go to Scaffold" to go and edit the selected table. Note: This only displays to users that have been given module edit permissions.
Step 6. Editing the table. Click "Add" or "Edit" to do that action.
Here is a view of editing the Beverages category.
That is basically what it does at the moment. In simple terms a basic database table editor, but with the ability to edit multiple databases. Module developers that utilize SubSonic would also be able to utilize the multiple databases and the zero code DAL that SubSonic provides.
I seem to have issues with CommunityServer so please post comments at the following link.
SubSonic Community >> General Support >> CodeShare >> SubSonic & DotNetNuke