SQLite library

[RudolfJan]

In a number of projects SQLite is used as database technology. SQLite has a clear advantage. It is very easy to setup. You can create a database straight from the application, if it is not there.

For using databases from C#, the Dapper Nuget package is used. Dapper makes it a bit easier to use a database. The code to set up data access code for the CRUD operations, is taken from Tim Coreys videos.

It is now a good moment to to make it a more full grown library project and put it in the RudolfLibrary, so we can maintain it at one spot.

As with other refactoring issues, the easiets way to proceed is probably to improve the data access functions as defined in ToolkitForTSW, having a look at TimetableTool as well and the move it to its new location.

What should it do?

• Create a new database if the database does not yet exist
• Get the connection string
• Manage versions of the database, so it is possible to add tables and fields to an existing database without having to install it again (which potentially may destroy user data).
• Support read/write operations using Dapper
• Upon insert, retrieve the record Id of the inserted record.
• Support for transactions
• It would be awesome if it is possible to make it even a bit easier to deal with the syntax variations in SQL, e.g. it would not be very difficult to have a list of fields and create the insert and update statement.

@Jonas I will do this one myself. It is not a very big issue, but it requires a lot of experience.

[RudolfJan]

Created this library in the RudolfLibraries repo https://github.com/RudolfJan/RudolfLibraries . It is not yet integrated in ToolkitForTSW. That is my next step.

[RudolfJan]

Integration is ongoing. It is done for RadioStations, not yet for liveries

[RudolfJan]

Solved in RudolfLibray project