CultureInfo for date parameters

[MatthiasWeiser]

Description

Currently I am developing on German locale VS against a US locale Postgres database.
When querying for date values locally I can see that the dates in queries are translated with German locale which fails against the US postgres server. It would be nice if the locale for formatting dates and potentially other culture sensitive parameters could be set at startup with potentially using CultureInfo.Invariant as default

Repro steps

Use DB server and app machine with different locale.
Perform a query with a date field as parameter.

Expected behavior

Query works.

Actual behavior

Query fails.

Known workarounds

Use same locale on FSharp and DB machine.

Related information

• Postgresql
• Windows 10
• .NET Runtime

[Thorium]

I think that these kind of low-level implementation details how-to-turn .NET date to SQL-database date should be handled by the database driver and not SQLProvider. The database driver should use standard (ISO-8601) date format which is ok for all, but that shouldn't be SQLProvider's business. As well as converting decimals, to decide is "1,000" a thousand or one-point-zero-zero-zero. That is kind of the whole point of SQLProvider to not have to worry about type-mappings details.

Database parameters are strongly typed, SQLProvider should never do ToString() to parameters

[Thorium]

There has been some problems with MySQL DateTime serialization, see if this helps: https://fsprojects.github.io/SQLProvider/core/mysql.html#System-DateTime-Serialization