Ticket Change Details
Not logged in

Artifact ID: 9f67eae28ef82e057121bb5d578c61a8179157be
Ticket: 83530ed1b85a7a15ef08683c3282f74d394acb9a
SQLite EF6: DbSet<T>.SqlQuery() does not work
User & Date: anonymous 2019-04-02 10:03:53

  1. Change foundin to "(Nuget)"
  2. Change icomment to:

    Using SQlite with EF6, the DbSet function "SqlQuery()" gives an IndexOutOfRangeException when the result is enumerated.

    This seems to happen whenever explicit column names are part of the query. Using "select * from table" does not error but "select col1, col2 from table" does, and so does "select t.* from table t".

    This is problematic since any query that uses a join will have the error (ie "select t1.* from table1 t1 join table2 t2 on = where t2.col2 = 'search value'")

    I have created an example project on GitHub at

  3. Change login to "anonymous"
  4. Change mimetype to "text/x-fossil-plain"
  5. Change private_contact to "eccae9b092ba609db7fcd6d3f1592dcdd0c6b35e"
  6. Change severity to "Important"
  7. Change status to "Open"
  8. Change title to "SQLite EF6: DbSet<T>.SqlQuery() does not work"
  9. Change type to "Code_Defect"