MonoSqlite
From OpenSimulator
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)
Contents |
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.