search

smourier / SQLNado

SQLNado (SQLite Not ADO) is a .NET lightweight bloat free wrapper and object persistence framework based on SQLite.
MIT License
31 stars 9 forks source link

Fix cannot insert row with no insert parameter #2

Closed meziantou closed 6 years ago

meziantou commented 6 years ago

SQLNado generates an invalid insert statement when there is no insert parameter. This can happen when all columns are computed.

INSERT INTO Customer () VALUES ()

This PR changes the SQL statement to

INSERT INTO Customer DEFAULT VALUES

BTW, I've added the test project to the solution and a few tests.