public void GetTranslationFromSQL() { string[] keywords = langDic.Keys.ToArray(); string keywordString = null; foreach (string keyword in keywords) { keyword.Replace("|", "\\|"); if (keywordString == null) { keywordString = keyword; } else { keywordString = keywordString + "|" + keyword; } } SqlStoredProcedures sqlSP = new SqlStoredProcedures(); string contextString = sqlSP.LangGetTranslation(GetLangID(), "SL_MVC", keywordString); contextString = contextString.Replace("\\|", "\\"); //TODO: Add FULL support for \| escape string[] context = contextString.Split('|'); for (int i = 0; i < keywords.Length; i++) { langDic[keywords[i]] = context[i]; } taskAddKeyword.SetResult(true); }