c# - View Column Types Not Supported - Entity Framework -


update: ticket system.data.sqlite.org. link

i have view similar in sqlite database

select * (     select * (         select fc.filtercommandid, fc.procedureid, 1 isdynamic,                 substr(fc.datatype, 1, 20) || fc.sequence filter, fc.objectname          ((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 fc.filtercommandid, fc.procedureid, 1,                   substr(fc.datatype, 1, 20) || fc.sequence, fc.objectname         order fc.sortorder    ) sq     union     select fc.filtercommandid, fc.procedureid, 0, substr(fc.datatype, 1, 20) || fc.sequence,            null    filtercommands fc inner join staticfiltercommands sfc          on fc.filtercommandid = sfc.filtercommandid )

the problem having mapping columns in ef. getting error code 6005 (the data type '' not supported target entity framework version) several of columns. appears affect literal values provided in view (1 isdynamic, instance), , values taken directly tables (fc.objectname, although provided value of null second part of union query)

this results in columns not being mapped view. want view read only, not worried updating. columns available application.

has experienced issue, or have ideas on fixing?


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more