MSSqlConnectionProvider.GetConnectionStringWithAttach(String, String, Boolean) Method

Returns a connection string to connect to a Microsoft SQL Server database by attaching a specified .mdf database file to a specific server using Windows Integrated Security.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Xpo.v24.1.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public static string GetConnectionStringWithAttach(
    string server,
    string attachDbFilename,
    bool userInstance
)

VB.NET

Public Shared Function GetConnectionStringWithAttach(
    server As String,
    attachDbFilename As String,
    userInstance As Boolean
) As String

Parameters

Name	Type	Description
server	String	A string that specifies the SQL server name.
attachDbFilename	String	A string specifying a .mdf database file to attach to the server. This value is used to initialize the “AttachDbFilename” field of the connection string.
userInstance	Boolean	true to enable User Instances (required when attaching the attachDbFilename); otherwise, false (when the database specified by the attachDbFilename already exists on the server). For more information about SQL Server Express and User Instances, read the SQL Server 2005 Express Edition User Instances MSDN article.

Returns

Type	Description
String	A connection string.

Remarks

Note

This method is in effect only for SQL Server 2005 Express Edition databases.

The method enables Integrated Security in the resulting connection string. To connect using specific login credentials (user name and password), call the other GetConnectionStringWithAttach overloaded method.