When specifying OracleDataService as a service data string is used
As for ORACLE, the concept of “dirty reads” and locks are out of date, with DRDataService also indicates the line
Requirements to components
- If the application uses .NET Framework version is below 4.0, then to work with
OracleDataServicerequires Oracle client software. This requirement is due to the fact that in this case, to create connections to Oracle DB using a class
System.Data.OracleClient.OracleConnection. There are restrictions on the naming of directories that is using ORACLE. If to place in the directory name which contains special characters (dots, brackets), then everything might stop working. To remedy this situation, it is sufficient to rename the directory.
- .NET Framework from version 4.0 to install the Oracle client software is not required.
Working with compounds is carried out using
Oracle.ManagedDataAccess.Client.OracleConnection. In this case, you must install nuget package
features of functioning
Like any service data,
OracleDataService supports the mapping of data types into account peculiarities of their use in specific DBMS. And also allows you to consider the following key requirements Oracle, including syntax:
- The identifier length supported by ORACLE is limited to 30 bytes. Moreover, this limitation applies to both the names of database objects (i.e. included in the determination of the names of storage objects generator
Oracle SQL Generatorand data service
OracleDataService), and aliases used in the query (ignored
OracleDataService). In the formation of a short version of the name the ID generated by the baseline method, trimmed to the required length and is complemented with the hash to ensure uniqueness.
- Identifiers are enclosed in double quotes.
- The analogue of the function ifnull is the function NVL.
- A limit on the number of rows in the sample provided by using the key words
<nowiki>TOP</nowiki>in the base
SQLDataServiceis implemented by setting limits on
Registronacional of strings in queries
Search strings in databases Oracle by default is case sensitive, i.e., for example, when the query is executed
SELECT * FROM Table1 WHERE Field1='что-то'
the rows of a table Table1 where Field1 has the value ‘something’,’SOMETHING’,… in the sample output will not fall.
To search case-insensitive, use the parameter CaseInsensitive configuration file.
Cm. article Processing registers object names to DBMS.