Simon Slavin wrote:
> On 12 Feb 2018, at 6:00pm, Istvan Heckl <> wrote:
>> Because of this bug at the moment SQLite can not be used with Entity
>> Framework if calculated columns are involved.
> SQLite does not have calculated columns.

I guess he means something like this (which works fine in plain SQLite):

  $ sqlite3
  sqlite> create view v as select 1, 2+3, 4 as x;
  sqlite> .header on
  sqlite> .mode columns
  sqlite> select * from v;
  1           2+3         x
  ----------  ----------  ----------
  1           5           4

But I doubt that System.Data.SQLite removes the result column names.

sqlite-users mailing list

Reply via email to