Using ConfigProcedureName to initialize database connections
Release 1.2 - ...
You can add the optional property ConfigProcedureName to a connection string to call the custom stored procedure defined by the property every time a new database connection is opened. This allows you to initialize connections to your database. Example:
| XML |
Copy Code
|
|---|---|
<connectionstring>
Provider=SQLOLEDB.1;Password=secret;
Persist Security Info=True;
User ID=myuser;
Initial Catalog=mysite;
Data Source=dbserver;
ConfigProcedureName=MyStoredProc;
</connectionstring>
|
|