> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, February 28, 2005 12:26 PM > To: sqlite-users@sqlite.org > Cc: sqlite-users@sqlite.org > Subject: RE: [sqlite] ticket 1147 > > > 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.
That is general metadata information, not metadata information on a specific query. As in my previous post, ODBC does per-query metadata via SQLColAttribute() or the old SQLColAttributes() API, OLEDB uses IColumnsRowset, and other databases implement it in other fashions of which I am currently unaware but would be happy to investigate. Currently, I implement just about all the generic schema functionality in ADO.NET 2.0 for SQLite. The experimental provider can be found at http://www.blackcastlesoft.com/files/sqlitereadme.htm I'm currently in the process of moving the code to Sourceforge. Robert