用enterprise library 3.1访问数据库,好像又叫Enterprise Library May 2007.msi。config文件:
<connectionStrings>
<add name="dbConnection" providerName="System.Data.OleDb" connectionString="Provider=sqloledb;Data Source=192.168.88.1;Initial Catalog=MyDb;User Id=myuser;Password=123456;" />
</connectionStrings> <dataConfiguration defaultDatabase="dbConnection"/>
....
访问代码:
Database db = DatabaseFactory.CreateDatabase("dbConnection");如何对密码部分做个加密?不要对config文件整体加密的方案。
<connectionStrings>
<add name="dbConnection" providerName="System.Data.OleDb" connectionString="Provider=sqloledb;Data Source=192.168.88.1;Initial Catalog=MyDb;User Id=myuser;Password=123456;" />
</connectionStrings> <dataConfiguration defaultDatabase="dbConnection"/>
....
访问代码:
Database db = DatabaseFactory.CreateDatabase("dbConnection");如何对密码部分做个加密?不要对config文件整体加密的方案。
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</configSections>
<dataConfiguration configProtectionProvider="DataProtectionConfigurationProvider">
<EncryptedData>
<CipherData>
<CipherValue>xxxx(一堆乱码)</CipherValue>
</CipherData>
</EncryptedData>
</dataConfiguration>
<connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">
<EncryptedData>
<CipherData>
<CipherValue>yyyy(一堆乱码)</CipherValue>
</CipherData>
</EncryptedData>
</connectionStrings>
</configuration>我用的是Enterprise Library 4.1,不知是否对你有帮助
我没有3.1的版本,你按我的操作,看能否成功:
1、开始->所有程序->Microsoft patterns&practices->Enterprise 4.1 October 2008【注:你这里可能是3.1之类的名字】
2、选择Enterprise Library Configuration
3、File->New Application
4、在Application Configuration上点右键,选择New->Data Access Application Block
5、点击“Data Access Application Block”,在右边的属性设置最下面有个ProtectionProvider的设置,你可以根据自己的需要进行设置
太长了,贴不过来,自己看吧。