Why Can't My Entity Framework Tests Load on TeamCity?

Entity Framework provider loading issue during tests on TeamCity

You are encountering an issue where the Entity Framework provider for SQL Server cannot be loaded when running unit tests on TeamCity.

The error message suggests that the provider assembly, System.Data.Entity.SqlServer.SqlProviderServices, is not available to the application during the test runtime. To resolve this, follow these steps:

• Verify your project references: Ensure that the EntityFramework.SqlServer package is referenced by all projects in your solution that use Entity Framework. The project that builds the test assemblies should also reference this package.
• Check your app.config file: The app.config file contains the configuration for your application, including Entity Framework settings. The following configuration section should be present in the app.config file of your test project:

<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirepermission="false"></section>

• Rebuild your solution: After making any changes to the project references or app.config file, rebuild the entire solution to ensure that the latest changes are reflected in the test assemblies.
• Exclude the Entity Framework DLLs: If the above steps do not resolve the issue, try excluding the EntityFramework.SqlServer.dll and EntityFramework.dll assemblies from the test assemblies. This can be done by setting the "Copy Local" property to false for these specific assemblies in the project references.

In your specific case, the stack trace suggests that the EntityFramework.SqlServer.dll assembly is missing from the test project or the test runner process. Verify the references and copy settings for this assembly.

By following these steps, you should be able to resolve the issue and successfully run your unit tests on TeamCity using Entity Framework.

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