This discussion is archived
2 Replies Latest reply: Dec 19, 2012 8:35 AM by 979840 RSS

The specified store provider cannot be found in the configuration, or is...

932936 Newbie
Currently Being Moderated
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE     11.2.0.2.0     Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

All,

I have a solution developed in Visual Studio 2012 targetting .Net 4.0. Simplified: Startup project is a WPF library and supporting this library is another project that uses Entity Framework to retrieve data. I have copied the connection strings from my EF project to my startup project, and everything seems to work fine on the development machine.

However, as sson as this project is run on a user's desktop they get the error:
System.ArgumentException

The specified store provider cannot be found in the configuration, or is not valid.

Stack trace (transcribed from screenshot, so there might be typos):
at.system.Data.EntityClient.EntityConnection.GetFactory(String providerString)
at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
at System.Data.EntityClient.EntityConnection..ctor(String connectionString)
at System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionStringSetting(ConnectionStringSettings appConfigConnection)
at System.Data.Entity.Internal.,LazyInternalConnection.TryInitializeFromAppConfig(String name, AppConfig config)
at System.Data.Entity.Internal.LazyInternalConnection.Initialize()
at System.Data.Entity.Internal.LazyInternalConnection.CreateObjectContextFromConnectionModel()
at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
at System.Data.Entity.Internal.Linq.InternalSet` 1.Initialize()
at System.Data.Entity.Internal.Linq.InternalSet` 1.get_InternalContext()
at System.Data.Entiy.Infrastructure.DbQuery` 1.System.Linq.IQueryable.get_Provider()
at System.Linq.Queryable.Where[TSource](IQueryable` 1 source, Expression` 1 predicate)
at MyEntityNameSpace.MyEntitySet.LoadData()

I've already verified that Oracle.DataAccess is referenced in my EF project, and I'm including oci.dll, orannzsbb11.dll, oraociei11.dll, and OraOps11w.dll in my main library (fat installation).

This configuration worked when using the older ADO.Net DataSets, but now I want to use EF 4.4 (DataBase first/model first/whatever it's not Code First) because it's just easier to code against. So obviously I'm missing something when it comes to deploying my solution. Any ideas?

Note that this is a desktop application using MS OneClick.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points