Export (0) Print
Expand All

EntityConnectionStringBuilder Constructor (String)

Initializes a new instance of the EntityConnectionStringBuilder class using the supplied connection string.

Namespace:  System.Data.EntityClient
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

public EntityConnectionStringBuilder(
	string connectionString
)

Parameters

connectionString
Type: System.String

A provider-specific connection string to the underlying data source.

The supplied connectionString is not checked for valid keyword/value pairs. For valid keyword/value syntax, see ConnectionString.

The invariant Provider name must be specified in the connectionString parameter. Supported providers include the following:

  • System.Data.Odbc

  • System.Data.OleDb

  • System.Data.OracleClient

  • System.Data.SqlClient

  • Microsoft.SqlServerCe.Client

The following example demonstrates how to use the EntityConnectionStringBuilder in conjunction with a SqlConnectionStringBuilder. The code sets properties of a SqlConnectionStringBuilder to create a SqlConnection connection string that supplies part of the underlying provider connection string. Note that the Provider name cannot be set using the SqlConnectionStringBuilder because it is not valid SqlConnection connection string syntax. The code creates the EntityConnection connection string by setting EntityConnectionStringBuilder properties. It does not use the connectionString overload.

// 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();
}

Windows 7, Windows Vista, Windows XP SP2, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5 SP1

Community Additions

ADD
Show:
© 2014 Microsoft