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
#Parameters
Name | Type | Description |
---|---|---|
server | String | A string that specifies the SQL server name. |
user |
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.