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

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5 SP1

.NET Framework Client Profile

Supported in: 4

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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

Show:
© 2014 Microsoft