Description
CData ADO.NET Data Provider allows developers to easily connect .NET applications to Microsoft Excel, allowing Excel data to appear in your applications, such as sql tables. Developers can use CData ADO.NET Data Provider to connect data to data like a sql server. You can use Excel Data Provider through Visual Studio Explorer Server, classes and data controls such as DataGridView, GridView and DataSet.Features of CData ADO.NET Data Provider:
- Full .Net management: Full ADO.NET library support for .NET Framework 2.0 and above
- Developer Friendly: Integrates with all versions of Visual Studio
- Duplicate and save: Duplicate and save commands make it easy to copy data across Oracle, SQL Server, Google Cloud SQL, and Q
- SQL string, date and numeric functions: Has a library of 50 functions that you can manipulate column values such as Regex, JSON, and XML
- Easily customizable: add or remove columns and tables, change data types as needed to build new ones
- Secure connection: Includes standard enterprise-class security features such as TLS / SSL data encryption for all client-server communications
- Smart Storage: A customizable option that works by storing query data to a local database
- Powerful ADO.NET Features: Support for ADO.NET Entity Framework (EF 5 & 6), ADO.NET 2.0 and LINQ to Datasets
- Access Microsoft Excel data directly from Visual Studio Explorer Server
- Configure the main connection to access Microsoft Excel account information
- Active Directory ADO.NET Provider
- Amazon DynamoDB ADO.NET Provider
- Amazon SimpleDB ADO.NET Provider
- Azure ADO.NET Provider
- Dynamics CRM ADO.NET Provider
- Dynamics GP ADO.NET Provider
- Dynamics NAV ADO.NET Provider
- Eloqua ADO.NET Provider
- Email ADO.NET Provider
- Exact Online ADO.NET Provider
- Excel ADO.NET Provider
- Excel...
Read more
Continue reading...