Using ADO.NET

The provider supports both queries and updates through the standard ADO.NET guidelines against any of the tables exposed. This section includes examples of using the .NET objects to retrieve and update information against sample data.

Querying Using the DataReader and Querying Using the DataAdapter provide code examples and a guide to using native ADO.NET interfaces to access NetSuite data. Results can be processed from the DataTable instance filled or from the DataReader returned.

Updating the Data shows how to use the provider to update changes to a data set. For examples of the supported SQL syntax, see SELECT Statements, UPDATE Statements, INSERT Statements, and DELETE Statements.

The Caching Data section explains the required connection string options to cache data. You can use the classes detailed in Tables to discover the table schemas at run time.