C# .Net Core - Set global decimal delimiter regardless of culture

Question

So I have a development machine which is a dutch machine and a english server. Now, I have values in the database like 1.99 (string) that I need to convert to a decimal. When I do decimal.Parse("1.99") I get 199.00. This is (probably) because my machine uses Dutch settings and the delimiter for a decimal is a , (comma). Now, how can I set it globaly to always use a .(dot) as the delimiter, regardless of the culture that is beeing requested nor the machines local settings?

I'm using a .Net Core Web Api

Check this documentation: https://learn.microsoft.com/en-us/troubleshoot/aspnet/set-current-culture — Cihan Yakar, Jul 19 '20 at 19:42
Does this answer your question? [Set CultureInfo in Asp.net Core to have a . as CurrencyDecimalSeparator instead of ,](https://stackoverflow.com/questions/40442444/set-cultureinfo-in-asp-net-core-to-have-a-as-currencydecimalseparator-instead) — Pac0, Jul 19 '20 at 19:56

Claudio Redi · Answer 1 · 2020-07-19T19:51:51.393

2

You could use CultureInfo.InvariantCulture that uses . as decimal separator

var number = decimal.Parse("1.99", CultureInfo.InvariantCulture);

If you don't want to set the culture in every parse call, you could create an extension method

public static class StringExtensions
{
    public static decimal ToDecimalInvariant(this string value)
    {
        return decimal.Parse(value, CultureInfo.InvariantCulture);
    }
}

And then use it like this

var number = myString.ToDecimalInvariant();

edited Jul 19 '20 at 19:51

answered Jul 19 '20 at 19:42

Claudio Redi

67,454
15
130
155

I know, but I want to add it globally and not everywhere where I parse a decimal. – NLAnaconda Jul 19 '20 at 19:47
1

You could create an extension method `ParseInvariant(string)` – Claudio Redi Jul 19 '20 at 19:48
Maybe that is the best solution then. I can't get it to work by changing culture settins. Thnx – NLAnaconda Jul 19 '20 at 19:50
you can also set the cutlutre globally. See https://stackoverflow.com/questions/40442444/set-cultureinfo-in-asp-net-core-to-have-a-as-currencydecimalseparator-instead – Pac0 Jul 19 '20 at 19:56

score 0 · Answer 2 · answered Feb 24 '23 at 06:58

I had a similar problem. I have a wpf app, and in the main window viewmodel in the constructor I have this statement:

Thread.CurrentThread.CurrentCulture = new CultureInfo("en-Us");

I know this might have other (perhaps unwanted) effects on dates and other things but it works for my simple use. I would guess that if you need it other threads you would have to do it for each thread that you start up.

C# .Net Core - Set global decimal delimiter regardless of culture

2 Answers2