Skip to main content
.NET Framework 4.6.2+

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.2.dll

#Declaration

public static string GetConnectionString2005CacheRoot(
    string server,
    string userId,
    string password,
    string database
)

#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.

See Also