.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

MSSqlConnectionProvider.GetConnectionString(String, String, String, String) Method

Returns a connection string used to open a specified MS SQL database using provided login credentials.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Xpo.v20.2.dll

Declaration

public static string GetConnectionString(
    string server,
    string userId,
    string password,
    string database
)
Public Shared Function GetConnectionString(
    server As String,
    userId As String,
    password As String,
    database As String
) As String

Parameters

Name Type Description
server String

A string that specifies the SQL server's name.

userId String

A string that specifies a user name.

password String

A string that specifies a password.

database String

A string that specifies the database name.

Returns

Type Description
String

A connection string.

Remarks

You can use this method's return value to initialize a Session's connection string (for instance, via the Session.ConnectionString or XpoDefault.ConnectionString property).

NOTE

The GetConnectionString method's return value contains an extra parameter that identifies the database type to which a connection should be established, so it's not fully compatible with the standard connection string format. When a Session receives this connection string, it removes this extra parameter and then passes the valid connection string to the database.

Examples

The following code demonstrates how to connect to an MS SQL database. The MSSqlConnectionProvider.GetConnectionString method is called to construct a connection string to the database. It is then assigned to the default session via the Session.ConnectionString property.

using DevExpress.Xpo;
using DevExpress.Xpo.DB;

Session.DefaultSession.ConnectionString = MSSqlConnectionProvider.GetConnectionString(
    "SERVER", "sa", "", "Northwind");
See Also