ADO.NET Provider for Azure Data Lake Storage

Build 20.0.7654


This section provides a walk-through of writing data access code to Azure Data Lake Storage in ADO.NET.

See Data Model for more information on the available data source entities and how to query them with SQL. See SQL Compliance for the SQL syntax.

Connecting from Code

See Establishing a Connection for the prerequisite information you need to deploy the provider and configure the connection to Azure Data Lake Storage. Connecting from Code shows how to connect with the classes ADLSConnection, ADLSConnectionStringBuilder, and, in ASP.NET, ADLSDataSource.

Discovering Schemas

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.

Executing SQL

You can use native ADO.NET interfaces to execute data manipulation SQL to Azure Data Lake Storage: Querying with the DataReader and Querying with the DataAdapter provide code examples and guides to using native ADO.NET interfaces to access Azure Data Lake Storage 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.

Defining Custom Views

The provider allows you to define virtual tables whose contents are decided by a pre-configured query. See Defining Custom Views for an overview of creating and configuring custom views.

Executing Stored Procedures

You can execute Calling Stored Procedures as parameterized statements or EXEC SQL statements with the ADLSCommand class.

Connection Pooling

Instantiate pooled connections by configuring the connection string. See Connection Pooling to create and configure a pool.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654