EntityConnectionStringBuilder 類別

定義

public ref class EntityConnectionStringBuilder sealed : System::Data::Common::DbConnectionStringBuilder

public sealed class EntityConnectionStringBuilder : System.Data.Common.DbConnectionStringBuilder

type EntityConnectionStringBuilder = class
    inherit DbConnectionStringBuilder

Public NotInheritable Class EntityConnectionStringBuilder
Inherits DbConnectionStringBuilder

繼承

Object

DbConnectionStringBuilder

EntityConnectionStringBuilder

範例

下列範例示範如何搭配 EntityConnectionStringBuilder 使用 SqlConnectionStringBuilder。

// Specify the provider name, server and database.
string providerName = "System.Data.SqlClient";
string serverName = ".";
string databaseName = "AdventureWorks";

// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
    new SqlConnectionStringBuilder();

// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.IntegratedSecurity = true;

// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();

// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder 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://*/AdventureWorksModel.csdl|
                            res://*/AdventureWorksModel.ssdl|
                            res://*/AdventureWorksModel.msl";
Console.WriteLine(entityBuilder.ToString());

using (EntityConnection conn =
    new EntityConnection(entityBuilder.ToString()))
{
    conn.Open();
    Console.WriteLine("Just testing the connection.");
    conn.Close();
}

' Specify the provider name, server and database.
Dim providerName As String = "System.Data.SqlClient"
Dim serverName As String = "."
Dim databaseName As String = "AdventureWorks"

' Initialize the connection string builder for the
' underlying provider.
Dim sqlBuilder As New SqlConnectionStringBuilder

' Set the properties for the data source.
sqlBuilder.DataSource = serverName
sqlBuilder.InitialCatalog = databaseName
sqlBuilder.IntegratedSecurity = True

' Build the SqlConnection connection string.
Dim providerString As String = sqlBuilder.ToString

' Initialize the EntityConnectionStringBuilder.
Dim entityBuilder As New EntityConnectionStringBuilder

'Set the provider name.
entityBuilder.Provider = providerName
' Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = providerString
' Set the Metadata location to the current directory.
entityBuilder.Metadata = "res://*/AdventureWorksModel.csdl|" & _
                            "res://*/AdventureWorksModel.ssdl|" & _
                            "res://*/AdventureWorksModel.msl"

Console.WriteLine(entityBuilder.ToString)

Using conn As EntityConnection = New EntityConnection(entityBuilder.ToString)
    conn.Open()
    Console.WriteLine("Just testing the connection.")
    conn.Close()
End Using

備註

連接字串產生器 (Builder) 可讓開發人員使用類別的屬性和方法，以程式設計方式建立語法正確的連接字串，以及剖析和重新建置現有的連接字串。 連接字串產生器提供強型別 (Strongly Typed) 屬性，這些屬性對應到已知關鍵字/值組。 必須建立連接字串做為應用程式一部分的開發人員可以使用 EntityConnectionStringBuilder 類別來建置及修改連接字串。

EntityConnectionStringBuilder 執行有效關鍵字/值組的檢查，其中每組都會公開 (Expose) 為 EntityConnectionStringBuilder 屬性值。

建構函式

屬性

方法

明確介面實作

擴充方法

適用於

另請參閱

• EntityConnection
• 連接字串
• 使用 EntityClient