Insert a floating-point value with a culture where a comma (,) is used for "floating point",

Question

I have something like this:

foo { a = 1, b = 2, c = 98,3 }

I generate the insert request dynamically, so in the end:

insert foos(a,b,c) (1, 2, 98,3)

Does anyone know how to do this?

Answer 1

The simple answer is: do not use text to insert values ​​first. Use a parameterized SQL query.

- . , " " - . SQL - , , SQL . , SQL- .

, "" ( ) "SQL-", .

SQL, , , - .

Answer 2

SQL .ToString(CultureInfo.InvariantCulture), , TSQL.

, , , .

Answer 3

Can't you just assign a value to something with. ??

Edit: using parameterized queries would be better. And a simple “replacement” will also help.