예제 #1
0
 public void Update(CountyDal county)
 {
     using (var conn = Database.GetConnection())
     {
         conn.Execute("update Counties set county_name=@name where id=@id;", new { id = county.Id, name = county.Name });
     }
 }
예제 #2
0
 public int Insert(CountyDal county)
 {
     using (var conn = Database.GetConnection())
     {
         conn.Execute("insert into Counties (county_name) values (@name);", new { name = county.Name });
         var result = conn.Query <CountyDal>("select id, county_name AS name from Counties where name=@name;", county.Name).FirstOrDefault();
         return(result == null ? -1 : result.Id);
     }
 }