Why Does My TeamCity Build Fail with an 'Entity Framework Provider Not Found' Error?

Troubleshooting "Entity Framework Provider Not Found" During TeamCity Test Execution

While attempting to run tests on TeamCity installed locally, encountering an "Entity Framework Provider Not Found" exception can be frustrating. This exception indicates that the Entity Framework provider for SQL Server cannot be located by the running application.

The following steps can assist in resolving this issue:

1. Verify Entity Framework References:

Ensure that no references to "System.Data.Entity" exist in any of your projects. This is not recommended when upgrading to EF6.

2. Check App.config:

Review your app.config file to ensure there is no section named "entityFramework." This section can cause unexpected behavior.

3. Install Missing Package:

If you installed EF 6 through NuGet, it's possible that the "EntityFramework.SqlServer" package is missing from certain executables. Simply add this NuGet package to the affected project.

4. Enable Copy Local (Alternatively):

If installing the missing package doesn't resolve the issue, try setting the "Copy Local" property to "true" for the "EntityFramework.SqlServer.dll" assembly in the references of the affected project. This ensures the assembly is copied to the output directory.

Additional Context:

The reported error message:

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' for the 'System.Data.SqlClient' ADO.NET provider could not be loaded.

indicates that the specific version of the SQL Server provider cannot be found. By following the troubleshooting steps outlined above, you can determine the cause and resolve this exception during TeamCity test execution.

The above is the detailed content of Why Does My TeamCity Build Fail with an 'Entity Framework Provider Not Found' Error?. For more information, please follow other related articles on the PHP Chinese website!