> Metadata should be on-demand, and not automatically returned.  As far as a
> standard is concerned, OLEDB and ODBC do it differently and I'd have to
> look it up.

Here are the meta data standards:

OLEDB Scheme Rowsets
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbschema_rowsets.asp

SQL - 92 INFORMATION SCHEMA VIEWS
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp

However, concerning the SQLite.NET provider I recommend putting your
efforts into

Schemas in ADO.NET 2.0 (We're already playing with them)
http://msdn.microsoft.com/library/en-us/dnvs05/html/adonet2schemas.asp

Since SQLite has no OLEDB driver forget the schema rowset, you could
create pragma's that match the SQL-92 INFORMATION_SCHEMA Views.

Mike Griffin
MyGeneration Software
http://www.mygenerationsoftware.com



Reply via email to