データモデル
The CData ADO.NET Provider for Microsoft OneDrive models Microsoft OneDrive objects as an easy-to-use SQL database, using views and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data. Because the table definitions are dynamically retrieved, any changes to the remote data are immediately reflected in your queries.
Views
The ビュー section, which lists read-only SQL tables, contains samples from an example OneDrive site. Your data model is obtained dynamically based on your user credentials and OneDrive site.
The sample site includes the following views:
| View | Description |
| Drives | Displays all OneDrive drives accessible to the current user, including personal and shared drives |
| Files | Provides detailed information about individual files stored in OneDrive drives, including name, size, and metadata. |
| FileVersions | Tracks the version history of each file in OneDrive, allowing review or rollback of previous file states. |
| Folders | Lists all folders within a OneDrive drive, useful for navigation and hierarchical organization analysis. |
| GroupMembers | Displays a list of users assigned to each group, helping manage team or access group memberships. |
| Groups | Shows all security and distribution groups within the connected Microsoft 365 tenant, enabling administrative oversight. |
| Permissions | Details sharing and access permissions for files and folders within a OneDrive drive, identifying owners and collaborators. |
| SharedResources | Identifies all files and folders that have been shared from OneDrive, along with recipients and access levels. |
| SharedWithMeResources | Lists files and folders that have been shared with the signed-in user by others, including metadata such as the owner, sharing permissions, and access details. |
| Users | Lists users with OneDrive accounts in the organization, including user identifiers and profile details. |
Stored Procedures
ストアドプロシージャ are SQL scripts that extend beyond standard CRUD operations. They can be used to search, update, and modify information in OneDrive.