SQLProvider

SqlDataProvider Type

Namespace: FSharp.Data.Sql
Assembly: FSharp.Data.SqlProvider.dll
Base Type: obj
This is a provided type definition

Typed representation of a database

Static parameters

Static parameters	Description
`CaseSensitivityChange: CaseSensitivityChange(optional,default=ORIGINAL)` Full Usage: `CaseSensitivityChange: CaseSensitivityChange(optional,default=ORIGINAL)`	Should we do ToUpper or ToLower when generating table names?
`ConnectionString: string(optional,default="")` Full Usage: `ConnectionString: string(optional,default="")`	The connection string for the SQL database
`ConnectionStringName: string(optional,default="")` Full Usage: `ConnectionStringName: string(optional,default="")`	The connection string name to select from a configuration file
`ContextSchemaPath: string(optional,default="")` Full Usage: `ContextSchemaPath: 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.
`DatabaseVendor: DatabaseProviderTypes(optional,default=MSSQLSERVER)` Full Usage: `DatabaseVendor: DatabaseProviderTypes(optional,default=MSSQLSERVER)`	The target database vendor
`IndividualsAmount: int(optional,default=50)` Full Usage: `IndividualsAmount: int(optional,default=50)`	The amount of sample entities to project into the type system for each SQL entity type. Default 50. Note GDPR/PII regulations if using individuals with ContextSchemaPath.
`OdbcQuote: OdbcQuoteCharacter(optional,default=DEFAULT_QUOTE)` Full Usage: `OdbcQuote: OdbcQuoteCharacter(optional,default=DEFAULT_QUOTE)`	Odbc quote characters: Quote characters for the table and column names: `alias`, [alias]
`Owner: string(optional,default="")` Full Usage: `Owner: 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.
`ResolutionPath: string(optional,default="")` Full Usage: `ResolutionPath: string(optional,default="")`	The location to look for dynamically loaded assemblies containing database vendor specific connections and custom types. Types used in desing-time: If no better clue, prefer .NET Standard 2.0 versions. Semicolon to separate multiple.
`SQLiteLibrary: SQLiteLibrary(optional,default=AutoSelect)` Full Usage: `SQLiteLibrary: SQLiteLibrary(optional,default=AutoSelect)`	Use System.Data.SQLite or Mono.Data.SQLite or select automatically (SQLite only)
`SsdtPath: string(optional,default="")` Full Usage: `SsdtPath: string(optional,default="")`	A path to an SSDT .dacpac file.'
`TableNames: string(optional,default="")` Full Usage: `TableNames: 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)
`UseOptionTypes: NullableColumnType(optional,default=NO_OPTION)` Full Usage: `UseOptionTypes: NullableColumnType(optional,default=NO_OPTION)`	If set, F# option types will be used in place of nullable database columns. If not, you will always receive the default value of the column's type even if it is null in the database.