public void SetKeyAndVector(KeyAndVectorModel keyAndVector) { using (OracleConnection db = new OracleConnection(connectionString)) { string sql = "INSERT INTO AesInfo(key, iv, identify) " + "VALUES(:KEY ,:IV , 'true')"; db.Open(); db.Execute(sql, new { keyAndVector.key, keyAndVector.iv }); } }
public KeyAndVectorModel GetKeyAndVector() { using (OracleConnection db = new OracleConnection(connectionString)) { string sql1 = "SELECT nvl(identify,0) " + "FROM AesInfo WHERE identify = 'true' "; db.Open(); string havingValues = db.Query <string>(sql1).FirstOrDefault(); if (havingValues == null) { KeyAndVectorModel res = new KeyAndVectorModel(); return(res); } string sql2 = "SELECT key, iv " + "FROM AesInfo WHERE identify = 'true' "; return(db.Query <KeyAndVectorModel>(sql2).FirstOrDefault()); } }