Sql.Database
Retrieve a list of tables, views, and stored functions from a SQL Server database located on a specified server. The port number can be indicated alongside the server address using a colon or comma. A...
Retrieve a list of tables, views, and stored functions from a SQL Server database located on a specified server. The port number can be indicated alongside the server address using a colon or comma. A set of optional parameters, known as options, can be provided to customize the behavior:
- Query: Input a SQL query to fetch data. If the query yields multiple result sets, only the first one will be returned.
- CreateNavigationProperties: Set to true or false to determine whether navigation properties should be generated in the output (default is true).
- NavigationPropertyNameGenerator: Define a function to assign names to navigation properties.
- MaxDegreeOfParallelism: Specify a numerical value to control the "maxdop" query clause in the generated SQL statement.
- CommandTimeout: Set a time limit for how long the server-side query can run before being terminated. The default duration is ten minutes.
- ConnectionTimeout: Establish a duration to wait before abandoning an attempt to establish a connection wit