private void btnAdd_Click(object sender, EventArgs e) { var testDTO = new TestDTO { Id = Int32.Parse(tbxId.Text), Name = tbxName.Text }; _testService.Add(testDTO); LoadTestDtosToListBox(); }
public void Add(TestDTO testDto) { using (SqlConnection conn = new SqlConnection(_connection)) { var sql = @"insert into Test VALUES (@id, @name)"; var pararmeters = new DynamicParameters(); pararmeters.Add("id", testDto.Id); pararmeters.Add("name", testDto.Name); conn.Execute(sql, pararmeters); } }