Hello,

This is a question regarding moving from VFP to C#. In our VFP application, we have a feature where users can change the language of the interfaces. We implemented it in such a way that we have a "translation" table (a free VFP table) with the English text and the translations of the text into the different languages.

CREATE TABLE Transl (trSeek C(200), trEnglish M, trSpanish M, trDutch M)
INDEX ON trSeek TAG trSeek

*-- In the form's INIT() event we are translating each label and tooltiptext depending on the language setting

THIS.lblEmployeeName.Caption = DoTranslate("Employee name")

*-- And in DoTranslate we pick up the string and get the translation:

PROCEDURE DoTranslate
LPARAMETERS tcString
LOCAL lcLanguage
lcLanguage = "Spanish"
IF SEEK(tcString,"Transl","trSeek")
  lcRetVal = EVALUATE("Transl.tr" + lcLanguage)
ELSE
  lcRetVal = tcString
ENDIF
RETURN lcRetVal

The translation table has about 3000 entries, is very fast and of course we distribute this table together with the VFP application, so that is no big deal in VFP.

As we are moving some of our projects to C# we are wondering what approach we should use in a strict client server application. How is this kind of local data treated best?