I'm replacing my oracle driver from the Microsoft Framework Data Provider for Oracle to the ODP.Net Managed driver but I'm facing some problems related to client globalization support.
I need to set my NLS settings according to a specific culture. With the old driver I could easily achieve that by setting the NLS_LANG key in the registry (HKEY_LOCAL_MACHINE\Software\Oracle).
I know that I can use the OracleConnection.GetSessionInfo and SetSessionInfo methods to change those settings but it requires me to change 16 settings (Calendar, DataFormat, Language, NumericCharacters, Timezone, ...).
Is there any way to change all these settings according to a specific culture (e.g. by providing some culture key) without changing the regional settings of the computer?