When importing an EDMX file with the provider "Oracle.ManagedDataAccess.Client" you get an error saying "The specified store provider cannot be found in the configuration, or is not valid.".
Exception message:
-------------------------------
Exception type: ImporterAbortException
The file C:\...\MyDB.edmx could not be loaded.
Inner exception message:
-------------------------------
Exception type: ArgumentException
The specified store provider cannot be found in the configuration, or is not valid.
Inner exception message:
-------------------------------
Exception type: ArgumentException
Unable to find the requested .Net Framework Data Provider. It may not be installed.
The file C:\utv\Agio\Giron\GironDAL\GironDB.edmx could not be loaded.
The specified store provider cannot be found in the configuration, or is not valid.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
LLBLGen Pro version 5.7. Build 5.7.1
-----[Core exception]--------------------
at SD.LLBLGen.Pro.Importers.EdmxImporter.EdmxToImportableHelper.InitializeContext(String fileName)
at SD.LLBLGen.Pro.Importers.EdmxImporter.EdmxToImportableHelper..ctor(String fileName, String entryExeLocation)
at SD.LLBLGen.Pro.Importers.EdmxImporter.ImportInformationRetriever.InitializeImportableHelper()
at SD.LLBLGen.Pro.Importers.EdmxImporter.ImportInformationRetriever.GetFirstLevelInfo()
at SD.LLBLGen.Pro.Importers.EdmxImporter.ImportInformationRetriever.GetFirstLevelInfo()
at SD.LLBLGen.Pro.ApplicationCore.Extensibility.ImporterBase`1.GetFirstLevelInfo()
at SD.LLBLGen.Pro.Gui.Forms.ImportDataRetrievalWizard.RefreshFirstLevelData()
-----[InnerException]--------------------
at System.Data.EntityClient.EntityConnection.GetFactory(String providerString)
at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString)
at System.Data.Objects.ObjectContext..ctor(String connectionString)
at SD.Tools.Edmx.ObjectContextExtended..ctor(String connectionString, String ssdlFileName)
at SD.Tools.Edmx.EdmxLoader.ProduceObjectContextFromConnectionString(String connectionString)
at SD.Tools.Edmx.EdmxLoader.ProduceObjectContextFromEdmx(String edmxFileName)
at SD.LLBLGen.Pro.Importers.EdmxImporter.EdmxToImportableHelper.InitializeContext(String fileName)
-----[InnerException]--------------------
at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
at System.Data.EntityClient.EntityConnection.GetFactory(String providerString)
I tried changing the EDMX file to use provider "Oracle.DataAccess.Client", but then I got other errors.
If I modify the SD.LLBLGen.Pro.Importers.dll assembly, to include case "Oracle.ManagedDataAccess.Client":
in the ProviderNameToDriverID()
method and recompile, everything loads fine.