Tables with Yes/No column throw Syntax Error exception #59
Description
Followed code first migration tutorial & video.
Data can read fine. Columns without yes/no columns can read & write but unable to write to a table that does have a yes/no column.
In my example, the Column ActiveTeamMember is a yes/no data type in access.
Inner exception is:
Syntax error in query expression '([StaffID] = @p1) select [ActiveTeamMember] from [tStaff] where [StaffID] = @p1'.
Breaks on line 321 of JetCommand.cs after calling SaveChanges() on the model context