MSSqlConnectionProvider.GetConnectionString2005CacheRoot(String, String, String, String) Method

Returns a connection string used to open a specified Microsoft SQL database using provided login credentials and to enable the SqlDependency feature.

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 GetConnectionString2005CacheRoot(
    string server,
    string userId,
    string password,
    string database
)

VB.NET

Public Shared Function GetConnectionString2005CacheRoot(
    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 name.
userId	String	A string that specifies a user name.
password	String	A string that specifies a user password.
database	String	A string that specifies the database name.

Returns

Type	Description
String	A connection string.

Remarks

Use the GetConnectionString2005CacheRoot method to create a cached data store provider via the corresponding XpoDefault.GetConnectionProvider method call. A cached data store provider will comprise only a Root element (MSSql2005SqlDependencyCacheRoot). You can manually link Node elements (DataCacheNodeLocal and DataCacheNode objects) to it.

If you want to create a cached data store provider comprising a MSSql2005SqlDependencyCacheRoot element and a DataCacheNode element linked to it, use the MSSqlConnectionProvider.GetConnectionString2005WithCache method.