Re: Generic provider for .Net

On Tue, Jan 6, 2009 at 7:00 PM, Rob Richardson
<Rob.Richardson@rad-con.com> wrote:
> My stumbling through the wilds of .Net, ADO.Net and PostGRESQL continues...
>


With this requirement, I would suggest you to use dbproviderfactory
support of .Net

This is a sample link with informations about it:

http://msdn.microsoft.com/en-us/library/dd0w4a2z%28VS.80%29.aspx


http://www.davidhayden.com/blog/dave/archive/2007/10/08/CreatingDataAccessLayerUsingDbProviderFactoriesDbProviderFactory.aspx


A little googling can provide you with more examples.

Also, on Npgsql manual there is the entry you have to make to register
Npgsql as a dbproviderfactory.

Also note that Npgsql supports sqlclient parameter style with the '@'
prefix to easy porting sql code from sqlserver to postgresql.

I hope it helps.


--
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org