I am working on our Dev build. Our Dev server uses the same database as I do locally.
We use CAL and in the host Silverlight app I have a ServiceReferences.ClientConfig. Its updated to the correct path. In the web.config the services are updated. I believe thats all working.
I am getting error:
Caught exception: IdeaBlade.EntityModel.EntityServerException: Key 'COMMONDATASOURCEKEY': The connection string for Key 'COMMONDATASOURCEKEY' was not found or is invalid. Check that either a connectionStrings element or EdmKey is defined for this key in the configuration file, or implement a custom IDataSourceKeyResolver. ---> IdeaBlade.EntityModel.EntityServerException: The connection string for Key 'COMMONDATASOURCEKEY' was not found or is invalid. Check that either a connectionStrings element or EdmKey is defined for this key in the configuration file, or implement a custom IDataSourceKeyResolver. ---> System.ArgumentException: The specified store provider cannot be found in the configuration, or is not valid. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed. at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at System.Data.EntityClient.EntityConnection.GetFactory(String providerString) --- End of inner exception stack trace --- 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.Objects.ObjectContext.CreateEntityConnection(String connectionString) at IdeaBlade.EntityModel.Edm.EdmKey.CreateContext() --- End of inner exception stack trace --- at IdeaBlade.EntityModel.Edm.EdmKey.CreateContext() at IdeaBlade.EntityModel.Edm.EdmKey.Initialize() at IdeaBlade.EntityModel.Edm.EdmKey.CreateContext() --- End of inner exception stack trace --- at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.HandleException(Exception e, PersistenceFailure failureType) at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.OnExecuteQuery() at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.Execute(IEntityQuery entityQuery, SessionBundle sessionBundle, EntityServer entityServer) at IdeaBlade.EntityModel.Server.EntityServer.Fetch(SessionBundle sessionBundle, IEntityQuerySurrogate surrogate) at SyncInvokeFetch(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
COMMONDATASOURCEKEY connectionString is in the web.config. It works running it locally.
<
add name="COMMONDATASOURCEKEY" connectionString="metadata=res://*/Common_Model.csdl|res://*/Common_Model.ssdl|res://*/Common_Model.msl;provider=Devart.Data.Oracle;provider connection string='User Id=****;Password=********;Server=gmste.world;Home=oraodac11g_home1;Persist Security Info=True'" providerName="System.Data.EntityClient" />