The CData ADO.NET Provider for WordPress models WordPress data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables are available through the self-hosted WordPress API. Data availability depends on the authenticated user's role and site configuration.

Commonly used tables include:

Table	Description
Categories	Create, update, delete, and query Categories to use for categorizing your posts.
Comments	Create, update, delete, and query Comments associated with a post.
Media	Create, update, delete, and query Media to attach in your posts.
Members	Create, update, delete, and list the Members of the website.
Pages	Create, update, delete, and query Wordpress Pages.
Plugins	Create, update, delete, and query Plugins.
Posts	Create, update, delete, and query Wordpress Posts.
Tags	Create, update, delete, and query Tags to associate with your posts.
Users	Create, update, delete, and list the Users of the website.
Taxonomies	List all the taxonomies.
TaxonomyTerms	List all terms of the taxonomies.
Types	List Types associated with the Posts.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating and uploading media and managing OAuth tokens.