Static class system settings in the Entity Framework

Question

I am trying to create settings for a system. I thought of a class similar to the example:

Class:

public static class Configuracoes
{
     [DisplayName("Casas Decimais")]
     [Description("Informa o número de casas decimais que o sistema irá trabalhar")]
     public static int CasasDecimais {get;set;}


     [DisplayName("Opção A")]
     [Description("Determina o Valor da opção A dentro do sistema")]
     public static int OpcaoA {get;set;}

     //...
     public static int OpcaoX {get;set;}

     //...
     public static string OpcaoY {get;set;}

     //...entre outras, apenas exemplo
}

Obviously, there will only be one configuration for the system. So I opted for the static class.

Now, to store this information, I would like to place a table with the following structure:

Table: Configurations

      id        |       nome       |  descricao                                 | valor
"CasasDecimais" | "Casas Decimais" | "Informa o número de casas ... trabalhar"  |  2
...

Objective: (Example)

 //...
 decimal pagamento = x+y;
 Console.WriteLine("O pagamento foi de: "+ pagamento.ToString("C"+Configuracoes.CasasDecimais);

Questions:

1. It is possible to use this structure with the entityframework 6 ? If yes, how ?
2. Is it correct to use static class for this purpose ? Another more appropriate way to implement ?

Note: It is not a constant setting as Carlos suggested, and it is necessary to save it as it may be different for each client.

I have already made this configuration as an object, and each option as a column in the database. This way, the table has only one row. I don’t see a problem with that, I’m just trying to see if it’s possible to do it that way.

Thank you

Answer 1

You can create a configuration class as in the example below using constants:

public static class Configuracoes
{
    public const int CASAS_DECIMAIS = 2;
    public const int PRECISION = 16;

}

And then setting Context, in the case of decimal, setting Hasprecision:

public class MeuContext : DbContext
{
  protected override void OnModelCreating(DbModelBuilder modelBuilder)
  {
    modelBuilder.Properties<decimal>()
            .Configure(x => x.HasPrecision(Configuracoes.PRECISION, 
              Configuracoes.CASAS_DECIMAIS));

  }
}

So it is not necessary to save the information in the database.

Answer 2

I could not find a solution to the proposed problem. I solved by creating a configuration class normally, and declaring a static object in the application. Every configuration I need, I take this object.

There is still the possibility to use singleton in class, but not tested.