The ADO.NET 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 requires properly constructed SELECT Statements. Results can be processed from the DataTable instance filled or from the DataReader returned. Updating the Data requires properly constructed UPDATE Statements, INSERT Statements, or DELETE Statements.