YippeeSoft开心软件 » Blog Archiv » 20080215 Enterprise Library Connection property has not been initialized

20080215 Enterprise Library Connection property has not been initialized
http://www.yippeesoft.com

配置：
<configuration>
<configSections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</configSections>
<dataConfiguration defaultDatabase="SQLCONN" />
<connectionStrings>
    <add name="SQLCONN" connectionString="Data Source=PERRY;Initial Catalog=MuOnline;Persist Security Info=True;User ID=sa;Password=xiexiaopeng"
      providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>

一段超级简单的代码
atabase db = DatabaseFactory.CreateDatabase("Connection String");
            string sql = "Select from s";
            DbCommand Sqldbcomm = db.GetSqlStringCommand(sql);
            IDataReader reader = Sqldbcomm.ExecuteReader();

连接字符串已经用
SqlConnection sqlConn = new SqlConnection(strconn);
            sqlConn.Open();

            SqlCommand sqlCmd = new SqlCommand();
            sqlCmd.Connection = sqlConn;
            sqlCmd.CommandText = "Select * from CigLimit";
            SqlDataReader dr= sqlCmd.ExecuteReader();

验证过没有错误

但是出现：
.Test.testsql\’ failed: System.InvalidOperationException : ExecuteReader: Connection 属性尚未初始化。
在 System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.ExecuteReader()

终于找到原因了：
http://blog.alexonasp.net/archive/2006/12/11/enterprise-library-executenonquery-connection-property-has-not-been-initialized.aspx
Nach einigem Suchen fand ich den Fehler: die Enterprise Library bzw. die Database-Klasse liefert eine eigene Methode ExecuteNonQuery mit, die verwendet werden muß:
db.ExecuteNonQuery(command);
Merke: der Sonntag ist nicht zum Arbeiten da

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic44406.aspx
http://www.codeprof.com/dev-archive/28/153-123-285902.shtm
http://blogs.msdn.com/tomholl/archive/2005/09/14/466298.aspx
http://www.msdner.net/asp.net-archived/119/16-23-1197229.shtm
http://p2p.wrox.com/topic.asp?TOPIC_ID=18648
<configSections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data" />
</configSections>
<connectionStrings>
    <add
   name="DataAccessQuickStart"
   providerName="System.Data.OleDb"
   connectionString="Provider=Sybase.ASEOLEDBProvider;Server Name=192.168.8.228,5000;Initial Catalog=jlsail40;User Id=oneuser;Password=123456;Character Set=cp936" />
</connectionStrings>
<dataConfiguration defaultDatabase="DataAccessQuickStart"/>

说明：

Provider=Sybase.ASEOLEDBProvider 为数据库驱动程序

以下是常用数据库的驱动程序列表：

MSSQL： Provider=sqloledb;
Sybase：Provider=Sybase.ASEOLEDBProvider;
Access：Provider=Microsoft.Jet.OLEDB.4.0;
Oracle：Provider=OraOLEDB.Oracle;

使用 Sql Express 2005 的配置文件：

<?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="MyTestConnectionString" />
<connectionStrings>
    <add name="MyTestConnectionString" connectionString="server=(local)\\SQLEXPRESS;database=EntLibQuickStarts;Integrated Security=true;"
      providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>

http://md-111111.blog.163.com/blog/static/2860836200761312246901/

http://blog.joycode.com/ghj/archive/2006/02/09/71248.aspx

分析器错误信息: 创建 dataConfiguration 的配置节处理程序时出错: 未能加载文件或程序集“Microsoft.Practices.EnterpriseLibrary.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”或它的某一个依赖项。找到的程序集清单定义与程序集引用不匹配。 (异常来自 HRESULT:0×80131040)

Enterprise Library 4.0 Plan Published!

Happy New Year to you all! The Enterprise Library team has started the new year with a bang by publishing their v4.0 product backlog onto CodePlex. As announced previously, the big ticket item is a new Dependency Injection Application Block

   1. Enterprise Library for .NET Framework 2.0 – January 2006
   2. Enterprise Library 3.1 – May 2007 （目前最新版）
   3. patterns & practices Enterprise Library – June 2005
   4. Updater Application Block version 2.0
   5. Data Access Application Block for .NET v2（舊版還是有的下載）

http://www.codeplex.com/entlib
Download official releases: May 2007 (3.1), April 2007 (3.0), January 2006 (2.0), June 2005 (1.1)

http://www.cnblogs.com/Terrylee/archive/2006/08/01/Enterprise_Library.html

http://www.ithome.com.tw/plog/index.php?op=ViewArticle&articleId=5413&blogId=620

http://www.cnblogs.com/Terrylee/archive/2006/12/24/Enterprise_Library_3_Visual_Studio_Integrated_Configuration_Editor.html