This is an attempted writeup of the methodology used with Mono / SQLite / ADO.NET in OpenSim. There is a real lack of information out there when trying to do something with these technologies. (this is very ongoing)

ADO.NET Overview

ADO.NET provides a level of abstraction away from just embedding straight up SQL in your application. This is done through the generic DataFoo objects:

• DataSet - best to think of this as an in memory copy of your database
• DataTable - an in memory representation of an sql table
• DataRow, DataColumn, etc. - you get the picture.

Once you manage to get your data into the DataFoo objects, you can manipulate them independent of underlying data source.

Creating Schema Definitions

Building SqliteCommands