Tables

The provider models the data in Microsoft Exchange as a list of tables in a relational database that can be queried using standard SQL statements.

CData ADO.NET Provider for Microsoft Exchange Tables


Name	Description
Calendar	Stores and manages calendar items such as appointments and meetings. It supports operations to create, retrieve, update, and delete calendar entries, including time, location, subject, and associated metadata.
Calendar_OptionalAttendees	Captures information about optional attendees for scheduled calendar events. It requires an associated item Id to retrieve attendees linked to a specific meeting or appointment.
Calendar_RequiredAttendees	Stores data on required attendees for calendar events. The queries must specify an item Id to identify the associated meeting and its required participants.
Contacts	Maintains contact information including names, email addresses, phone numbers, and job titles. It supports full Create, Read, Update, and Delete (CRUD) operations for managing a user's personal or shared address book.
DeletedItems	Represents items moved to the Deleted Items folder, including messages, calendar events, and tasks. It allows recovery, permanent deletion, or inspection of deleted content.
Drafts	Holds unsent email drafts. This enables operations to create new drafts, update draft content, delete drafts, or retrieve draft messages for review or sending.
Folders	Manages user-defined and system folders such as Inbox, Sent Items, and custom folders. It supports folder hierarchy operations like creation, deletion, and renaming.
Inbox	Contains received email messages directed to the user's inbox. It allows access to individual messages with full Create, Read, Update, and Delete (CRUD) capabilities for inbox content management.
JunkEmail	Tracks email items flagged as spam or junk. It facilitates review, removal, or retrieval of misclassified messages.
Outbox	Temporarily stores outgoing email messages pending delivery. The items in this table can be created, reviewed, or deleted before transmission is completed.
SentItems	Archives sent email messages for auditing and retrieval. It allows querying and management of previously sent emails.
Tasks	Maintains a list of tasks, including due dates, completion status, priorities, and reminders. It supports full task lifecycle management through CRUD operations.