I implemented exactly as the example sent but... I received an error:
An unhandled exception of type 'System.Data.Entity.Core.MetadataException' occurred in mscorlib.dll
Additional information: Schema specified is not valid. Errors:
DataModel1.ssdl(10,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(11,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(12,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(13,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(14,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(15,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(16,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(17,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(18,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(19,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(20,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(21,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(22,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
DataModel1.ssdl(23,6) : error 0040: The Type VARCHAR2 is not qualified with a
================================================================================
Connection string generated :
metadata=res://*/DataModel1.csdl|res://*/DataModel1.ssdl|res://*/DataModel1.msl;provider=Devart.Data.Oracle;provider connection string="User Id=***;Password=***;Server=***;Direct=True;Sid=***;Persist Security Info=True"
=================================================================================
Entity framework configuration on web.config:
Code: Select all
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="Devart.Data.Oracle" type="Devart.Data.Oracle.Entity.OracleEntityProviderServices, Devart.Data.Oracle.Entity, Version=8.4.201.6, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</providers>
</entityFramework>