Re: From ODBC to .NET provider

On 21 Jul 2004 at 12:53, Jon Asher wrote:

> Has anyone moved from the ODBC driver to a native .NET provider? Any
> recommendations on which Postgres .NET provider to go with? There are a
> couple commercial versions and the open soruce one....
>
> Jon
>
Yes, I've done some work with .NET (C#) and PostgreSQL. I started using the ODBC
driver which works pretty well. Just one bug with calling stored procedures with int2
parameters. The driver doesn't typecast the int2 parameters and so can't find the
function. Otherwise no real problems.

I moved to using Npgsql native driver for mainly performance reasons. Unfortunately I
have to maintain a codebase that supports both postgres and MS SQL Server. To
minimise the code changes I have gone back to ODBC.

Npgsql seems to perform very well and I never had any trouble using it. I tend to keep
my ADO.NET stuff fairly simple though. Connections, Commands (both text and stored
procedures), Datareaders. I don't use datasets so I can't tell you about this area and
Npgsql.

I have tried the PostgreSQL Direct driver from CoreLabs as I wanted to use their
Unidriver to maintain compatibility with SQLServer, but it is very buggy at the moment.

I would say that if you need to go native, then use the open source one (Npgsql)

Cheers,
Gary.