public void Insert(PersonStatus personStatus) { using (IDbConnection dbConnection = Connection) { dbConnection.Open(); dbConnection.Execute( "insert into Person(FirstName, LastName, PersonStatusId) " + "values(@FirstName, @LastName, @PersonStatusId);" , new { FirstName = personStatus.FirstName, LastName = personStatus.LastName, PersonStatusId = personStatus.PersonStatusId } , commandType: CommandType.Text); } }
public void Update(PersonStatus personStatus) { using (IDbConnection dbConnection = Connection) { dbConnection.Open(); dbConnection.Execute( "update Person " + "set FirstName = @FirstName, LastName = @LastName, PersonStatusId = @PersonStatusId " + "where PersonId = @PersonId;" , new { PersonId = personStatus.PersonId, FirstName = personStatus.FirstName, LastName = personStatus.LastName, PersonStatusId = personStatus.PersonStatusId } , commandType: CommandType.Text); } }