The assemblies shipped by the provider contain standard ADO.NET components, including components for creating ASP.NET applications and SSRS reports, from code and from the designer.
Choosing the Assemblies for Your Version of the .NET Framework
The lib folder in the installation directory has .NET 3.5 assemblies. The 4.0 subfolder contains .NET 4.0 assemblies that have been compiled with the 4.0 compiler. These will not work with older versions of the .NET Framework. To use the Entity Framework, you must compile with .NET 4.0. Finally, the netstandard2.0 subfolder contains the System.Data.CData.Excel assembly compiled with .NET Standard 2.0.
Determining Project Dependencies
The following sections list the main assemblies and assemblies you need to integrate with Visual Studio designers and other tools.
Main ADO.NET Assemblies
The CData ADO.NET Provider for Excel ships the following ADO.NET assemblies:
- System.Data.CData.Excel.dll: This is the main ADO.NET provider assembly.
- System.Data.CData.Excel.Designer.dll: This assembly contains design-time resources that you can include for a better development experience. It does not need to be deployed and it is not available for .NET Core applications.
Note that if you are building a .NET Core application that requires support for code pages other than UTF8 (such as Latin-1), you will need to add a NuGet reference for System.Text.Encoding.CodePages.
Entity Framework Assemblies
The provider supports Entity Framework with the following assembly:
System.Data.CData.Excel.Entities.EF6.dll: This assembly includes support for Entity Framework 6 (EF6).
See Using Entity Framework for information on creating Entity Framework data models with the provider.
Entity Framework Core Assemblies
The provider supports EF Core with the following assembly:
CData.EntityFrameworkCore.CData.Excel.dll: This assembly includes support for Entity Framework Core.
See Using Entity Framework Core for information on creating EF Core data models with the provider.
The provider supports SSRS 2005 and above; the assemblies for each SSRS version are located in the SSRS subfolder in the installation folder. For example:
- CData.SSRS2017.Excel.dll: This assembly is deployed to the report server.
- CData.SSRS2017.Excel.Design.dll: This assembly contains design-time resources that you can include for a better development experience. It does not need to be deployed.