SqlParameterPrefix

In your config file you have to add SqlParameterPrefix section.
You declare the section like this:
<configSections>
    <section name="SqlParameterPrefix" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</configSections>
 

If the <configSections> already exist you just put the <section ... inside.

Below is an example of two prefixes. The first one for Access and the latter for SQL Server or Firebird.
<SqlParameterPrefix>
    <add key="[The name of your connection string]" value=":" />
    <add key="[The name of your connection string]" value="@" />
</SqlParameterPrefix>

Last edited Jan 13, 2008 at 12:34 AM by dotnetCarpenter, version 2

Comments

No comments yet.