Linqpad and Sqlite - can't see field

As Sqlite is "somewhat retarded" in allowing a field to hold any value, regardless of how the field is defined, this causes some problems.

I have inherited a database (created by Zotero) that has a table that SqliteStudio reports would be recreated with:
CREATE TABLE itemDataValues (
    valueID INTEGER PRIMARY KEY,
    value           UNIQUE
);
but LinqPad can't see the value field. ItemDataValues.Dump() shows only the valueId field and it doesn't appear in the Tables treeview either.

Is there a workaround that would allow me to see this field?

-- Andrew
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!