Utilities (SQLProvider)

Utilities Module

Namespace: FSharp.Data.Sql.Common
Assembly: FSharp.Data.SqlProvider.Common.dll

Functions and values

Function or value	Description
`fieldConstant value` Full Usage: `fieldConstant value` Parameters: value : `obj` Returns: `string`	Renders an inline SQL value literal (used where a provider - chiefly ODBC - can't bind a parameter). String/Guid/DateTime literals are ALWAYS single-quoted (the delimiter is fixed here, it is NOT OdbcQuoteCharacter - that setting only controls identifier quoting: ` ` / [ ] / " " / 'x'). Because the delimiter is a single quote, the escape must be the matching single quote doubled ('') - and ONLY the single quote is doubled; every other character (including ") passes through verbatim. So `O'Brien` -> 'O''Brien' and `say "hi"` -> 'say "hi"'. The '' escape is SQL-standard and universal across backends. (If the literal delimiter were ever made configurable, the escaped char would have to track it.) value : `obj` Returns: `string`
`genericAliasNotation aliasSprint _arg1` Full Usage: `genericAliasNotation aliasSprint _arg1` Parameters: aliasSprint : `string -> 'a` _arg1 : `SqlColumnType` Returns: `'a`	aliasSprint : `string -> 'a` _arg1 : `SqlColumnType` Returns: `'a`
`genericFieldNotation recursionBase colSprint _arg1` Full Usage: `genericFieldNotation recursionBase colSprint _arg1` Parameters: recursionBase : `SqlColumnType -> string` colSprint : `string -> string` _arg1 : `SqlColumnType` Returns: `string`	Standard SQL. Provider spesific overloads can be done before this. recursionBase : `SqlColumnType -> string` colSprint : `string -> string` _arg1 : `SqlColumnType` Returns: `string`
`getBaseColumnName x` Full Usage: `getBaseColumnName x` Parameters: x : `SqlColumnType` Returns: `string`	x : `SqlColumnType` Returns: `string`
`getType typename` Full Usage: `getType typename` Parameters: typename : `string` Returns: `Type`	typename : `string` Returns: `Type`
`parseAggregates fieldNotat fieldNotationAlias query` Full Usage: `parseAggregates fieldNotat fieldNotationAlias query` Parameters: fieldNotat : `'a -> SqlColumnType -> string` fieldNotationAlias : `'a * SqlColumnType -> string` query : `('a * SqlColumnType) list` Returns: `string list`	fieldNotat : `'a -> SqlColumnType -> string` fieldNotationAlias : `'a * SqlColumnType -> string` query : `('a * SqlColumnType) list` Returns: `string list`
`quoteWhiteSpace str` Full Usage: `quoteWhiteSpace str` Parameters: str : `String` Returns: `string` Modifiers: inline	str : `String` Returns: `string`
`uniqueName ()` Full Usage: `uniqueName ()` Parameters: () : `unit` Returns: `string -> string`	() : `unit` Returns: `string -> string`