Tables with Yes/No column throw Syntax Error exception

[Taylordg]

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