I have an ASP.NET MVC application.
And you need to make it multi-language, using a database.
I thought of two approaches:
Livro
Titulo
Subtitulo
Idioma
OR
Livro
Titulo
TituloEN
Subtitulo
SubtituloEN
But I do not know the best approach, or if there is a better approach. I think the second one is better, because I force the existence of the two languages. At first the system will have only two languages.
I would like to know if for each column in the database I need to create a new column for the language, and how I work with it in ASP.NET MVC.