This section provides a walk-through of writing data access code to Open Exchange Rates in ADO.NET.
Connecting from Code
See Establishing a Connection for the prerequisite information you need to deploy the provider and configure the connection to Open Exchange Rates. Connecting from Code shows how to connect with the classes OpenExchangeRatesConnection, OpenExchangeRatesConnectionStringBuilder, and, in ASP.NET, OpenExchangeRatesDataSource.
You can use the classes detailed in Schema Discovery to discover the table schemas at run time. You can also query the available System Tables to retrieve schema information, data source information, and other data provider metadata.
You can use native ADO.NET interfaces to execute data manipulation SQL to Open Exchange Rates: Querying with the DataReader and Querying with the DataAdapter provide code examples and guides to using native ADO.NET interfaces to access Open Exchange Rates data. Results can be processed from the DataTable instance filled or from the DataReader returned. For examples of the supported SQL syntax, see SELECT Statements.
Executing Stored Procedures
You can execute Calling Stored Procedures as parameterized statements or EXEC SQL statements with the OpenExchangeRatesCommand class.
Instantiate pooled connections by configuring the connection string. See Connection Pooling to create and configure a pool.