2
I have an ASP.NET MVC application.
And I 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 what is the best approach, or if there is a better one. I believe that the second one is better, because I force the existence of both languages. At first the system will have only two languages.
I wonder 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.
If you do not need to use the bank, this question may help you: http://answall.com/questions/17594/internationaliza%C3%A7%C3%A3o-com-c-mvc
– Filipe Oliveira
Thank you @Filipeoliveira, but I would also need how to work with the bank.
– Diego Zanardo
It’s not an answer but, in a project I’m developing, with content in several languages, I created a table containing the identification of the content
ContentId
and for each language a record a daughter table withContentId LangId
– Caputo
@Caputo, I made a change to the question, with the two ways I thought to do.
– Diego Zanardo
I chose to do it the first way because I want to support n languages, but with a record defining the Book so that all variations of languages point to the same Book. Imagine that you decide to support books in Spanish. You would have to duplicate the columns again and then in Italian. The idea of a solution should be considered in the maintenance and growth of the implemented solution.
– Caputo