System.Data.SQLite

Hi, i'm writing an application in C# and need to know how to get DatabaseObjects and DatabaseObjectsProperties of my database in SQLite. For example, in SQL2005 obtain DatabaseObjects is in this way:

SET NOEXEC OFF
    select name, xtype, id
    from [{0}].dbo.sysobjects
    where name like ('{1}%') and xtype in ('U','V')
    order by xtype, name

How a can do this for SQLite

Thanks. 

With

select * from sqlite_master

you will find all table names and sql to create the table

With 

pragma Table_info( <table name> )  

you will find details about fields

I highly recommend using DbConnection.GetSchema(), which is generic, and can be used on multiple database engines without writing customized code.