CData ADO.NET Provider for Amazon Redshift 2019CData ADO.NET Provider for Amazon Redshift 2019 - Build 19.0.7354
The CData ADO.NET Provider for Amazon Redshift 2019 offers the most natural way to access Redshift data from .NET applications. The provider wraps the complexity of accessing Redshift data in an easy-to-integrate, fully managed ADO.NET Data Provider.
The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
- DataBind to Redshift using Visual Studio wizards.
- Real-time access to Redshift.
- Comprehensive support for create, read, update, and delete (CRUD) operations.
The provider has the same ADO.NET architecture as the native .NET data providers for SQL Server and OLEDB. Code with familiar classes such as RedshiftConnection, RedshiftCommand, RedshiftDataAdapter, RedshiftDataReader, RedshiftDataSource, RedshiftParameter, and so on. See Using ADO.NET for guides relating to these and other ADO.NET features such as batch processing, connection pooling, and calling stored procedures.
You can leverage Entity Framework to quickly and easily model database resources using .NET objects. In Using ADO.NET (Entity Framework), you can find instructions related to EF6 setup and installation, as well as the creation of both model-first and code-first data models.
Entity Framework Core
Entity Framework Core provides a streamlined, cross-platform solution for modelling database resources as .NET objects. Using ADO.NET (Entity Framework Core) covers how to surface Redshift data using EF Core console and ASP.NET applications. Additionally, you can find instructions for automatically building data models from data source metadata using reverse engineering (scaffolding).
LINQ queries allow you to query and modify data using simple, strongly typed expressions. For instructions regarding the construction and usage of LINQ queries, see Using ADO.NET (LINQ).
You can use the provider to enable real-time connectivity to Redshift within your SSRS reports. Using ADO.NET (SSRS) details provider deploy, the creation of shared and embedded data sources and datasets, and the publishing of SSRS reports.
The provider supports the creation of strongly typed DbProviderFactory and DBConnection objects in order to facilitate connecting to Redshift with generic code. Using ADO.NET (DbProviderFactory) describes how to get connected as well as create, configure, and execute DbCommands.
See Schema Discovery to use standard ADO.NET schema collections to discover schema information and other metadata.
Connection String Options
The Connection properties describe the various options that can be used to establish a connection.