Object: Database
Properties
| Name | Type | Description |
|---|---|---|
| DatabaseId | Integer | Database ID will be the database ID used for making connection. |
| Name | String | Name will be the database name. |
| ConnectionString | Object | Connection string for the selected Database Provider Type. Sym3 will check every possible provider installed on the computer and will populate the “Database Provider Type” combo box accordingly. o have examples of connection string for your provider, please visit this following web site: https://www.connectionstrings.com// |
| DatabaseProviderName | Object | It will be the provider installed on you machine for e.g SqlClient data Provider,Oledb Provider,ODP.NET.Managed Driver etc. The combo box to select the provider is editable and if find the similar provider it will auto complete the text. User can enter free text so he can configure a project with a provider that is not available on this machine. If user enter invalid text like “RDBMS”. The ‘Test Connection’ button will tell him that the provider is not known. Note: For creation of Oracle client you can install the Oracle Database Access Driver from Oracle |
Example
var arr = GetDatabases();
for (var i = 0; i < arr.length; ++i)
{
LogDebug("Database ID " + arr[i].DatabaseId);
LogDebug("Database Name " + arr[i].Name);
LogDebug("Database ConnectionString " + arr[i].ConnectionString);
LogDebug("Database DatabaseProviderName " + arr[i].DatabaseProviderName);
}