ConnectionStringSettingsCollection 類別
定義
重要
部分資訊涉及發行前產品,在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊,不做任何明確或隱含的瑕疵擔保。
包含 ConnectionStringSettings 物件的集合。
public ref class ConnectionStringSettingsCollection sealed : System::Configuration::ConfigurationElementCollection
[System.Configuration.ConfigurationCollection(typeof(System.Configuration.ConnectionStringSettings))]
public sealed class ConnectionStringSettingsCollection : System.Configuration.ConfigurationElementCollection
[<System.Configuration.ConfigurationCollection(typeof(System.Configuration.ConnectionStringSettings))>]
type ConnectionStringSettingsCollection = class
inherit ConfigurationElementCollection
Public NotInheritable Class ConnectionStringSettingsCollection
Inherits ConfigurationElementCollection
- 繼承
- 屬性
範例
下列範例示範如何存取 ConnectionStringSettingsCollection。
static void ShowConnectionStrings()
{
// Get the application configuration file.
System.Configuration.Configuration config =
ConfigurationManager.OpenExeConfiguration(
ConfigurationUserLevel.None);
// Get the conectionStrings section.
ConnectionStringsSection csSection =
config.ConnectionStrings;
for (int i = 0; i <
ConfigurationManager.ConnectionStrings.Count; i++)
{
ConnectionStringSettings cs =
csSection.ConnectionStrings[i];
Console.WriteLine(" Connection String: \"{0}\"",
cs.ConnectionString);
Console.WriteLine("#{0}", i);
Console.WriteLine(" Name: {0}", cs.Name);
Console.WriteLine(" Provider Name: {0}",
cs.ProviderName);
}
}
Shared Sub ShowConnectionStrings()
' Get the application configuration file.
Dim config _
As System.Configuration.Configuration = _
ConfigurationManager.OpenExeConfiguration( _
ConfigurationUserLevel.None)
' Get the conectionStrings section.
Dim csSection _
As ConnectionStringsSection = _
config.ConnectionStrings
For i As Integer = 0 To ConfigurationManager.ConnectionStrings.Count - 1
Dim cs As ConnectionStringSettings = _
csSection.ConnectionStrings(i)
Console.WriteLine( _
" Connection String: ""{0}""", cs.ConnectionString)
Console.WriteLine("#{0}", i)
Console.WriteLine(" Name: {0}", cs.Name)
Console.WriteLine( _
" Provider Name: {0}", cs.ProviderName)
Next i
End Sub
下列範例是上一個範例所使用的組態檔摘錄。
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="ConnStr1" connectionString="LocalSqlServer: data source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=aspnetdb"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
備註
ConnectionStringSettingsCollection物件包含物件的集合ConnectionStringSettings。 每個 ConnectionStringSettings 物件都代表組態檔區段中的單一專案 <connectionStrings>
。
建構函式
ConnectionStringSettingsCollection() |
初始化 ConnectionStringSettingsCollection 類別的新執行個體。 |
屬性
方法
明確介面實作
ICollection.CopyTo(Array, Int32) |
將 ConfigurationElementCollection 複製至陣列。 (繼承來源 ConfigurationElementCollection) |
擴充方法
Cast<TResult>(IEnumerable) |
將 IEnumerable 的項目轉換成指定的型別。 |
OfType<TResult>(IEnumerable) |
根據指定的型別來篩選 IEnumerable 的項目。 |
AsParallel(IEnumerable) |
啟用查詢的平行化作業。 |
AsQueryable(IEnumerable) |
將 IEnumerable 轉換成 IQueryable。 |
適用於
另請參閱
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應