Artifact
9f67eae28ef82e057121bb5d578c61a8179157be:
Ticket change
[9f67eae28e]
- New ticket
[83530ed1b8] SQLite EF6: DbSet<T>.SqlQuery() does not work.
by
anonymous
2019-04-02 10:03:53.
D 2019-04-02T10:03:53.528
J foundin (Nuget)\s1.0.110.0
J icomment Using\sSQlite\swith\sEF6,\sthe\sDbSet\sfunction\s"SqlQuery()"\sgives\san\sIndexOutOfRangeException\swhen\sthe\sresult\sis\senumerated.\r\n\r\nThis\sseems\sto\shappen\swhenever\sexplicit\scolumn\snames\sare\spart\sof\sthe\squery.\r\nUsing\s"select\s*\sfrom\stable"\sdoes\snot\serror\sbut\s"select\scol1,\scol2\sfrom\stable"\sdoes,\sand\sso\sdoes\s"select\st.*\sfrom\stable\st".\r\n\r\nThis\sis\sproblematic\ssince\sany\squery\sthat\suses\sa\sjoin\swill\shave\sthe\serror\s(ie\s"select\st1.*\sfrom\stable1\st1\sjoin\stable2\st2\son\st1.id\s=\st2.id\swhere\st2.col2\s=\s'search\svalue'")\r\n\r\nI\shave\screated\san\sexample\sproject\son\sGitHub\sat\s[https://github.com/Gravemind2401/SQLiteTest]
J login anonymous
J mimetype text/x-fossil-plain
J private_contact eccae9b092ba609db7fcd6d3f1592dcdd0c6b35e
J severity Important
J status Open
J title SQLite\sEF6:\sDbSet<T>.SqlQuery()\sdoes\snot\swork
J type Code_Defect
K 83530ed1b85a7a15ef08683c3282f74d394acb9a
U anonymous
Z 57e08265698f6841dd403d320bbc8f5f
