Anton Afanasyev avatar Anton Afanasyev committed ba8c62a

use .sql extension for sql scripts - because it is much easier to open it in the
corresponding editor this way (but still allow .sqldataprovider)
clean up build targets file - we use .net 4 at the very least here, so can use
new (since .net 3.5) MSBuild features
clean up documentation html and css
convert to not using IIS - we're not going to 'run' the project anyway, so may
as well not require pollution of IIS at project creation.

Comments (0)

Files changed (22)

VSIX/CSharp-DAL2-Template/BuildScripts/ModulePackage.targets

 <!-- REMEMBER THAT IF YOU MODIFY THE TARGETS FILE YOU NEED TO CLOSE/OPEN THE PROJECT FOR THE CHANGES TO TAKE EFFECT -->
 
 <Project ToolsVersion="3.5" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
-  <Target Name="AfterClean" DependsOnTargets="CleanModule">
-  </Target>
-  <Target Name="AfterBuild" DependsOnTargets="PackageModule">
-  </Target>
+	<Target Name="AfterClean" DependsOnTargets="CleanModule">
+	</Target>
+	<Target Name="AfterBuild" DependsOnTargets="PackageModule">
+	</Target>
 
-  <Target Name="CleanModule">
-    <XmlRead Prefix="n"
-                    Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
-                    XPath="dotnetnuke/packages/package[1]/@version"
-                    XmlFileName="$(DNN_Package_FileName).dnn">
-      <Output TaskParameter="Value" PropertyName="Version" />
-    </XmlRead>
+	<Target Name="CleanModule">
+		<XmlRead Prefix="n"
+						Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
+						XPath="dotnetnuke/packages/package[1]/@version"
+						XmlFileName="$(DNN_Package_FileName).dnn">
+			<Output TaskParameter="Value" PropertyName="Version" />
+		</XmlRead>
 
-    <Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
-    <Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
-  </Target>
-  <Target Name="PackageModule"> <!-- Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">-->
-    <XmlRead Prefix="n"
-                    Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
-                    XPath="dotnetnuke/packages/package[1]/@version"
-                    XmlFileName="$(DNN_Package_FileName).dnn">
-      <Output TaskParameter="Value" PropertyName="Version" />
-    </XmlRead>
+		<Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
+		<Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
+	</Target>
+	<Target Name="PackageModule">
+		<!-- Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">-->
+		<XmlRead Prefix="n"
+						Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
+						XPath="dotnetnuke/packages/package[1]/@version"
+						XmlFileName="$(DNN_Package_FileName).dnn">
+			<Output TaskParameter="Value" PropertyName="Version" />
+		</XmlRead>
 
-    <!--in VS 2012 we exclude the packages folder -->
-    <ItemGroup>     
-      <InstallInclude Include="**\*.ascx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.asmx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.css" Exclude="packages\**" />
-      <InstallInclude Include="**\*.html" Exclude="packages\**" />
-      <InstallInclude Include="**\*.htm" Exclude="packages\**" />
-      <InstallInclude Include="**\*.resx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.aspx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.js" Exclude="packages\**" />
-      <InstallInclude Include="**\*.txt"  Exclude="**\obj\**;**\_ReSharper*\**;packages\**;" />
-      <InstallInclude Include="**\images\**" Exclude="packages\**" />
-      
-    </ItemGroup>
+		<!--in VS 2012 we exclude the packages folder -->
+		<ItemGroup>
+			<InstallInclude Include="**\*.ascx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.asmx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.css" Exclude="packages\**" />
+			<InstallInclude Include="**\*.html" Exclude="packages\**" />
+			<InstallInclude Include="**\*.htm" Exclude="packages\**" />
+			<InstallInclude Include="**\*.resx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.aspx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.js" Exclude="packages\**" />
+			<InstallInclude Include="**\*.txt"  Exclude="**\obj\**;**\_ReSharper*\**;packages\**;" />
+			<InstallInclude Include="**\images\**" Exclude="packages\**" />
+		</ItemGroup>
 
-    <ItemGroup>
-      <SourceInclude Include="**\*.ascx" />
-      <SourceInclude Include="**\*.asmx" />
-      <SourceInclude Include="**\*.css" />
-      <SourceInclude Include="**\*.xsl" />
-      <SourceInclude Include="**\*.html" />
-      <SourceInclude Include="**\*.htm" />
-      <SourceInclude Include="**\*.resx" />
-      <SourceInclude Include="**\*.xml" Exclude="**\obj\**;**\_ReSharper*\**;" />
-      <SourceInclude Include="**\*.aspx" />
-      <SourceInclude Include="**\*.js" />
-      <SourceInclude Include="**\*.dnn" />
-      <SourceInclude Include="**\*.txt" Exclude="**\obj\**;**\_ReSharper*\**;" />
-      <SourceInclude Include="**\images\**" />
-      <SourceInclude Include="**\packages\**" />
-      <SourceInclude Include="**\*.cs" />
-      <SourceInclude Include="**\*.cs.designer" />
-      <SourceInclude Include="**\*.csproj" />
-      <SourceInclude Include="**\*.targets" />
-      <SourceInclude Include="**\*.sln" />
-    </ItemGroup>
+		<ItemGroup>
+			<SourceInclude Include="**\*.ascx" />
+			<SourceInclude Include="**\*.asmx" />
+			<SourceInclude Include="**\*.css" />
+			<SourceInclude Include="**\*.xsl" />
+			<SourceInclude Include="**\*.html" />
+			<SourceInclude Include="**\*.htm" />
+			<SourceInclude Include="**\*.resx" />
+			<SourceInclude Include="**\*.xml" Exclude="**\obj\**;**\_ReSharper*\**;" />
+			<SourceInclude Include="**\*.aspx" />
+			<SourceInclude Include="**\*.js" />
+			<SourceInclude Include="**\*.dnn" />
+			<SourceInclude Include="**\*.txt" Exclude="**\obj\**;**\_ReSharper*\**;" />
+			<SourceInclude Include="**\images\**" />
+			<SourceInclude Include="**\packages\**" />
+			<SourceInclude Include="**\*.cs" />
+			<SourceInclude Include="**\*.cs.designer" />
+			<SourceInclude Include="**\*.csproj" />
+			<SourceInclude Include="**\*.targets" />
+			<SourceInclude Include="**\*.sln" />
+		</ItemGroup>
 
-    <!-- some helpful file names and listings -->
-    <CreateItem Include="$(DNN_Package_FileName).dnn">
-      <Output TaskParameter="Include" ItemName="PackageManifestFiles" />
-    </CreateItem>
+		<!-- some helpful file names and listings -->
+		<ItemGroup>
+			<PackageManifestFiles Include="$(DNN_Package_FileName).dnn" />
+		</ItemGroup>
 
-    <CreateItem Include="**\License.txt">
-      <Output TaskParameter="Include" ItemName="PackageTxtFiles" />
-    </CreateItem>
+		<ItemGroup>
+			<PackageTxtFiles Include="**\License.txt" />
+			<PackageTxtFiles Include="**\ReleaseNotes.txt" />
+		</ItemGroup>
+		
+		<ItemGroup>
+			<SqlDataProviderFiles Include="**\*.sqldataprovider" />
+			<SqlDataProviderFiles Include="**\*.sql" />
+		</ItemGroup>
 
-    <CreateItem Include="**\ReleaseNotes.txt">
-      <Output TaskParameter="Include" ItemName="PackageTxtFiles" />
-    </CreateItem>
 
+		<!-- install package -->
+		<Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
+		<Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
+		<Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
+		<Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
 
-    <CreateItem Include="**\*.sqldataprovider">
-      <Output TaskParameter="Include" ItemName="SqlDataProviderFiles" />
-    </CreateItem>
+		<!-- create the INSTALL RESOURCES.ZIP file -->
+		<Copy SourceFiles="@(InstallInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
 
+		<ItemGroup>
+			<InstallContent Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*" />
+		</ItemGroup>
 
-    <!-- install package -->
-    <Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
-    <Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
-    <Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
-    <Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
-    
-    <!-- create the INSTALL RESOURCES.ZIP file -->
-    <Copy SourceFiles="@(InstallInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
+		<Zip Files="@(InstallContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*">
-      <Output TaskParameter="Include" ItemName="InstallContent" />
-    </CreateItem>
-    
-    <Zip Files="@(InstallContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
+		<ItemGroup>
+			<OutputInstall Include="$(MSBuildProjectDirectory)\Package\**\*.*" />
+		</ItemGroup>
+		<!-- Create the Install package -->
+		<Zip Files="@(OutputInstall)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
+		<!-- Copy the Install package to the Packages folder -->
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\Package\**\*.*">
-      <Output TaskParameter="Include" ItemName="OutputInstall" />
-    </CreateItem>
-    <!-- Create the Install package -->    
-    <Zip Files="@(OutputInstall)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
-    <!-- Copy the Install package to the Packages folder -->
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
+		<!-- clean up -->
+		<Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
+		<Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
 
-    <!-- clean up -->
-    <Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
-    <Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
 
-    
 
-    <!-- sources package -->
-    <Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
-    <Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
-    <Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
-    <Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
+		<!-- sources package -->
+		<Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
+		<Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
+		<Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
+		<Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
 
-    <!-- create the SOURCE RESOURCES.ZIP file -->
-    <Copy SourceFiles="@(SourceInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
+		<!-- create the SOURCE RESOURCES.ZIP file -->
+		<Copy SourceFiles="@(SourceInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*">
-      <Output TaskParameter="Include" ItemName="SourceContent" />
-    </CreateItem>
+		<ItemGroup>
+			<SourceContent Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*" />
+		</ItemGroup>
 
-    <Zip Files="@(SourceContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
+		<Zip Files="@(SourceContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\Package\**\*.*">
-      <Output TaskParameter="Include" ItemName="OutputSource" />
-    </CreateItem>
+		<ItemGroup>
+			<OutputSource Include="$(MSBuildProjectDirectory)\Package\**\*.*" />
+		</ItemGroup>
 
-    <!-- Create the Source package -->    
-    <Zip Files="@(OutputSource)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
-    <!-- Copy the Source package to the Packages folder -->
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
+		<!-- Create the Source package -->
+		<Zip Files="@(OutputSource)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
+		<!-- Copy the Source package to the Packages folder -->
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
 
-    <!-- cleanup -->
-    <Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
-    <Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
-    
-  </Target>
+		<!-- cleanup -->
+		<Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
+		<Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
+
+	</Target>
 </Project>

VSIX/CSharp-DAL2-Template/CSharp-DAL2-Template.csproj

   </ItemGroup>
   <ItemGroup>
     <None Include="BuildScripts\ModulePackage.targets" />
-    <None Include="DnnTemplate.dnn" />
-    <None Include="Providers\DataProviders\SqlDataProvider\00.00.01.SqlDataProvider" />
-    <None Include="Providers\DataProviders\SqlDataProvider\Uninstall.SqlDataProvider" />
+    <None Include="DnnTemplate.dnn">
+      <SubType>Designer</SubType>
+    </None>
+    <Content Include="Providers\DataProviders\SqlDataProvider\00.00.01.sql" />
+    <Content Include="Providers\DataProviders\SqlDataProvider\Uninstall.sql" />
   </ItemGroup>
   <ItemGroup>
     <None Include="Components\FeatureController.cs" />

VSIX/CSharp-DAL2-Template/DNN-C-DAL2-Module.vstemplate

       <Folder Name="Providers" TargetFolderName="Providers">
         <Folder Name="DataProviders" TargetFolderName="DataProviders">
           <Folder Name="SqlDataProvider" TargetFolderName="SqlDataProvider">
-            <ProjectItem ReplaceParameters="true" TargetFileName="00.00.01.SqlDataProvider">00.00.01.SqlDataProvider</ProjectItem>
-            <ProjectItem ReplaceParameters="true" TargetFileName="Uninstall.SqlDataProvider">Uninstall.SqlDataProvider</ProjectItem>
+            <ProjectItem ReplaceParameters="true" TargetFileName="00.00.01.sql">00.00.01.sql</ProjectItem>
+            <ProjectItem ReplaceParameters="true" TargetFileName="Uninstall.sql">Uninstall.sql</ProjectItem>
           </Folder>
         </Folder>
       </Folder>

VSIX/CSharp-DAL2-Template/DnnTemplate.csproj

 		<Content Include="App_LocalResources\Settings.ascx.resx" />
 	</ItemGroup>
 	<ItemGroup>
-		<Content Include="Providers\DataProviders\SqlDataProvider\00.00.01.SqlDataProvider" />
-		<Content Include="Providers\DataProviders\SqlDataProvider\Uninstall.SqlDataProvider" />
+		<Content Include="Providers\DataProviders\SqlDataProvider\00.00.01.sql" />
+		<Content Include="Providers\DataProviders\SqlDataProvider\Uninstall.sql" />
 	</ItemGroup>
 	<PropertyGroup>
 		<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
 			<FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">
 				<WebProjectProperties>
 					<UseIIS>True</UseIIS>
+					<UseIISExpress>True</UseIISExpress>
 					<AutoAssignPort>False</AutoAssignPort>
 					<DevelopmentServerPort />
 					<DevelopmentServerVPath />

VSIX/CSharp-DAL2-Template/DnnTemplate.dnn

 						<basePath>DesktopModules\$safeprojectname$</basePath>
 						<script type="Install">
 							<path>Providers\DataProviders\SqlDataProvider</path>
-							<name>00.00.01.SqlDataProvider</name>
+							<name>00.00.01.sql</name>
 							<version>00.00.01</version>
 						</script>
 						<script type="UnInstall">
 							<path>Providers\DataProviders\SqlDataProvider</path>
-							<name>Uninstall.SqlDataProvider</name>
+							<name>Uninstall.sql</name>
 							<version>00.00.01</version>
 						</script>
 					</scripts>

VSIX/CSharp-DAL2-Template/Documentation/Documentation.css

 
-Body, A
-{
+body, a {
 	font-family: Verdana, Arial, Helvetica, Sans Serif;
+}
+
+body {
 	font-size: 10pt;
 	font-weight: normal;
 	color: black;
-}
-
-Body
-{
 	background-color: white;
 	margin-left: 25px;
 }
 
-H1
-{
-	font-size: 2.0em;
+
+h1, h2, h3, h4, h5, h6 {
 	font-weight: bold;
 	color: #75808A;
+}
+h1 {
+	font-size: 2.0em;
 	text-decoration: underline;
 }
 
-H2
-{
+h2 {
 	font-size: 1.6em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H3
-{
+h3 {
 	font-size: 1.4em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H4
-{
+h4 {
 	font-size: 1.2em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H5
-{
+h5 {
 	font-size: 1.1em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H6
-{
+h6 {
 	font-size: 1.0em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-A:link
-{
+a, a:link, a:visited, a:active {
 	font-size: 1.0em;
 	text-decoration: underline;
 	color: #0000cc;
 }
 
-A:visited
-{
-	font-size: 1.0em;
-	text-decoration: underline;
-	color: #0000cc;
-}
-
-A:active
-{
-	font-size: 1.0em;
-	text-decoration: underline;
-	color: #0000cc;
-}
-
-A:hover
-{
-	font-size: 1.0em;
-	text-decoration: underline;
+a:hover {
 	color: #cc0000;
 }
 
-HR
-{
+hr {
 	color: dimgrey;
 	height: 1pt;
 	text-align: left;

VSIX/CSharp-DAL2-Template/Documentation/Documentation.html

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
 <head>
-	<title>$ownername$ $safeprojectname$ DNN Module Documentation</title>
+	<title>$ownername$ $safeprojectname$ DAL2 DNN Module Documentation</title>
 	<link rel="stylesheet" type="text/css" href="Documentation.css" />
 </head>
 <body>
 		<p>
 			Congrats! You've just created a DotNetNuke Module. This module has some specific
 			functionality implemented using the new DAL2 (data access layer) in DotNetNuke 7.0.
-			With that, you will find that it has a sample SQL table in the providers/dataproviders/sqldataprovider/00.00.01.sqldataprovider
+			With that, you will find that it has a sample SQL table in the providers/dataproviders/sqldataprovider/00.00.01.sql
 			folder, this will be executed when the module is installed usign the instructions
 			below. This project provides the ability to create Items, and display a list of
 			those items. You can also Edit and Delete items after they have been created. You
 			module.
 		</p>
 		<ol>
-			<li><strong style="font-weight: bold; font-style: none">BEFORE</strong> checking the
+			<li><strong>BEFORE</strong> checking the
 				module into your source control environment check the following.</li>
 			<li>Edit the Project properties by double-clicking on the Properties folder in Solution
 				Explorer</li>

VSIX/CSharp-DAL2-Template/Providers/DataProviders/SqlDataProvider/00.00.01.SqlDataProvider

-/************************************************************/
-/*****              SqlDataProvider                     *****/
-/*****                                                  *****/
-/*****                                                  *****/
-/***** Note: To manually execute this script you must   *****/
-/*****       perform a search and replace operation     *****/
-/*****       for {databaseOwner} and {objectQualifier}  *****/
-/*****                                                  *****/
-/************************************************************/
-
-IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]') AND type in (N'U'))
-DROP TABLE {databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]
-GO
-
-CREATE TABLE {databaseOwner}{objectQualifier}$safeownername$_$safeprojectname$_Items
-	(
-	ItemId int NOT NULL IDENTITY (1, 1),
-	ItemName nvarchar(MAX) NOT NULL,
-	ItemDescription nvarchar(MAX) NOT NULL,
-	AssignedUserId int NULL,
-	ModuleId int NOT NULL,
-	CreatedOnDate datetime NOT NULL,
-	CreatedByUserId int NOT NULL,
-	LastModifiedOnDate datetime NOT NULL,
-	LastModifiedByUserId int NOT NULL
-	)  ON [PRIMARY]
-	TEXTIMAGE_ON [PRIMARY]
-GO
-
-
-ALTER TABLE {databaseOwner}{objectQualifier}$safeownername$_$safeprojectname$_Items ADD CONSTRAINT
-	PK_{objectQualifier}$safeownername$_$safeprojectname$_Items PRIMARY KEY CLUSTERED 
-	(
-	ItemId
-	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-
-GO
-
-
-/************************************************************/
-/*****              SqlDataProvider                     *****/
-/************************************************************/

VSIX/CSharp-DAL2-Template/Providers/DataProviders/SqlDataProvider/00.00.01.sql

+/************************************************************/
+/*****              SqlDataProvider                     *****/
+/*****                                                  *****/
+/*****                                                  *****/
+/***** Note: To manually execute this script you must   *****/
+/*****       perform a search and replace operation     *****/
+/*****       for {databaseOwner} and {objectQualifier}  *****/
+/*****                                                  *****/
+/************************************************************/
+
+IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]') AND type in (N'U'))
+DROP TABLE {databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]
+GO
+
+CREATE TABLE {databaseOwner}{objectQualifier}$safeownername$_$safeprojectname$_Items
+	(
+	ItemId int NOT NULL IDENTITY (1, 1),
+	ItemName nvarchar(MAX) NOT NULL,
+	ItemDescription nvarchar(MAX) NOT NULL,
+	AssignedUserId int NULL,
+	ModuleId int NOT NULL,
+	CreatedOnDate datetime NOT NULL,
+	CreatedByUserId int NOT NULL,
+	LastModifiedOnDate datetime NOT NULL,
+	LastModifiedByUserId int NOT NULL
+	)  ON [PRIMARY]
+	TEXTIMAGE_ON [PRIMARY]
+GO
+
+
+ALTER TABLE {databaseOwner}{objectQualifier}$safeownername$_$safeprojectname$_Items ADD CONSTRAINT
+	PK_{objectQualifier}$safeownername$_$safeprojectname$_Items PRIMARY KEY CLUSTERED 
+	(
+	ItemId
+	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+
+GO
+
+
+/************************************************************/
+/*****              SqlDataProvider                     *****/
+/************************************************************/

VSIX/CSharp-DAL2-Template/Providers/DataProviders/SqlDataProvider/Uninstall.SqlDataProvider

-IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]') AND type in (N'U'))
-DROP TABLE {databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]
-GO

VSIX/CSharp-DAL2-Template/Providers/DataProviders/SqlDataProvider/Uninstall.sql

+IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]') AND type in (N'U'))
+DROP TABLE {databaseOwner}[{objectQualifier}$safeownername$_$safeprojectname$_Items]
+GO

VSIX/CSharp-Template/BuildScripts/ModulePackage.targets

 <!-- REMEMBER THAT IF YOU MODIFY THE TARGETS FILE YOU NEED TO CLOSE/OPEN THE PROJECT FOR THE CHANGES TO TAKE EFFECT -->
 
 <Project ToolsVersion="3.5" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
-  <Target Name="AfterClean" DependsOnTargets="CleanModule">
-  </Target>
-  <Target Name="AfterBuild" DependsOnTargets="PackageModule">
-  </Target>
+	<Target Name="AfterClean" DependsOnTargets="CleanModule">
+	</Target>
+	<Target Name="AfterBuild" DependsOnTargets="PackageModule">
+	</Target>
 
-  <Target Name="CleanModule">
-    <XmlRead Prefix="n"
-                    Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
-                    XPath="dotnetnuke/packages/package[1]/@version"
-                    XmlFileName="$(DNN_Package_FileName).dnn">
-      <Output TaskParameter="Value" PropertyName="Version" />
-    </XmlRead>
+	<Target Name="CleanModule">
+		<XmlRead Prefix="n"
+						Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
+						XPath="dotnetnuke/packages/package[1]/@version"
+						XmlFileName="$(DNN_Package_FileName).dnn">
+			<Output TaskParameter="Value" PropertyName="Version" />
+		</XmlRead>
 
-    <Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
-    <Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
-  </Target>
-  <Target Name="PackageModule"> <!-- Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">-->
-    <XmlRead Prefix="n"
-                    Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
-                    XPath="dotnetnuke/packages/package[1]/@version"
-                    XmlFileName="$(DNN_Package_FileName).dnn">
-      <Output TaskParameter="Value" PropertyName="Version" />
-    </XmlRead>
+		<Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
+		<Delete Files="$(SolutionDir)..\dnn\build\packages\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
+	</Target>
+	<Target Name="PackageModule">
+		<!-- Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">-->
+		<XmlRead Prefix="n"
+						Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
+						XPath="dotnetnuke/packages/package[1]/@version"
+						XmlFileName="$(DNN_Package_FileName).dnn">
+			<Output TaskParameter="Value" PropertyName="Version" />
+		</XmlRead>
 
-    <!--in VS 2012 we exclude the packages folder -->
-    <ItemGroup>     
-      <InstallInclude Include="**\*.ascx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.asmx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.css" Exclude="packages\**" />
-      <InstallInclude Include="**\*.html" Exclude="packages\**" />
-      <InstallInclude Include="**\*.htm" Exclude="packages\**" />
-      <InstallInclude Include="**\*.resx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.aspx" Exclude="packages\**" />
-      <InstallInclude Include="**\*.js" Exclude="packages\**" />
-      <InstallInclude Include="**\*.txt"  Exclude="**\obj\**;**\_ReSharper*\**;packages\**;" />
-      <InstallInclude Include="**\images\**" Exclude="packages\**" />
-      
-    </ItemGroup>
+		<!--in VS 2012 we exclude the packages folder -->
+		<ItemGroup>
+			<InstallInclude Include="**\*.ascx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.asmx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.css" Exclude="packages\**" />
+			<InstallInclude Include="**\*.html" Exclude="packages\**" />
+			<InstallInclude Include="**\*.htm" Exclude="packages\**" />
+			<InstallInclude Include="**\*.resx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.aspx" Exclude="packages\**" />
+			<InstallInclude Include="**\*.js" Exclude="packages\**" />
+			<InstallInclude Include="**\*.txt"  Exclude="**\obj\**;**\_ReSharper*\**;packages\**;" />
+			<InstallInclude Include="**\images\**" Exclude="packages\**" />
+		</ItemGroup>
 
-    <ItemGroup>
-      <SourceInclude Include="**\*.ascx" />
-      <SourceInclude Include="**\*.asmx" />
-      <SourceInclude Include="**\*.css" />
-      <SourceInclude Include="**\*.xsl" />
-      <SourceInclude Include="**\*.html" />
-      <SourceInclude Include="**\*.htm" />
-      <SourceInclude Include="**\*.resx" />
-      <SourceInclude Include="**\*.xml" Exclude="**\obj\**;**\_ReSharper*\**;" />
-      <SourceInclude Include="**\*.aspx" />
-      <SourceInclude Include="**\*.js" />
-      <SourceInclude Include="**\*.dnn" />
-      <SourceInclude Include="**\*.txt" Exclude="**\obj\**;**\_ReSharper*\**;" />
-      <SourceInclude Include="**\images\**" />
-      <SourceInclude Include="**\packages\**" />
-      <SourceInclude Include="**\*.cs" />
-      <SourceInclude Include="**\*.cs.designer" />
-      <SourceInclude Include="**\*.csproj" />
-      <SourceInclude Include="**\*.targets" />
-      <SourceInclude Include="**\*.sln" />
-    </ItemGroup>
+		<ItemGroup>
+			<SourceInclude Include="**\*.ascx" />
+			<SourceInclude Include="**\*.asmx" />
+			<SourceInclude Include="**\*.css" />
+			<SourceInclude Include="**\*.xsl" />
+			<SourceInclude Include="**\*.html" />
+			<SourceInclude Include="**\*.htm" />
+			<SourceInclude Include="**\*.resx" />
+			<SourceInclude Include="**\*.xml" Exclude="**\obj\**;**\_ReSharper*\**;" />
+			<SourceInclude Include="**\*.aspx" />
+			<SourceInclude Include="**\*.js" />
+			<SourceInclude Include="**\*.dnn" />
+			<SourceInclude Include="**\*.txt" Exclude="**\obj\**;**\_ReSharper*\**;" />
+			<SourceInclude Include="**\images\**" />
+			<SourceInclude Include="**\packages\**" />
+			<SourceInclude Include="**\*.cs" />
+			<SourceInclude Include="**\*.cs.designer" />
+			<SourceInclude Include="**\*.csproj" />
+			<SourceInclude Include="**\*.targets" />
+			<SourceInclude Include="**\*.sln" />
+		</ItemGroup>
 
-    <!-- some helpful file names and listings -->
-    <CreateItem Include="$(DNN_Package_FileName).dnn">
-      <Output TaskParameter="Include" ItemName="PackageManifestFiles" />
-    </CreateItem>
+		<!-- some helpful file names and listings -->
+		<ItemGroup>
+			<PackageManifestFiles Include="$(DNN_Package_FileName).dnn" />
+		</ItemGroup>
 
-    <CreateItem Include="**\License.txt">
-      <Output TaskParameter="Include" ItemName="PackageTxtFiles" />
-    </CreateItem>
+		<ItemGroup>
+			<PackageTxtFiles Include="**\License.txt" />
+			<PackageTxtFiles Include="**\ReleaseNotes.txt" />
+		</ItemGroup>
 
-    <CreateItem Include="**\ReleaseNotes.txt">
-      <Output TaskParameter="Include" ItemName="PackageTxtFiles" />
-    </CreateItem>
+		<ItemGroup>
+			<SqlDataProviderFiles Include="**\*.sqldataprovider" />
+			<SqlDataProviderFiles Include="**\*.sql" />
+		</ItemGroup>
 
 
-    <CreateItem Include="**\*.sqldataprovider">
-      <Output TaskParameter="Include" ItemName="SqlDataProviderFiles" />
-    </CreateItem>
+		<!-- install package -->
+		<Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
+		<Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
+		<Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
+		<Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
 
+		<!-- create the INSTALL RESOURCES.ZIP file -->
+		<Copy SourceFiles="@(InstallInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
 
-    <!-- install package -->
-    <Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
-    <Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
-    <Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
-    <Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
-    
-    <!-- create the INSTALL RESOURCES.ZIP file -->
-    <Copy SourceFiles="@(InstallInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
+		<ItemGroup>
+			<InstallContent Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*" />
+		</ItemGroup>
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*">
-      <Output TaskParameter="Include" ItemName="InstallContent" />
-    </CreateItem>
-    
-    <Zip Files="@(InstallContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
+		<Zip Files="@(InstallContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\Package\**\*.*">
-      <Output TaskParameter="Include" ItemName="OutputInstall" />
-    </CreateItem>
-    <!-- Create the Install package -->    
-    <Zip Files="@(OutputInstall)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
-    <!-- Copy the Install package to the Packages folder -->
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
+		<ItemGroup>
+			<OutputInstall Include="$(MSBuildProjectDirectory)\Package\**\*.*" />
+		</ItemGroup>
+		<!-- Create the Install package -->
+		<Zip Files="@(OutputInstall)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
+		<!-- Copy the Install package to the Packages folder -->
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
 
-    <!-- clean up -->
-    <Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
-    <Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
+		<!-- clean up -->
+		<Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Install.$(DNN_Package_Extension)" />
+		<Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
 
-    
 
-    <!-- sources package -->
-    <Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
-    <Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
-    <Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
-    <Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
 
-    <!-- create the SOURCE RESOURCES.ZIP file -->
-    <Copy SourceFiles="@(SourceInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
+		<!-- sources package -->
+		<Copy SourceFiles="$(TargetDir)$(AssemblyName).dll" DestinationFolder="$(MSBuildProjectDirectory)\Package\bin"/>
+		<Copy SourceFiles="@(SqlDataProviderFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package\%(RecursiveDir)" />
+		<Copy SourceFiles="@(PackageManifestFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
+		<Copy SourceFiles="@(PackageTxtFiles)" DestinationFolder="$(MSBuildProjectDirectory)\Package" />
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*">
-      <Output TaskParameter="Include" ItemName="SourceContent" />
-    </CreateItem>
+		<!-- create the SOURCE RESOURCES.ZIP file -->
+		<Copy SourceFiles="@(SourceInclude)" DestinationFolder="$(MSBuildProjectDirectory)\ResourcesZip\%(RecursiveDir)" />
 
-    <Zip Files="@(SourceContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
+		<ItemGroup>
+			<SourceContent Include="$(MSBuildProjectDirectory)\ResourcesZip\**\*.*" />
+		</ItemGroup>
 
-    <CreateItem Include="$(MSBuildProjectDirectory)\Package\**\*.*">
-      <Output TaskParameter="Include" ItemName="OutputSource" />
-    </CreateItem>
+		<Zip Files="@(SourceContent)" WorkingDirectory="$(MSBuildProjectDirectory)\ResourcesZip" ZipFileName="Resources.$(DNN_Package_Extension)" />
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\Resources.$(DNN_Package_Extension)" DestinationFolder="package/" />
 
-    <!-- Create the Source package -->    
-    <Zip Files="@(OutputSource)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
-    <!-- Copy the Source package to the Packages folder -->
-    <Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
+		<ItemGroup>
+			<OutputSource Include="$(MSBuildProjectDirectory)\Package\**\*.*" />
+		</ItemGroup>
 
-    <!-- cleanup -->
-    <Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
-    <Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
-    <RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
-    
-  </Target>
+		<!-- Create the Source package -->
+		<Zip Files="@(OutputSource)" WorkingDirectory="$(MSBuildProjectDirectory)\Package" ZipFileName="$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
+		<!-- Copy the Source package to the Packages folder -->
+		<Copy SourceFiles="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" DestinationFolder="$(SolutionDir)..\dnn\build\packages\" />
+
+		<!-- cleanup -->
+		<Delete Files="$(MSBuildProjectDirectory)\$(DNN_Package_Name)_$(Version)_$(Configuration)_$(Platform)_Source.$(DNN_Package_Extension)" />
+		<Delete Files="$(MSBuildProjectDirectory)\Resources.Zip" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\Package" />
+		<RemoveDir Directories ="$(MSBuildProjectDirectory)\ResourcesZip" />
+
+	</Target>
 </Project>

VSIX/CSharp-Template/CSharp-Template.csproj

   <ItemGroup>
     <None Include="BuildScripts\ModulePackage.targets" />
     <None Include="DnnTemplate.dnn" />
-    <None Include="Providers\DataProviders\SqlDataProvider\00.00.01.SqlDataProvider" />
-    <None Include="Providers\DataProviders\SqlDataProvider\Uninstall.SqlDataProvider" />
+    <None Include="Documentation\Documentation.css" />
+    <Content Include="Providers\DataProviders\SqlDataProvider\00.00.01.sql" />
+    <Content Include="Providers\DataProviders\SqlDataProvider\Uninstall.sql" />
   </ItemGroup>
   <ItemGroup>
     <None Include="Components\FeatureController.cs" />
     <None Include="DnnTemplate.csproj">
       <SubType>Designer</SubType>
     </None>
-    <None Include="Documentation\Documentation.css" />
     <None Include="Documentation\Documentation.html" />
     <VSTemplate Include="DNN-C-Module.vstemplate">
       <OutputSubPath>DotNetNuke</OutputSubPath>

VSIX/CSharp-Template/DNN-C-Module.vstemplate

 			<Folder Name="Providers" TargetFolderName="Providers">
 				<Folder Name="DataProviders" TargetFolderName="DataProviders">
 					<Folder Name="SqlDataProvider" TargetFolderName="SqlDataProvider">
-						<ProjectItem ReplaceParameters="true" TargetFileName="00.00.01.SqlDataProvider">00.00.01.SqlDataProvider</ProjectItem>
+						<ProjectItem ReplaceParameters="true" TargetFileName="00.00.01.sql">00.00.01.sql</ProjectItem>
 						<ProjectItem ReplaceParameters="true" TargetFileName="SqlDataProvider.cs">SqlDataProvider.cs</ProjectItem>
-						<ProjectItem ReplaceParameters="true" TargetFileName="Uninstall.SqlDataProvider">Uninstall.SqlDataProvider</ProjectItem>
+						<ProjectItem ReplaceParameters="true" TargetFileName="Uninstall.sql">Uninstall.sql</ProjectItem>
 					</Folder>
 				</Folder>
 			</Folder>

VSIX/CSharp-Template/DnnTemplate.csproj

 		<Content Include="App_LocalResources\Settings.ascx.resx" />
 	</ItemGroup>
 	<ItemGroup>
-		<Content Include="Providers\DataProviders\SqlDataProvider\00.00.01.SqlDataProvider" />
-		<Content Include="Providers\DataProviders\SqlDataProvider\Uninstall.SqlDataProvider" />
+		<Content Include="Providers\DataProviders\SqlDataProvider\00.00.01.sql" />
+		<Content Include="Providers\DataProviders\SqlDataProvider\Uninstall.sql" />
 	</ItemGroup>
 	<PropertyGroup>
 		<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
 			<FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">
 				<WebProjectProperties>
 					<UseIIS>True</UseIIS>
+					<UseIISExpress>True</UseIISExpress>
 					<AutoAssignPort>False</AutoAssignPort>
 					<DevelopmentServerPort />
 					<DevelopmentServerVPath />

VSIX/CSharp-Template/DnnTemplate.dnn

 						<basePath>DesktopModules\$safeprojectname$</basePath>
 						<script type="Install">
 							<path>Providers\DataProviders\SqlDataProvider</path>
-							<name>00.00.01.SqlDataProvider</name>
+							<name>00.00.01.sql</name>
 							<version>00.00.01</version>
 						</script>
 						<script type="UnInstall">
 							<path>Providers\DataProviders\SqlDataProvider</path>
-							<name>Uninstall.SqlDataProvider</name>
+							<name>Uninstall.sql</name>
 							<version>00.00.01</version>
 						</script>
 					</scripts>

VSIX/CSharp-Template/Documentation/Documentation.css

 
-Body, A
-{
+body, a {
 	font-family: Verdana, Arial, Helvetica, Sans Serif;
+}
+
+body {
 	font-size: 10pt;
 	font-weight: normal;
 	color: black;
-}
-
-Body
-{
 	background-color: white;
 	margin-left: 25px;
 }
 
-H1
-{
-	font-size: 2.0em;
+
+h1, h2, h3, h4, h5, h6 {
 	font-weight: bold;
 	color: #75808A;
+}
+h1 {
+	font-size: 2.0em;
 	text-decoration: underline;
 }
 
-H2
-{
+h2 {
 	font-size: 1.6em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H3
-{
+h3 {
 	font-size: 1.4em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H4
-{
+h4 {
 	font-size: 1.2em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H5
-{
+h5 {
 	font-size: 1.1em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-H6
-{
+h6 {
 	font-size: 1.0em;
-	font-weight: bold;
-	color: #75808A;
 }
 
-A:link
-{
+a, a:link, a:visited, a:active {
 	font-size: 1.0em;
 	text-decoration: underline;
 	color: #0000cc;
 }
 
-A:visited
-{
-	font-size: 1.0em;
-	text-decoration: underline;
-	color: #0000cc;
-}
-
-A:active
-{
-	font-size: 1.0em;
-	text-decoration: underline;
-	color: #0000cc;
-}
-
-A:hover
-{
-	font-size: 1.0em;
-	text-decoration: underline;
+a:hover {
 	color: #cc0000;
 }
 
-HR
-{
+hr {
 	color: dimgrey;
 	height: 1pt;
 	text-align: left;

VSIX/CSharp-Template/Documentation/Documentation.html

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
 <head>
-	<title>$ownername$ Template</title>
+	<title>$ownername$ $safeprojectname$ DNN Module Documentation</title>
 	<link rel="stylesheet" type="text/css" href="Documentation.css" />
 </head>
 <body>
 			module.
 		</p>
 		<ol>
-			<li><strong style="font-weight: bold; font-style: none">BEFORE</strong> checking the
+			<li><strong>BEFORE</strong> checking the
 				module into your source control environment check the following.</li>
 			<li>Edit the Project properties by double-clicking on the Properties folder in Solution
 				Explorer</li>

VSIX/CSharp-Template/Providers/DataProviders/SqlDataProvider/00.00.01.SqlDataProvider

-/************************************************************/
-/*****              SqlDataProvider                     *****/
-/*****                                                  *****/
-/*****                                                  *****/
-/***** Note: To manually execute this script you must   *****/
-/*****       perform a search and replace operation     *****/
-/*****       for {databaseOwner} and {objectQualifier}  *****/
-/*****                                                  *****/
-/************************************************************/
-
-
-
-/************************************************************/
-/*****              SqlDataProvider                     *****/
-/************************************************************/

VSIX/CSharp-Template/Providers/DataProviders/SqlDataProvider/00.00.01.sql

+/************************************************************/
+/*****              SqlDataProvider                     *****/
+/*****                                                  *****/
+/*****                                                  *****/
+/***** Note: To manually execute this script you must   *****/
+/*****       perform a search and replace operation     *****/
+/*****       for {databaseOwner} and {objectQualifier}  *****/
+/*****                                                  *****/
+/************************************************************/
+
+
+
+/************************************************************/
+/*****              SqlDataProvider                     *****/
+/************************************************************/

VSIX/CSharp-Template/Providers/DataProviders/SqlDataProvider/Uninstall.SqlDataProvider

-/************************************************************/
-/*****              SqlDataProvider                     *****/
-/*****                                                  *****/
-/*****                                                  *****/
-/***** Note: To manually execute this script you must   *****/
-/*****       perform a search and replace operation     *****/
-/*****       for {databaseOwner} and {objectQualifier}  *****/
-/*****                                                  *****/
-/************************************************************/
-
-
-
-/************************************************************/
-/*****              SqlDataProvider                     *****/
-/************************************************************/

VSIX/CSharp-Template/Providers/DataProviders/SqlDataProvider/Uninstall.sql

+/************************************************************/
+/*****              SqlDataProvider                     *****/
+/*****                                                  *****/
+/*****                                                  *****/
+/***** Note: To manually execute this script you must   *****/
+/*****       perform a search and replace operation     *****/
+/*****       for {databaseOwner} and {objectQualifier}  *****/
+/*****                                                  *****/
+/************************************************************/
+
+
+
+/************************************************************/
+/*****              SqlDataProvider                     *****/
+/************************************************************/
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.