Re: MySQL 4.0.17 and ByteFX .NET Provider Update Problem
The CommandBuilder does exactly that. It generates the Update, Delete, and Insert commands based on the Select Command.
Here is what it generated as the Insert Command:
INSERT INTO Customers (CompanyName, FirstName, LastName, Address, City, StateOrProvince, PostalCode, Country, Phone, Fax, Email, Notes, BillName, BillAddress, BillCity, BillState, BillZip, CellorPager, InternetCustomerNo) VALUES (@CompanyName, @FirstName, @LastName, @Address, @City, @StateOrProvince, @PostalCode, @Country, @Phone, @Fax, @Email, @Notes, @BillName, @BillAddress, @BillCity, @BillState, @BillZip, @CellorPager, @InternetCustomerNo); SELECT CustomerID, CompanyName, FirstName, LastName, Address, City, StateOrProvince, PostalCode, Country, Phone, Fax, Email, Notes, BillName, BillAddress, BillCity, BillState, BillZip, CellorPager, InternetCustomerNo FROM Customers WHERE (CustomerID=last_insert_id())