EntityFramework.SqlServer.dll not is getting added to the published folder only when I publish in RELEASE mode

c# entity-framework-6

Question

I know there is a problem with EF6 EntityFramework.SqlServer and included var type = typeof(System.Data.Entity.SqlServer.SqlProviderServices); in context constructor. It works fine when i do publish in DEBUG mode.

Getting the below error only when I publish in RELEASE mode. The reason is EntityFramework.SqlServer.dll missing in the published folder. But, bin folder has EntityFramework.SqlServer.dll for both debug and release mode.

Error:

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application.

Why is it missing only when I publish using RELEASE mode?

1
10
8/22/2014 3:08:09 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Don't know why; but adding this method to your context will make your project copy the dll

private void FixEfProviderServicesProblem()
        {
            // The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer'
            // for the 'System.Data.SqlClient' ADO.NET provider could not be loaded. 
            // Make sure the provider assembly is available to the running application. 
            // See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
            var instance = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
        }

Tested and working Reference: Entity Framework Provider type could not be loaded?

26
5/23/2017 11:54:31 AM

Related Questions

There's some confusion between EntityFramework.dll and System.Data.Entity.dll.

I wonder what EntityFramework.dll and System.Data.Entity.dll have in common and what they have different? My project references System.Data.Entity.dll (June CTP) to leverage code first model and everything works fine. ...Now I wish to use Code First Migrations tool, and it requires EntityFramework.dll that I also have to add to my project. However,...
.net ef-code-first entity-framework
asked by Alex Avrutin

In Release mode, an item with the same key has already been added.

Experts,...I'm getting this ...System.ArgumentException... (...An item with the same key has already been added...) at the very first use of an entity framework function at runtime. The strange thing: If I'm using debug mode, it works fine. After compiling the same code without any changes made in ...release mode..., it crashes immediatly with exce...
.net c# entity-framework release
asked by Machine

In System.Data.Entity.dll (Entity Framework), why am I receiving a NullReferenceException?

I have a ...List<State>... of ...State... entity objects, and each ...State... object has collections of other objects, such as ...Licenses..., ...Taxes..., ...Bonds..., etc...There's also a collection for ...ExpiredObjects..., which is a list of any object which is expired and needs to be renewed. For some reason, this property is giving me a ...N...
c# entity-framework wpf
asked by Rachel

Can't find System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer

I'm constructing a DbContext from an SqlConnection. When I use it, I receive the following error:...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....
c# entity-framework-6
asked by Vincent-Philippe Lauzon

Error Copying file bin\EntityFramework.SqlServer.xml to ..\bin\EntityFramework.SqlServer.xml failed

Error 1 Copying file bin\EntityFramework.SqlServer.xml to obj\Debug\Package\PackageTmp\bin\EntityFramework.SqlServer.xml failed. Could not find file 'bin\EntityFramework.SqlServer.xml'. 0 0 Karinoks ...when I try to publish my mvc 4 project, I have this error. ...there is no error on debugging or run time. it is just showed when I pub...
asp.net-mvc c# entity-framework
asked by mrTurkay

A first chance exception of type 'System.Data.Entity.Core.EntityCommandExecutionException' occurred in EntityFramework.SqlServer.dll

I am trying to call a stored procedure using entity framework 6. I get an error on the output message....A first chance exception of type 'System.Data.Entity.Core.EntityCommandExecutionException' occurred in EntityFramework.SqlServer.dll... using (var context = new PartnerPortalEntities2()) { var outputParameter = new ObjectParameter("result",...
asp.net-mvc-5 entity-framework-6
asked by Prady

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' could not be loaded

I created a WCF Service using dotNet 4.5. The database layer is built with Entity Framework 6....I hosted the service with IIS 8. It is working fine....Now I need to consume the service with windows forms client, that is built using dotnet framework 3.5. ...I can create the service reference successfully. But when I run the code, getting the follo...
.net entity-framework wcf winforms
asked by Ali Sakhi

EntityFramework.SqlServer missing in release mode

I have several modules in my XAF Winforms application. The lowest tier makes use of Entity Framework 6.2 as installed by Nuget....The app runs fine in debug mode....However in release mode I get the following warning building. ...Severity Code Description Project File Line Suppression State Warning Could not resolve this reference. ...
desktop-bridge entity-framework-6 xaf
asked by Kirsten Greed

dbo.__MigrationHistory table not being updated when publishing from Visual Studio

I am having an issue with the dbo.__MigrationHistory table not being updated with new database migrations, BUT the actual database itself is correctly updated with relevant changes. This means the site won't load due to it spotting a change in the context - and I have to manually insert the new changes into the dbo.__MigrationHistory table to make ...
azure entity-framework entity-framework-6 visual-studio
asked by Dan Faber

Publish to azure - turn off scheme update is terminating because data loss could occur

I am using EF6 code first, with automatic migrations disabled. All is fine on my local PC, but when I publish from Visual Studio to Azure I get the error message telling me that the schema update is terminating because data loss might occur. ...I know that the changes I'm running will mean that a data loss will occur but that is fine. But I can'...
azure entity-framework entity-framework-6 visual-studio visual-studio-2017
asked by Dan Faber

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow