public void SaveSettingsData(string SettingsXML) { var query = (from S in DB.dtSettingLookups where S.Code == "APP" select S).FirstOrDefault(); if (query.Code == "APP") { query.Value = SettingsXML; DB.SubmitChanges(); } else { dtSettingLookup APP = new dtSettingLookup { Code = "APP", Value = SettingsXML }; DB.dtSettingLookups.InsertOnSubmit(APP); DB.SubmitChanges(); } }
public string LoadSettingsData() { var query = (from S in DB.dtSettingLookups where S.Code == "APP" select new { Value = S.Value }).FirstOrDefault().Value; if (string.IsNullOrEmpty(query)) { dtSettingLookup APP = new dtSettingLookup { Code = "APP", Value = "<>" }; DB.dtSettingLookups.InsertOnSubmit(APP); DB.SubmitChanges(); return("<>"); } return(query); }