Oracle.Database
This function retrieves a list of SQL tables and views from the Oracle database located on a specified server. The port number can be provided along with the server address, separated by a colon. You...
This function retrieves a list of SQL tables and views from the Oracle database located on a specified server. The port number can be provided along with the server address, separated by a colon.
You can also set various options using an optional parameter called "options".
- "CreateNavigationProperties" is a true/false value that determines whether navigation properties should be generated for the returned data (default is true).
- You can specify a function as "NavigationPropertyNameGenerator" to create custom names for navigation properties.
- If you want to execute a native SQL query to fetch data, you can provide the query using the "Query" option. Note that if the query produces multiple result sets, only the first one will be returned.
- "CommandTimeout" is a duration that specifies how long the server-side query can run before getting canceled, with a default value of ten minutes.
- "ConnectionTimeout" is a duration that controls how long to wait before giving up on establishing a connection to