SQLProvider


SqlDataProvider

Namespace: FSharp.Data.Sql

Typed representation of a database

Static parameters

Static parametersDescription
DatabaseVendor
Signature: DatabaseProviderTypes (optional, default = MSSQLSERVER)

The target database vendor

ConnectionString
Signature: string (optional, default = "")

The connection string for the SQL database

ConnectionStringName
Signature: string (optional, default = "")

The connection string name to select from a configuration file

ResolutionPath
Signature: string (optional, default = "")

The location to look for dynamically loaded assemblies containing database vendor specific connections and custom types.

IndividualsAmount
Signature: int (optional, default = 1000)

The amount of sample entities to project into the type system for each SQL entity type. Default 1000.

UseOptionTypes
Signature: bool (optional, default = false)

If true, F# option types will be used in place of nullable database columns. If false, you will always receive the default value of the column's type even if it is null in the database.

Owner
Signature: string (optional, default = "")

Oracle: The owner of the schema for this provider to resolve. PostgreSQL: A list of schemas to resolve, separated by spaces, newlines, commas, or semicolons.

CaseSensitivityChange
Signature: CaseSensitivityChange (optional, default = ORIGINAL)

Should we do ToUpper or ToLower when generating table names?

TableNames
Signature: string (optional, default = "")

Comma separated table names list to limit a number of tables in big instances. The names can have '%' sign to handle it as in the 'LIKE' query (Oracle and MSSQL Only)

ContextSchemaPath
Signature: string (optional, default = "")

The location of the context schema previously saved with SaveContextSchema. When not empty, will be used to populate the database schema instead of retrieving it from then database.

OdbcQuote
Signature: OdbcQuoteCharacter (optional, default = DEFAULT_QUOTE)

Odbc quote characters: Quote characters for the table and column names: alias, alias

SQLiteLibrary
Signature: SQLiteLibrary (optional, default = AutoSelect)

Use System.Data.SQLite or Mono.Data.SQLite or select automatically (SQLite only)

SsdtPath
Signature: string (optional, default = "")

A path to an SSDT .dacpac file.'

Fork me on GitHub