Project Description:
I would like a generic class that makes it simple to work with sqlite. Must be able to support multiple tables defined either as classes or with SQL table syntax.
Class must support the usual CRUD operations.
Should validate the existence of the data base file, and create it required.
Support table creation, queries, insert, delete, cursors (via list or array)
Should validate existence of database and allow an existing database to be clon-ed (dash is there to avoid stupid and inapproriate freelancer warning)
Deliverable - C# Winform demo project showing the use of the sqlite class and demonstrating all the supported operations
- create db,
- create table,
- insert record (return id of inserted record),
- update record,
- delete record,
- sql query returning single record,
- sql query returning a resultset as List or array)
etc
There are plenty of demos available. I want the functionality bundled in an easy to use class.