[A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand

[hepek]

I developed a program and it is working fine on my PC. when I deploy it to the server I get the following error:

Code: Select all

[A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand. 
Type A originates from 'Devart.Data.Oracle, Version=9.11.1034.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\9.11.1034.0__09af7300eec23701\Devart.Data.Oracle.dll'. 
Type B originates from 'Devart.Data.Oracle, Version=9.14.1382.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'E:\PollingDSP\UAT\Devart.Data.Oracle.dll'. at Devart.Data.Oracle.Linq.Provider.OracleDataProvider.CreateCommand(String commandText, IDbConnection connection, Boolean forBatch)
at Devart.Data.Linq.DataProvider.a(av A_0, Object[] A_1)
at Devart.Data.Linq.Engine.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

[hepek]

I would expect all devart DLLs to be included with my app, but they are not.

[hepek]

I think the issue is with different versions of devart:

Type A originates from 'Devart.Data.Oracle, Version=9.11.1034.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\9.11.1034.0__09af7300eec23701\Devart.Data.Oracle.dll'.
Type B originates from 'Devart.Data.Oracle, Version=9.14.1382.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'E:\PollingDSP\UAT\Devart.Data.Oracle.dll'.

[Shalex]

Have you added the <publisherPolicy apply="no"/> entry for the Devart.* references in *.config of your application?
This should make CLR to ignore policy.*.Devart.* files from GAC 2.0 (\Windows\assembly\GAC_MSIL\) and GAC 4.0 (\Windows\Microsoft.NET\assembly\GAC_MSIL\).

If this doesn't help, uninstall dotConnect for Oracle from your deployment server to remove Devart.* assemblies from GAC 2.0 and GAC 4.0.

[hepek]

I do not have any entry in my app.config file related to devart.

can you please provide that config entry with <publisherPolicy apply="no"/>?

btw - I don't thik I ever installed devart on this server. is there a way to tell devart NOT to use GAC?
in another words - may I deploy the app in a way that it does not need devart installation at all.

[Shalex]

can you please provide that config entry with <publisherPolicy apply="no"/>?

1. Here is:

Code: Select all

<configuration>  
   <runtime>  
      <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">  
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-5.0.2806.0" newVersion="5.0.2806.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data.Oracle"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-9.14.1382.0" newVersion="9.14.1382.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data.Linq"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-4.9.2351.0" newVersion="4.9.2351.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data.Oracle.Linq"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-4.9.2351.0" newVersion="4.9.2351.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
      </assemblyBinding>  
   </runtime>  
</configuration>  

btw - I don't thik I ever installed devart on this server.

2. The error says that one Devart.Data.Oracle.dll is loaded from GAC. Search for dotConnect for Oracle in the "Add or remove programs" utility of your Windows.

is there a way to tell devart NOT to use GAC?

3. GAC is the first location where CLR looks for the assembly.

in another words - may I deploy the app in a way that it does not need devart installation at all.

4. Yes, you may. Refer to https://www.devart.com/dotconnect/oracl ... yment.html.