public SQLDatabaseSettingsProvider(SettingsSection settings) : base(settings) { this.dbs = settings.ConnectionString; this.conn = new SqlConnection(dbs); xmlHelper = new SqlXmlHelper(conn); }
/// <summary>Reads object data from an XML file.</summary> /// <param name="file">XML file name.</param> /// <returns>T instance initialized from XML data in the file supplied.</returns> public static T ReadFile <T>(string file) { string xml = string.Empty; try { SqlXmlHelper serializer = new SqlXmlHelper(); using (StreamReader reader = new StreamReader(file)) { xml = reader.ReadToEnd(); } return(serializer.Deserialize <T>(xml)); } catch { } return(default(T)); }
/// <summary>Writes object data to an XML file.</summary> /// <param name="file">XML file name.</param> /// <param name="config">Object to serialize.</param> /// <returns>Boolean success.</returns> public static bool WriteFile <T>(string file, T obj) { bool ok = false; SqlXmlHelper serializer = new SqlXmlHelper(); try { string xml = serializer.Serialize(obj).OuterXml; using (StreamWriter writer = new StreamWriter(file, false)) { writer.Write(xml.Trim()); writer.Flush(); } ok = true; } catch { } return(ok); }