#1 Assembly naming

[Espen Frimann Koren]

Even though "experts" think it is obvoius; it is not
obvoius how to name the assembly in the provider
section of the config-file as long as you don't copy the
needed assembly to your run directory.

This tag connects to an assembly in the GAC:

            <provider

name="System.Data.SqlClient"

connection="System.Data.SqlClient.SqlConnecti

on"

adapter="System.Data.SqlClient.SqlDataAdapte

r"

command="System.Data.SqlClient.SqlCommand"

parameter="System.Data.SqlClient.SqlParamete

r"

assembly="System.Data, Version=1.0.5000.0,

Culture=neutral, PublicKeyToken=b77a5c561934e089,
Custom=null"

description="MSSQL"
            />

Without the PublicKeyToken, only the file system is
searched. It also works by specifying this section in the
config-file:

<runtime>
    <assemblyBinding
        xmlns="urn:schemas-

microsoft-com:asm.v1">
<qualifyAssembly

partialName="System.Data"

fullName="System.Data, version=1.0.5000.0,

Culture=neutral, PublicKeyToken=b77a5c561934e089,
Custom=null"/>
</assemblyBinding>
</runtime>

Then you can have System.Data only in the assembly-
attribute above.