Skip site navigation (1) Skip section navigation (2)

Re: From ODBC to .NET provider

From: "Jon Asher" <jon(dot)asher(at)fusemail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: From ODBC to .NET provider
Date: 2004-07-21 20:05:30
Message-ID: 1647.64.160.165.191.1090440330.fusewebmail-59475@www.fusemail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
That's good to know re the Corelabs driver which I'd been looking at also.
 I see that they released a 1.8 build in Jun 04- do you remember which
build you were testing?

It looks like Npgsql is the way to go anyway.

Jon

----- Original Message -----
> 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.
>
>


In response to

Responses

pgsql-odbc by date

Next:From: Gary DoadesDate: 2004-07-21 20:34:54
Subject: Re: From ODBC to .NET provider
Previous:From: Stuart KendrickDate: 2004-07-21 19:43:30
Subject: Re: psqlODBC / install / WinXP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group