/// <summary> /// get DataProtectionKey by FriendlyName /// </summary> /// <param name="friendlyName">Friendly Name</param> /// <returns></returns> public DataProtectionKey GetElement(string friendlyName) { using (var con = new Npgsql.NpgsqlConnection(_connectionString)) { var sql = @"select ""FriendlyName"",""XmlData"" from public.""DataProtectionKeys"" where ""FriendlyName""=@FriendlyName;"; using (var cmd = new Npgsql.NpgsqlCommand(sql, con)) { DataProtectionKey dataProtectionKey = null; cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@FriendlyName", friendlyName)); con.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { dataProtectionKey = new DataProtectionKey(); dataProtectionKey.FriendlyName = reader.GetString(0); dataProtectionKey.XmlData = reader.GetString(1); } reader.Close(); } con.Close(); return(dataProtectionKey); } } }
public bool Update(DataProtectionKey dataProtectionKey) { using (var con = new Npgsql.NpgsqlConnection(_connectionString)) { var sql = @"update public.""DataProtectionKeys"" set ""XmlData""=@XmlData where ""FriendlyName""=@FriendlyName;"; using (var cmd = new Npgsql.NpgsqlCommand(sql, con)) { cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@FriendlyName", dataProtectionKey.FriendlyName)); cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@XmlData", dataProtectionKey.XmlData)); con.Open(); var result = cmd.ExecuteNonQuery() > 0; con.Close(); return(result); } } }
/// <summary> /// add dataProtectionKey /// </summary> /// <param name="dataProtectionKey">Data Protection Key</param> /// <returns></returns> public bool Add(DataProtectionKey dataProtectionKey) { using (var con = new Npgsql.NpgsqlConnection(_connectionString)) { var sql = @"INSERT INTO public.""DataProtectionKeys""(""FriendlyName"", ""XmlData"") VALUES(@FriendlyName, @XmlData);"; using (var cmd = new Npgsql.NpgsqlCommand(sql, con)) { cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@FriendlyName", dataProtectionKey.FriendlyName)); cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@XmlData", dataProtectionKey.XmlData)); con.Open(); var result = cmd.ExecuteNonQuery() > 0; con.Close(); return(result); } } }