MSSqlConnectionProvider.GetConnectionString(String, String, String, String) Method
Returns a connection string used to open a specified Microsoft SQL database using provided login credentials.
Namespace: DevExpress.Xpo.DB
Assembly: DevExpress.Xpo.v24.2.dll
NuGet Package: DevExpress.Xpo
#Declaration
#Parameters
Name | Type | Description |
---|---|---|
server | String | A string that specifies the SQL server’s name. |
user |
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 Get
#Example
The following code demonstrates how to connect to an Microsoft 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");