public void SetSetting(string settingName, string value)
{
using (var context = GetDataContext())
{
var setting = context.Settings.SingleOrDefault(x => x.Name == settingName);
if (setting == null)
{
setting = new Setting { Name = settingName };
context.Settings.InsertOnSubmit(setting);
}
setting.Value = value;
context.SubmitChanges();
}
}