Insert update to multiple tables
- Thread starter iknowyou
- Start date
Why do you want different approaches? If there's an approach that works then why do you need more?
The question really comes down to what database and ADO.NET provider you're using. Some providers support multiple SQL statements while some do not. For example, SqlClient will allow you to include multiple SQL statements separated by semicolons in a single CommandText. OleDb with the Jet OLE DB provider for Access will not, so you'd just have to use multiple commands.
The question really comes down to what database and ADO.NET provider you're using. Some providers support multiple SQL statements while some do not. For example, SqlClient will allow you to include multiple SQL statements separated by semicolons in a single CommandText. OleDb with the Jet OLE DB provider for Access will not, so you'd just have to use multiple commands.
