Hello,
i m trying to make a simple group by and i get this exception : APPLY Joins are not supported
Stack Trace :
at System.Data.SQLite.SqlGenerator.Visit(DbApplyExpression e)
at System.Data.Common.CommandTrees.DbApplyExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
at System.Data.SQLite.SqlGenerator.VisitInputExpression(DbExpression inputExpression, String inputVarName, TypeUsage inputVarType, Symbol& fromSymbol)
at System.Data.SQLite.SqlGenerator.Visit(DbProjectExpression e)
at System.Data.Common.CommandTrees.DbProjectExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
at System.Data.SQLite.SqlGenerator.VisitExpressionEnsureSqlStatement(DbExpression e, Boolean addDefaultColumns)
at System.Data.SQLite.SqlGenerator.VisitExpressionEnsureSqlStatement(DbExpression e)
at System.Data.SQLite.SqlGenerator.GenerateSql(DbQueryCommandTree tree)
at System.Data.SQLite.SqlGenerator.GenerateSql(SQLiteProviderManifest manifest, DbCommandTree tree, List`1& parameters, CommandType& commandType)
at System.Data.SQLite.SQLiteProviderServices.CreateCommand(DbProviderManifest manifest, DbCommandTree commandTree)
at System.Data.SQLite.SQLiteProviderServices.CreateDbCommandDefinition(DbProviderManifest manifest, DbCommandTree commandTree)
at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
at System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)
Any chance Apply became supported ?
Thanks for your time.
Jeff
|