Non standard parameter conversions

There are also built-in parameter conversions:

• listParamBuilder modifies sql statement by replacing one parameter with many parameters representing elements of the list. E.g. the query above with the same parameter would be transformed to

  select * from post where id in (@postIds1, @postIds2, @postIds3)

  To use this this feature, the configuration must be modified as follows:

let generatorConfig = 
    createDefaultConfig createConnection
    |> useCollectionParameters

• listDirectParamBuilder modifies sql statement by replacing parameter with list of comma-separated values. E.g.

  select * from post where id in (@postIds)

  executed with [1, 2, 3] as a parameter, is transformed to

  select * from post where id in (1, 2, 3)

  Queries with literals in an in clause are very efficient, but they shouldn't be used with collections of strings.

  To leverage it, the configuration must be modified with intCollectionsAsLiterals function:

let generatorConfig = 
    createDefaultConfig createConnection
    |> intCollectionsAsLiterals

• tableValueParamBuilder allows to use MS SQL table valued parameters To use it, either MsSql version of createDefaultConfig must be used, or standard configuration modified as follows:

let generatorConfig = 
    createDefaultConfig createConnection
    |> useTableValuedParameters

• arrayParamBuilder for PostgreSQ: and Oracle, allows to use array parameters The feature is available when Oracle or PostgreSQL specific createDefaultConfig must be used, or standard configuration modified as follows:

let generatorConfig = 
    createDefaultConfig createConnection
    |> useArrayParameters

In general, to leverage non-standard conversion, the configuration of code generator must be changed by chaining suitable parameter builders.

Let assume, that we'd like to use both param builders, listDirectParamBuilder for int parameters, listParamBuilder for all other basic types:

let generatorConfig = 
    let defaultConfig = createDefaultConfig createConnection
    { defaultConfig with
        paramBuilder = 
            (listDirectParamBuilder ((=) typeof<int>) string) <+> 
            (listParamBuilder isSimpleType "@") <+> 
            defaultConfig.paramBuilder
    }