Hi,
I have created a Coded UI Test project with the following settings:
NuGet Packages Installed:
EntityFramework 6.0.0
Oracle.ManagedDataAccess.EntityFrameWork 12.1.2400
**Oracle.ManagedDataAccess 12.1.2400
Target Framework:****.Net Framework 4.5.2**
When trying to access the oracle database through Entity Eramework 6.0.0, I get the exception below:
**
Result Message:**
Test method ExcelDBImplementation.CodedUITest1.CodedUITestOracleEntityFramework threw exception:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'System.Data.Entity.SqlServer.SqlProviderServices' threw an exception. ---> System.TypeLoadException: Could not load type 'System.Data.Entity.Infrastructure.TableExistenceChecker' from assembly 'EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
I downloaded Oracle Developer Tools with for VS 2015. This is how I accessed the database.
Connection string :
<add name="Entities" connectionString="metadata=res://*/Entity.TestData.csdl|res://*/Entity.TestData.ssdl|res://*/Entity.TestData.msl;provider=Oracle.ManagedDataAccess.Client;provider connection string="DATA SOURCE=orcl;PASSWORD=password;PERSIST SECURITY INFO=True;USER ID=username;" providerName="System.Data.EntityClient"/>
</connectionStrings>
However, when running a console application project or a unit test project with the same settings, it runs sucessfully. Is there any difference in the Coded UI Test project that causes this difference in behaviour?