This project is read-only.
Database access is defined in the config file by adding a new section:

<section name="Northwind" type="System.Configuration.NameValueFileSectionHandler, System,Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<add key="dataAdapterType" value="System.Data.SqlClient.SqlDataAdapter"/>
<add key="providerType" value="System.Data.SqlClient.SqlConnection"/>
<add key="assemblyName" value="System.Data,Version=,PublicKeyToken=b77a5c561934e089,Culture=neutral,FileVersion=2.0.50727.42"/>
<add key="connectionString" value='Data Source=.;Initial Catalog=NORTHWIND;Integrated Security=True' />
<add key="dbBrackets" value="[]"/>

The following keys are mandatory:
  • dataAdapterType : the adapter for the connection
  • providerType : the data provider (connection)
  • assemblyName: which assembly contains the adapter and provider
  • connectionString: connection string

The following keys are optional:
  • dbBrackets: when defined, it uses the first and second characters around identifiers such as table and column names.
  • dbOwner: when defined, it explicitly writes the database owner for each table

Last edited Mar 2, 2009 at 1:49 AM by dbroker, version 1


No comments yet.