Csharp/C#教程:如何启用MultipleActiveResultSets分享


如何启用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

(0)
上一篇 2021年11月22日
下一篇 2021年11月22日

精彩推荐