<? xml version="1.0" encoding="utf-8" ?>
< configuration >
< configSections >
< section name ="dataConfiguration" type ="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
</ configSections >
< dataConfiguration defaultDatabase ="ConnectionString" />
< connectionStrings >
< add name ="ConnectionString" connectionString ="Database=EnterpriseLibrary;Server=shy;Integrated Security=SSPI;uid=sa;pwd=;"
providerName ="System.Data.SqlClient" />
</ connectionStrings >
</ configuration >
1、configSections:包含元素有section。主要 是企业库的版本信息等。
2、dataConfiguration :设置默认数据库。在创建数据库链接时,如果不指定数据库字符则默认创建这个数据库的链接。所以我们大部分配置和下面的connectionStrings字符串一样。(个人意见)
不过在使用中,有时会报错: 未能 找到元素“dataconfiguration”的架构信息。
好像是没有添加企业库dll的错误。应该要添加的引用:
Microsoft.Practices.EnterpriseLibrary.Data.GenericDatabase
Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase
Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase
下面我列出所有不同数据库的连接字符串以及映射关系的一个完整版本,供参考。
<?xml version="1.0"?>
<configuration>
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data"/>
</configSections>
<connectionStrings>
<!--Sqlserver数据库的连接字符串-->
<add name="sqlserver" providerName="System.Data.SqlClient" connectionString="Persist Security Info=False;Data Source=(local);Initial Catalog=WinFramework;Integrated Security=SSPI"/>
<!--PostgreSQL数据库的连接字符串-->
<add name="npgsql" providerName="Npgsql" connectionString="Server=localhost;Port=5432;Database=postgres;User Id=postgres;Password=123456"/>
<!--MySQL数据库的连接字符串-->
<add name="mysql" providerName="MySql.Data.MySqlClient" connectionString="Server=localhost;Database=WinFramework;Uid=root;Pwd=root;"/>
<!--路径符号|DataDirectory|代表当前运行目录-->
<add name="access" providerName="System.Data.OleDb" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\WinFramework.mdb;User ID=Admin;Jet OLEDB:Database Password=;" />
<!--sqlite数据库字符串,路径符号|DataDirectory|代表当前运行目录-->
<add name="sqlite" providerName="System.Data.SQLite" connectionString="Data Source=|DataDirectory|\WinFramework.db;Version=3;" />
<!--Oracle数据库的连接字符串-->
<add name="oracle" providerName="System.Data.OracleClient" connectionString="Data Source=orcl;User ID=win;Password=win"/>
<!--达梦数据库的连接字符串-->
<add name="Dm" providerName="Dm" connectionString="Server=localhost;User ID=SYSDBA;PWD=SYSDBA;Database=WINFRAMEWORK;" />
<!--IBM DB2数据库的连接字符串-->
<add name="db2" providerName="IBM.Data.DB2" connectionString="database=whc;uid=whc;pwd=123456"/>
<!--采用OdpNet方式的Oracle数据库的连接字符串-->
<add name="oracle2" providerName="Oracle.DataAccess.Client" connectionString="Data Source=orcl;User id=win;Password=win;" />
</connectionStrings>
<dataConfiguration defaultDatabase="sqlserver">
<providerMappings>
<add databaseType="EntLibContrib.Data.PostgreSql.NpgsqlDatabase, EntLibContrib.Data.PostgreSql" name="Npgsql" />
<add databaseType="EntLibContrib.Data.MySql.MySqlDatabase, EntLibContrib.Data.MySql" name="MySql.Data.MySqlClient" />
<add databaseType="EntLibContrib.Data.SQLite.SQLiteDatabase, EntLibContrib.Data.SqLite" name="System.Data.SQLite" />
<add databaseType="EntLibContrib.Data.Dm.DmDatabase, EntLibContrib.Data.Dm" name="Dm" />
<add databaseType="EntLibContrib.Data.DB2.DB2Database, EntLibContrib.Data.DB2" name="IBM.Data.DB2" />
<add databaseType="EntLibContrib.Data.OdpNet.OracleDatabase, EntLibContrib.Data.OdpNet" name="Oracle.DataAccess.Client" />
</providerMappings>
</dataConfiguration>
<appSettings>
<!--组件的数据库类型:access、sqlserver、sqlite、oracle等,默认为sqlserver可不写-->
<add key="ComponentDbType" value="sqlserver"/>
</appSettings>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>