Why Isn't My Entity Framework Provider Loading on TeamCity?

Entity Framework Provider Type Not Loading on TeamCity

When attempting to run tests on TeamCity, users may encounter the following exception:

System.InvalidOperationException: 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. Make sure the provider assembly is available to the running application.

Troubleshooting

To resolve this issue, ensure that the EntityFramework.SqlServer NuGet package is installed in the project experiencing the error. This package contains the necessary provider assembly for Entity Framework to load.

Additional Considerations

• Verify that the app.config file contains the appropriate configuration for the Entity Framework provider:

<entityFramework>
  <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
</entityFramework>

• Check if references to System.Data.Entity exist in any of the project's dependencies.

Additional Troubleshooting Steps from Community

• Add the EntityFramework.SqlServer package to the project via NuGet.
• Ensure that the project targeting .NET Framework 4.5 or higher.
• Double-check the copying settings for the assembly containing the EntityFramework provider.

The above is the detailed content of Why Isn't My Entity Framework Provider Loading on TeamCity?. For more information, please follow other related articles on the PHP Chinese website!