MonoSqlite

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
 
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 06: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.

Creating Schema Definitions

Building SqliteCommands

Personal tools
General
About This Wiki