Automatically get SQLite data and insert it into a class

Solution 1:

Dapper is a nice solution for this. You can map the results of your query to custom POCOs, or to dynamic objects.

Mapping the query results to an object is as simple as:

var cn = ... //create your db connection
IEnumerable<MyClass> myList = cn.Query<MyClass>("select * from MyTable").ToList();

For a single instance, you would do this:

MyClass myInstance = cn.Query<MyClass>("select * from MyTable where id = 1").SingleOrDefault();