MonoSqlite
From OpenSimulator
(Difference between revisions)
| Line 2: | Line 2: | ||
= ADO.NET Overview = | = 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 = | ||
Revision as of 05:37, 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)
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.
