My application supports two languages (English and French). Database tables for the app contain columns with a suffix of "_e" and "_f" to designate those text fields that are English or French.
The web interface includes many pages where read-only views of the data are displayed. The web interface also includes the ability to switch between English and French at any time so I need a convenient way to populate controls with either the English or French data.
How should I implement this? I don't want to simply create English and French versions of each View as this would cause double the work in creating SQL Views and will result in 2 entity classes. I also don't want to create a single view that would require code that differentiates between English and French fields.
I'd like some sort of parameterized method where I could simply pass the app's current thread's UICulture and magically get the right fields but have no idea how to do this.
Any suggestions?