| Milos How-To |
| Configuration Options |
| Key | Value | Required | Notes |
| database:UserName | SQL Server user name | Mostly, unless ConnectionString or trusted connection setting is provided. (Data.dll) | Prefix (database) can change depending on the configuration of the data service. |
| database:Password | SQL Server password | Mostly, unless ConnectionString or trusted connection setting is provided. (Data.dll) | Prefix (database) can change depending on the configuration of the data service. |
| database:Server | SQL Server name | Mostly, unless ConnectionString is provided.(Data.dll) | Prefix (database) can change depending on the configuration of the data service. |
| database:TrustedConnection | Yes, True, False, No | Only if no other connection string and no user name is provided. | Prefix (database) can change depending on the configuration of the data service. If this setting is True or Yes, the user name and password settings will be ignored by all data services that support trusted connections (such as the SQL Server data services). |
| database:Catalog | SQL Server database name | Mostly, unless ConnectionString is provided.(Data.dll) | Prefix (database) can change depending on the configuration of the data service. |
| database:ConnectionString | Fully qualified SQL Connection String | No | Prefix (database) can change depending on the configuration of the data service. If this setting is provided, it will override the previous four settings. |
| DataService | DataService class | Yes (Data.dll) | This can be a list of data services, separated by commas. Typically, this setting would be "SqlDataService" or "SqlDataService,WsSqlDataService". |
| database:WebServiceURL | URL of the WsSqlDataService web service | Only if the WsSqlDataService is configured as one of the possible options. | This setting will point to a fully qualified URL. This URL will be used by the WsSqlDataService to retrieve data from Sql Server. In other words, this URL has to be the web service component used by the web service driven Sql data service. |
| database:StoredProcedurePrefix | SP prefix (default: "milos_") | No | This setting defines the prefix used by stored procedures that are created for automatic use. For instance, if the system is configured to use stored procedures, then business objects will use default stored procedures, such as an SP that queries all records from a table such as the customer table. In that case, the SP will be called something like "milos_getCustomerAllRecords". The "milos_" prefix is used to differentiate these SPs from manually created ones. This setting allows the developer to customize the prefix. Note that this setting may not be supported by all data services. |
| AllowedDataMethod | StoredProcedures or IndividualCommands | No | If this setting is present, the system will limit data access to the method specified. For instance, if this is set to "StoredProcedures", then the system will only allow data access through stored procedures. All other calls will cause errors. If this setting is absent, all data access methods will be allowed. |
| database:AppRole | Database App Role | No | Prefix (database) can change depending on the configuration of the data service. |
| database:AppRolePassword | Password for an App Role | Required if AppRole is specified. | Prefix (database) can change depending on the configuration of the data service. |
| database:AutoLoadSchemaInformation | True (default) of False | No | Defines whether schema information is retrieved from the database. This allows Milos to automatically perform checks and fix things like trim data to the maximum lenght of a text fields. Note that this also adds a layer of restraint checking in ADO.NET internally. For instance, identity fields can not be updated on the client of schema information is retrieved. |
| SqlServerParameterType? | Undefined (default) Unicode NotUnicode | No | Defines whether parameters by default are unicode parameters (such as NVarChar) or not (such as VarChar). The default is undefined, which means that the system will not interfere with the parameter types. |
| database:TransactionIsolationLevel | Default, Chaos, ReadCommited, ReadUncommited, RepeatableRead, Serializable, Unspecified | No | Defines the transaction isolation level. This setting is used for all transactions. Note that different objects can use different transaction isolation levels through different database configuraiton prefixes. |
| MinimumCommandTimeout | Command timeout in seconds | No | Sets the minimum command timeout in seconds. All commands fired against the database will set a timeout to at least that. Note that if a specific command uses a higher timeout, then the higher timeout applies. |
| database:StoredProcedureFacade | Assembly/Class | No | This setting can be used to specify a stored procedure facade the dataservice is to use. |
| address:TwoLetterISORegionName | "US", "AT",... | No | Default country that is to be used by address parsers IF that country is to be different from Windows settings. |
| address:ThreeLetterRegionName | "USA", "AUT",... | No | Default country that is to be used by address parsers IF that country is to be different from Windows settings. |