ADO.NET Entity Framework 异常：Unable to load the specified metadata resource

最新推荐文章于 2019-07-07 16:12:31 发布

csid_502

最新推荐文章于 2019-07-07 16:12:31 发布

阅读量190

点赞数

原文链接：http://www.cnblogs.com/liaofeifan/archive/2009/09/26/1574623.html

版权

在使用ADO.NET Entity Framework构建Application时出现如下异常。Solution 中有2个项目，一个为Windows Form项目，另一个为Class Library 项目，包含ADO.NET Entity Data Model。Windows Form 项目增加对Class Library 项目的引用。

异常信息：

System.Data.MetadataException was unhandled

Message="Unable to load the specified metadata resource."

Source="System.Data.Entity"

StackTrace:

at System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources(String assemblyName, String resourceName, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.CreateResourceLoader(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Metadata.Edm.MetadataArtifactLoader.Create(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.EntityClient.EntityConnection.SplitPaths(String paths)

at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)

at System.Data.EntityClient.EntityConnection.InitializeMetadata(DbConnection newConnection, DbConnection originalConnection, Boolean closeOriginalConnectionOnFailure)

at System.Data.EntityClient.EntityConnection.Open()

在Windows Form 项目中出现异常的代码：

string customerID = txtCustomerID.Text.Trim();

// Contains a reference to an Entity Data Model (EDM) and a data source connection.

using (EntityConnection cn = new EntityConnection("Name=NorthwindEntities"))

{

cn.Open();

EntityCommand cmd = cn.CreateCommand();

cmd.CommandText =

"SELECT VALUE c FROM NorthwindEntities.Customers "+

"AS c WHERE c.CustomerID = @customerID";

cmd.Parameters.AddWithValue("customerID", customerID);

DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);

while (rdr.Read())

Console.WriteLine(rdr["CompanyName"].ToString());

rdr.Close();

}

上述代码行 cn.Open(); 抛出异常Exception - Unable to load the specified metadata resource。经检查，问题出现在App.config 配置文件（该配置文件在使用ADO.NET Entity Data Model向导时自动添加），

ADO.NET Entity Data Model向导自动添加的Connection String：

< configuration >

< connectionStrings >

< add name = "NorthwindEntities" connectionString="metadata=res://*/NorthwindDB.csdl|res://*/NorthwindDB.ssdl|res://*/NorthwindDB.msl; provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True;MultipleActiveResultSets=True""providerName="System.Data.EntityClient" />

</ connectionStrings >

</ configuration >

需要将上面connectionStrings 配置节中的* 修改为Class Library 项目的Assembly Name。修改后的示例App.config 如下：

< configuration >

< connectionStrings >

< add name = "NorthwindEntities" connectionString=" metadata= res://NorthwindEDM/NorthwindModel.csdl|res://NorthwindEDM/NorthwindModel.ssdl|res://NorthwindEDM/NorthwindModel.msl; provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True;MultipleActiveResultSets=True""providerName="System.Data.EntityClient" />

</ connectionStrings >

</ configuration

The problem sometimes occurs with the Entity Framework where it gives an array of errors when doing simple operations. For example, I received an error about not being able to “unable to load the specified metadata resource”. Uh, the connection string information is right in the config file! The problem often can be resolved simply by: