MonoSqlite
From OpenSimulator
(Difference between revisions)
| Line 4: | Line 4: | ||
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: | 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. | Once you manage to get your data into the DataFoo objects, you can manipulate them independent of underlying data source. | ||
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)
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.
