D>>$"update settings set value={Safe(val)} where name='{name}';if @@ROWCOUNT=0 insert into settings (name,value) values ({Safe(name)},{Safe(val)})"
D>>

D>using(var context = new CoinDogsContext(AppSettingsReader.GetConnectionString()))
D>using(var tran = context.Database.BeginTransaction(IsolationLevel.Serializable))
D>{
D>    var settings = context.Settings.FirstOrDefault(x => x.Name == name);
D>    if (settings == null)
D>    {
D>        settings = new Setting { Name = name };
D>        context.Settings.Add(settings);
D>    }

D>    settings.Value = val;
D>    context.SaveChanges();

D>    tran.Commit();
D>}
D>