Devart Forums

When running something like the following:
IEnumerable txs =
from tx in db.ALL_SINGLY_OCCURRING_FIELDS
where (tx.C300_STATE_COUNTRY.Contains("MD")
|| tx.C300_STATE_COUNTRY.Contains("VA")
|| tx.C300_STATE_COUNTRY.Contains("DC"))
select tx;

I get the following:
E:\Documents and Settings\Rob\My Documents\Visual Studio 2008\Projects\yet-another-test\yat\bin\Debug>yat
System.Data.CommandExecutionException: An error occurred while executing the command definition, see the inner exception for details. ---> C
oreLab.Oracle.OracleException: ORA-00904: "INDEXOF": invalid identifier
at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at CoreLab.Oracle.Entity.d.a.a(CommandBehavior A_0)
at CoreLab.Oracle.Entity.d.a.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.Internal.ObjectQueryImplementation`1.MaterializeResults(ObjectQueryExecutionInfo execInfo, MergeOption mergeOption
)
at System.Data.Objects.Internal.ObjectQueryImplementation`1.GetResults(MergeOption mergeOption)
at System.Data.Objects.ELinq.ELinqQueryImplementation`1.GetResults()
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at yat.Program.Main(String[] args) in e:\Documents and Settings\Rob\My Documents\Visual Studio 2008\Projects\yet-another-test\yat\Program
.cs:line 26

The Contains method is causing the problem. Should I not be able to use this?

I think the driver is attempting to use an INDEXOF operator to search for the string which I don't think is present in oracle. Please advise.

Thank you for the bug report.
The situation is quite complicated.
We are working on the problem, please be aware that this will
take some time and plan your development strategy accordingly.