majbo

I got the same problem. I could track it down to the [selector-controller.js](angular-filemanager/src/js/controllers/selector-controller.js). `openNavigator` and `getSelectedPath` are both never called. Both methods are registered on the `$rootScope`, maybe that might...

@ataberner I'm not longer working with the angular-filemanager. We implemented our own file upload with the bare minimum functions we need.

Thanks for your suggestions, unfortunately it doesn't help. Is there a way to use Sql.Convert to convert to NVARCHAR(MAX)?

```c# Label = Sql.Convert(c.Label) ``` Is doing the trick! Issue can be closed.

```sql LinqToDB BeforeExecute -- SQLite WITH [FolderCTE] ( [Entity], [Id], [ParentId], [Level], [Label], [Entity_1] ) AS ( SELECT [t1].[Label_1], [t1].[Id_2], [t1].[ParentId_2], [t1].[Level_1], [t1].[Label_2], [t1].[Entity] FROM ( SELECT [c_1].[MetaId] as [Entity],...

I tried and it didn't change the error. You can find a small project with an example here: [LinqToDbCteDemo](https://github.com/majbo/LinqToDbCteDemo)

Surprisingly, the sample project works with only the following references: (no EF.Core, just Microsoft.EntityFrameworkCore.Sqlite) In my main application its Microsoft.EntityFrameworkCore 3.12

I tried it with `linq2db 3.0.0-rc.0` and `linq2db.EntityFrameworkCore 3.2.0` but no change. From my understanding, SQLite does not allow sub-queries within a CTE. When removing the assignments `Entity = c`...

Thats a surprisingly simple workaround for my problem! Thanks!