public void Update(VulnerabilityDal vulnerability) { using (var conn = Database.GetConnection()) { conn.Execute("update Vulnerabilities set vulnerability=@name where id=@id;", new { id = vulnerability.Id, name = vulnerability.Name }); } }
public int Insert(VulnerabilityDal vulnerability) { using (var conn = Database.GetConnection()) { conn.Execute("insert into Vulnerabilities (vulnerability) values (@name);", new { name = vulnerability.Name }); var result = conn.Query <VulnerabilityDal>("select id, vulnerability AS name from Vulnerabilities where name=@name;", vulnerability.Name).FirstOrDefault(); return(result == null ? -1 : result.Id); } }