我尝试使用 ASP.NET MVC 2 项目运行 ELMAH，但在让它与我的 SQL 一起使用时遇到一些问题Server 2008 R2 数据库。
这就是我所做的。
访问 admin/elmah/ 页面时，出现以下异常：
不支持关键字：“元数据”。描述：未处理的异常
发生在当前 Web 请求执行期间。请
查看堆栈跟踪以获取有关错误及其位置的更多信息
它起源于代码。
异常详细信息：System.ArgumentException：不支持关键字：
“元数据”。
来源错误：
执行过程中产生了未处理的异常
当前的网络请求。有关原产地和地点的信息
可以使用下面的异常堆栈跟踪来识别异常。
堆栈跟踪：
[ArgumentException：不支持关键字：“元数据”。]
System.Data.Common.DbConnectionOptions.ParseInternal（哈希表
可解析、字符串连接字符串、布尔构建链、哈希表
同义词，布尔值firstKey）+5110868
System.Data.Common.DbConnectionOptions..ctor（字符串连接字符串，
哈希表同义词、布尔值使用OdbcRules）+98
System.Data.SqlClient.SqlConnectionString..ctor(字符串
连接字符串）+64
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions（字符串
连接字符串、DbConnectionOptions 之前）+24
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup（字符串
连接字符串，DbConnectionPoolGroupOptions poolOptions，
DbConnectionOptions&用户连接选项）+150
System.Data.SqlClient.SqlConnection.ConnectionString_Set（字符串值）
+59
我做错了什么？
I try to run ELMAH with my ASP.NET MVC 2 project but have some problem to get it to work with my SQL Server 2008 R2 database.
This is what I have done.
-
Run the dbscript in my database, accidentally I ran it twice but it seems to not matter in this case.
-
Add the following section to my web.config (under configSection):
<elmah>
<errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="MyEntities" />
</elmah>
-
This is how my Entity Framework connection string looks like :
<add name="MyEntities"
connectionString="metadata=res://*/Models.Model.MyEntities.csdl|res://*/Models.Model.MyEntities.ssdl|res://*/Models.Model.MyEntities.msl;provider=System.Data.SqlClient;provider connection string="Data Source=000.000.000.000;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=[username];Password=[password];MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
When visiting the admin/elmah/ page I get the following exception :
Keyword not supported: 'metadata'. Description: An unhandled exception
occurred during the execution of the current web request. Please
review the stack trace for more information about the error and where
it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported:
'metadata'.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[ArgumentException: Keyword not supported: 'metadata'.]
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable
parsetable, String connectionString, Boolean buildChain, Hashtable
synonyms, Boolean firstKey) +5110868
System.Data.Common.DbConnectionOptions..ctor(String connectionString,
Hashtable synonyms, Boolean useOdbcRules) +98
System.Data.SqlClient.SqlConnectionString..ctor(String
connectionString) +64
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String
connectionString, DbConnectionOptions previous) +24
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions) +150
System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
+59
What am I doing wrong?
发布评论
评论（1）
实体框架连接字符串与 sqlclient 连接字符串不同，并且它们不兼容。您必须使用 sqlclient 连接字符串才能使用 elmah。
查看此站点以获取有效的连接字符串：http://connectionstrings.com/sql-server-2008
Entity framework connection string is different from sqlclient connection string and they are not compatible. You have to use sqlclient connection string to work with elmah.
Look at this site for valid connection strings: http://connectionstrings.com/sql-server-2008