Re: [Firebird-net-provider] LINQ Outer Error

[Jiri C. <di...@ci...>]

On Thu, May 9, 2013 at 5:34 AM, Muthu Annamalai
<pea...@ho...> wrote:
> Firebird is throwing this exception
>
>
>
> SQL error code = -104
>
> Token unknown - line 35, column 4
>
> OUTER ---&amp;gt; Dynamic SQL Error
>
> SQL error code = -104
>
> Token unknown - line 35, column 4
>
> OUTER
>
>    at
> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
> behavior)
>
>    at
> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
> behavior)
>
>    at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
>
>    at
> System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
> entityCommand, CommandBehavior
> behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.Common.IscException,
> FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral,
> PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error

Yes. This query is very likely to end up with OUTER APPLY in the
generated statement and this is not supported by Firebird (yet). You
have to rewrite the query.

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com