public void VfpDataAdapterTests_UpdateTest() { using (var connection = this.fixture.CreateConnection()) { var transaction = connection.BeginTransaction(); using (var command = connection.CreateCommand()) { command.Transaction = transaction; command.CommandText = "select * from customers"; var dataAdapter = new VfpDataAdapter(command); new VfpCommandBuilder(dataAdapter); var dataTable = new DataTable(); dataAdapter.Fill(dataTable); dataTable.Rows[0][0] = "y"; var vfpCode = command.ToVfpCode(); var parameters = command.Parameters.Cast <VfpParameter>().ToList(); dataAdapter.Update(dataTable); var dataTable2 = new DataTable(); dataAdapter.Fill(dataTable2); Assert.Equal("y", dataTable.Rows[0][0]); } transaction.Rollback(); } }
public void Test() { using (var connection = GetConnection()) { var dataAdapter = new VfpDataAdapter("Select * from orders", connection); var dataTable = new DataTable(); dataAdapter.Fill(dataTable); var commandBuilder = new VfpCommandBuilder(dataAdapter); dataTable.Rows[0]["shipname"] = "test"; var command = commandBuilder.GetUpdateCommand(true); var vfpCode = command.ToVfpCode(); var parameters = command.Parameters.Cast <VfpParameter>().ToList(); dataAdapter.Update(dataTable); } }