MonoSqlite
From OpenSimulator
(Difference between revisions)
| Line 9: | Line 9: | ||
Once you manage to get your data into the DataFoo objects, you can manipulate them independent of underlying data source. | Once you manage to get your data into the DataFoo objects, you can manipulate them independent of underlying data source. | ||
| + | |||
| + | == DataSet and Friends == | ||
| + | |||
| + | == Sqlite Specific Commands == | ||
= Creating Schema Definitions = | = Creating Schema Definitions = | ||
= Building SqliteCommands = | = Building SqliteCommands = | ||
Revision as of 05:38, 25 August 2007
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.
