如何启用MultipleActiveResultSets
我的代码中有以下连接字符串:
SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["RaiseFantasyLeagueConnectionString"].ConnectionString);
我的webconfig看起来像这样:
有人可以告诉我在哪里可以为我的连接启用MultipleActiveResultSets吗?
它非常简单,只需添加即可
MultipleActiveResultSets=true;
所以在web.config中以这种方式更改连接字符串:
connectionString="Data Source=MATT-PCSQLEXPRESS;" + "Initial Catalog=Raise;Integrated Security=True;" + "MultipleActiveResultSets=true;"
试试这个代码
必须参考这篇Msdn文章
public static class ConfigurationService { static public string ConnectionString { get { try { // Specify the provider name, server and database. string providerName = "System.Data.SqlClient"; string serverName = @"192.168.1.106SQLEXPRESS"; string databaseName = "MyDatabaseName"; // Initialize the connection string builder for the // underlying provider. var sqlBuilder = new SqlConnectionStringBuilder(); // Set the properties for the data source. sqlBuilder.DataSource = serverName; sqlBuilder.InitialCatalog = databaseName; sqlBuilder.IntegratedSecurity = false; sqlBuilder.UserID = "Bob"; sqlBuilder.Password = "Bob1234"; sqlBuilder.MultipleActiveResultSets = true; sqlBuilder.ApplicationName = "EntityFramework"; // Build the SqlConnection connection string. string providerString = sqlBuilder.ToString(); // Initialize the EntityConnectionStringBuilder. var entityBuilder = new EntityConnectionStringBuilder(); //Set the provider name. entityBuilder.Provider = providerName; // Set the provider-specific connection string. entityBuilder.ProviderConnectionString = providerString; // Set the Metadata location. entityBuilder.Metadata = @"res://*/Models.MyDatabaseNameModel.csdl|res://*/Models.MyDatabaseNameModel.ssdl|res://*/Models.MyDatabaseNameModel.msl"; var result = entityBuilder.ToString(); return result; } catch (Exception) { } return string.Empty; } } }
请注意, Models.MyDatabaseNameModel中的模型是VS项目的文件夹名称。
上述就是C#学习教程:如何启用MultipleActiveResultSets分享的全部内容,如果对大家有所用处且需要了解更多关于C#学习教程,希望大家多多关注—计算机技术网(www.ctvol.com)!
本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。
ctvol管理联系方式QQ:251552304
本文章地址:https://www.ctvol.com/cdevelopment/958505.html