Support of multilingual entities
Some applications require the ability to maintain data in different languages. In relational databases, a common implementation pattern to achieve this is to use a main table for the corresponding business entity with all persistent properties mapped to table fields, and a language (or localization) table for the language dependent properties of the same business entity. A single instance of a language dependent business entity is therefore represented as a single record in the main table, and multiple records in the language table, depending on the number of supported languages.
It would be great when EF could support this pattern
- by creating the necessary tables and keys on schema creation
- managing inserts/updates and filling the entities with values of the current culture (or the fallback value of the main table) when selecting data