private void Update(ViewPrompt prompt)
        {
            var sql =
                @"UPDATE LocalizedViews SET Value = @value, UpdatedAt = @updat, UpdatedBy = @updby WHERE [email protected] AND [Key][email protected]";

            using (var cmd = _db.Connection.CreateCommand())
            {
                cmd.AddParameter("lcid", prompt.LocaleId);
                cmd.AddParameter("key", prompt.Key.ToString());
                cmd.AddParameter("value", prompt.TranslatedText);
                cmd.AddParameter("updat", DateTime.Now);
                cmd.AddParameter("updby", Thread.CurrentPrincipal.Identity.Name);
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
        }
        private void Create(ViewPrompt prompt)
        {
            var sql =
                @"INSERT INTO LocalizedViews (LocaleId, ViewPath, TextName, [Key], Value, UpdatedAt, UpdatedBy)
                      VALUES (@lcid, @ViewPath, @textName, @key, @value, @updat, @updby)";

            using (var cmd = _db.Connection.CreateCommand())
            {
                cmd.AddParameter("lcid", prompt.LocaleId);
                cmd.AddParameter("ViewPath", prompt.ViewPath);
                cmd.AddParameter("textname", prompt.TextName);
                cmd.AddParameter("key", prompt.Key.ToString());
                cmd.AddParameter("value", prompt.TranslatedText);
                cmd.AddParameter("updat", DateTime.Now);
                cmd.AddParameter("updby", Thread.CurrentPrincipal.Identity.Name);
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
        }
        /// <summary>
        /// Create a new prompt in the specified language
        /// </summary>
        /// <param name="culture">Language that the translation is for</param>
        /// <param name="viewPath">Path to view. You can use <see cref="ViewPromptKey.GetViewPath"/></param>
        /// <param name="textName">Text to translate</param>
        /// <param name="translatedText">Translated text</param>
        public void CreatePrompt(CultureInfo culture, string viewPath, string textName, string translatedText)
        {
            if (culture == null) throw new ArgumentNullException("culture");
            if (viewPath == null) throw new ArgumentNullException("viewPath");
            if (textName == null) throw new ArgumentNullException("textName");
            if (translatedText == null) throw new ArgumentNullException("translatedText");

            var prompt = new ViewPrompt
                             {
                                 Key = new ViewPromptKey(viewPath, textName),
                                 LocaleId = culture.LCID,
                                 TextName = textName,
                                 TranslatedText = translatedText,
                                 ViewPath = viewPath
                             };
            Create(prompt);
        }