Re: Generic provider for .Net

On Tue, Jan 6, 2009 at 7:00 PM, Rob Richardson
<Rob(dot)Richardson(at)rad-con(dot)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