[Mono-list] Mono Database Documentation and Examples

[Chris Aitken]

> After seeing programmers struggling to connect to various databases 
> using Mono, I realized we need some documentation and examples to help 
> people get started.
>  
> For instance, I could not find in a reasonable amount of time to 
> figure out how to use parameters with ODBC to get data from a 
> PostgreSQL database.

Use Npgsql.
  
> Does anyone have working examples to contribute?  I would like to add 
> them to Mono's wiki.
>  
> http://www.mono-project.com/Database_Access
>  
> Other examples could include using gtk# to load a TreeView with data 
> from a PostgreSQL database would be nice.
>  
> Or how to execute a stored procedure on PostgreSQL using the Npgsql 
> provider.

Search through the archives for posts from mself or Carl Olsen. Its called
the same way as a PgSQL query.

> Or populating an ASP.NET data grid via a DataSet that was populated 
> from SQL Lite or MySQL.

Again, search through the archives - I posted ways to do this.

> Examples for various databases including Sybase, Oracle, SQL Server, 
> MySQL, SQL Lite, ODBC, ADP (Advanced Data Provider), etc...

All the info I have found on the mono site has worked after a little study.
YMMV.

HTH

Chris


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.