Using EF 6
The Entity Framework is now being developed outside of the .NET Framework. This means several dependencies that were part of the .NET framework are now part of the Entity Framework. This section describes how to use Entity Framework 6 (EF6) in your project.
Install Entity Framework 6
First, install and configure the EF6 environment. Use the Package Manager Console in Visual Studio to install the latest version of Entity Framework. Run the the following command to download and install Entity Framework automatically:
Register the Entity Framework Provider
Complete the following steps to register the Entity Framework provider:
- Add the following provider entry in the "providers" section of your App.config or Web.config. This section should already exist if the Entity Framework installation was successful.
<configuration> ... <entityFramework> <providers> ... <provider invariantName="System.Data.CData.Excel" type="System.Data.CData.Excel.ExcelProviderServices, System.Data.CData.Excel.Entities.EF6" /> </providers> </entityFramework> </configuration>
- Add a reference to System.Data.CData.Excel.Entities.EF6.dll, located in the lib > 4.0 subfolder in the installation directory.
- Build the project to complete the setup for using EF6.
Build the Project
It is important to build the project so that the referenced assemblies are copied locally to the build location. These assemblies are used by the Visual Studio Entity Data Model wizard.