UPDATE: This is now a ticket from System.Data.Sqlite.org. Link
I have similar similar in my SQLite database
SELECT * FROM ( SELECT * FROM ( SELECT fc.FilterCommandId, fc.ProcedureId, 1 AS IsDynamic, substr(fc.DataType, 1, 20) || fc.Sequence AS Filter, fc.ObjectName FROM ((FilterCommands fc INNER JOIN DynamicFilterCommands dfc ON fc.FilterCommandId = dfc.FilterCommandId) INNER JOIN DynamicFilterCommandFields dfcf ON dfc.DynamicFilterCommandId = dfcf.DynamicFilterCommandId) INNER JOIN ProcedureFilterKeys pfk ON fc.ProcedureId = pfk.ProcedureId GROUP BY fc.FilterCommandId, fc.ProcedureId, 1, substr(fc.datatype, 1, 20) || fc.Sequence, fc.ObjectName ORDER BY fc.SortOrder ) AS sq UNION SELECT fc.FilterCommandId, fc.ProcedureId, 0, substr(fc.datatype, 1, 20) || fc.Sequence, NULL FROM FilterCommands fc INNER JOIN StaticFilterCommands sfc ON fc.FilterCommandId = sfc.FilterCommandId )
The problem I am facing is matching all columns in EF. I get error code 6005 (the data type is not currently supported for the target version of the Entity Framework) for multiple columns. Apparently, this affects the literal values represented in the view ( 1 AS IsDynamic , for example) and values taken directly from the tables ( fc.ObjectName , although this is given a NULL value for the second part of the UNION query)
This causes the columns to not appear in the view. I want this view to be read only, so I don't care about the update. But I would like the columns to be available for the application.
Has anyone come across this problem or had ideas for a fix?
source share