Click here to Skip to main content
15,881,882 members
Articles / Database Development / SQL Server

DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation

Rate me:
Please Sign up or sign in to vote.
5.00/5 (13 votes)
31 Mar 2006CPOL23 min read 75.8K   1.9K   68  
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <!-- This defines the three custom config sections -->
  <configSections>
    <sectionGroup name="referencedAssemblies">
      <section name="assembly" type="DotNetScripting.DotNetScriptAssemblySectionHandler, DotNetScripting" allowLocation="false" />
    </sectionGroup>
    <sectionGroup name="supportedLanguages">
      <section name="language" type="DotNetScripting.DotNetScriptLanguageSectionHandler, DotNetScripting" allowLocation="false" />
    </sectionGroup>
    <section name="userPreferences" type="DotNetScripting.DotNetScriptUserPreferencesSectionHandler, DotNetScripting" allowLocation="false" />
  </configSections>
  <!-- Use this section to add default assemblies that will be referenced by every script -->
  <!-- If the assembly is in the GAC you dont have use the full path name -->
  <referencedAssemblies>
    <assembly path="System.dll" />
    <assembly path="System.Messaging.dll" />
    <assembly path="System.Security.dll" />
  </referencedAssemblies>
  <!-- This section alows you to add new .Net languages to the script engine without modifying the source code -->
  <!-- Note: VB and C# are built into the engine, all other languages need to be defined (or you could modify the engine) -->
  <!-- name: This is the name that you enter in the script file or in the default language section below -->
  <!-- assembly: This is the full path to the assembly file that contains the language specific code provider class -->
  <!-- codeProviderName: This is the full name, including namespace, of the code provider class -->
  <supportedLanguages>
    <language name="JScript" assembly="C:\Windows\Microsoft.NET\Framework\v1.1.4322\Microsoft.JScript.dll" codeProviderName="Microsoft.JScript.JScriptCodeProvider" />
    <language name="VJSharp" assembly="c:\Windows\microsoft.net\framework\v1.1.4322\vjsharpcodeprovider.dll" codeProviderName="Microsoft.VJSharp.VJSharpCodeProvider" />
    <language name="VisualC" assembly="c:\Windows\microsoft.net\framework\v1.1.4322\Microsoft.VisualC.dll" codeProviderName="Microsoft.VisualC" />
  </supportedLanguages>
  <!-- defaultLanguage can only be C#, VB or whatever name you give in the language element -->
  <!-- true keeps the Console window open after script if finished, flase closes automatically-->
  <!-- this is the function that will be called first when the script is run -->
  <userPreferences defaultLanguage="CSharp" entryPoint="Main" waitForUserAction="true" />
  <appSettings>
    <add key="DBType" value="SQL" />
    <add key="ConnectionString" value="Data Source=SERVER;Database=DB;User ID=sa;Password=" />
    <!--
    <add key="ConnectionString" value="Data Source=SERVER;Database=DB;User ID=sa;Password="/>
	<add key="ConnectionString" value="Driver={MySQL ODBC 3.51 Driver};Server=server;Database=mysql;uid=root;pwd=;option=3"/>
    <add key="ConnectionString" value="Provider = Microsoft.Jet.OLEDB.4.0; Data Source = Path\db1.mdb"/>
    -->
  </appSettings>
</configuration>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer Telstra Internet
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions