Why PGSQL has no developments in the .NET area?
PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish. The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC driver is not the right choice for ORM framework of .NET.
I want to know whether there is any efficient .NET provider and is PGSQL compatible with the .NET entity framework.
Regards,
Rohit.
Rohit Coder wrote:
PgSQL has just one old NPGSQL driver for .NET, which is itself
sluggish. The ODBC driver works better as compared to NPGSQL, but I
suspect the ODBC driver is not the right choice for ORM framework of .NET.I want to know whether there is any efficient .NET provider and is
PGSQL compatible with the .NET entity framework.Regards,
Rohit.
Won't bite on the "why" of it all, but is this
<http://www.devart.com/dotconnect/postgresql/> what you're after?
On 10/01/2011 10:32 PM, Rohit Coder wrote:
PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish. The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC driver is not the right choice for ORM framework of .NET.
I want to know whether there is any efficient .NET provider and is PGSQL compatible with the .NET entity framework.
Regards,
Rohit.
why: probably because no .net user has stepped up and written one. Not enough interest maybe?
But really, why would you need to? I assume .net is not so crippled that it can't link to a .dll, correct? Why not just use the native libpq.dll? The interface is well documented and simple to use. And you wont get any faster.
-Andy
PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish.
The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC
driver is not the right choice for ORM framework of .NET.I want to know whether there is any efficient .NET provider and is PGSQL
compatible with the .NET entity framework.Regards,
Rohit.Won't bite on the "why" of it all, but is this
<http://www.devart.com/dotconnect/postgresql/> what you're after?
We use the DevArt drivers (their Oracle drivers anyway) at work and
they're pretty good. They have solid tech support (helpful and quick
to respond) and they seem to write quality stuff. I'd assume their PG
drivers are just as good. However, this stuff isn't cheap. You pay
per dev license and it's like a few hundred bucks per dev.
I use Npgsql for my own website (www.kitchenpc.com) and I've had zero
problems with these drivers. They're 100% managed code, and they seem
to be quick even though I haven't done any in-depth speed comparisons.
Hi!
What usage case of Npgsql are you having performance issues?
On Sun, Oct 2, 2011 at 00:32, Rohit Coder
<passionate_programmer@hotmail.com> wrote:
PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish. The
ODBC driver works better as compared to NPGSQL, but I suspect the ODBC
driver is not the right choice for ORM framework of .NET.I want to know whether there is any efficient .NET provider and is PGSQL
compatible with the .NET entity framework.Regards,
Rohit.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Attachments:
top.letterheadimage/png; name=top.letterheadDownload+3-1
Import Notes
Resolved by subject fallback
I do not understand what you mean by the term sluggish?
Every .NET driver has some overhead when you first load it, and then it is
being cached into memory.
I have used Npgsql and it worked great for me.
If you are not satisfied with Npgsql, try Devarts connector.
On Oct 2, 2011 5:33 AM, "Rohit Coder" <passionate_programmer@hotmail.com>
wrote:
PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish.
The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC
driver is not the right choice for ORM framework of .NET.
I want to know whether there is any efficient .NET provider and is PGSQL
compatible with the .NET entity framework.
Show quoted text
Regards,
Rohit.
On Mon, Oct 3, 2011 at 9:13 AM, <mgould@isstrucksoftware.net> wrote:
The Ngpsql driver isn't old. They've released updates to it all through
version 8 and 9 so far as I know. We do some .Net work against Postgres and
it seems to work for what we're doing.Indeed, the latest release seems to be less than a month old..... It does
seem the project could release news items more frequently though. ;-)
Best Wishes,
Chris Travers
Attachments:
top.letterheadimage/png; name=top.letterheadDownload+3-1
On Mon, Oct 3, 2011 at 13:46, Chris Travers <chris.travers@gmail.com> wrote:
On Mon, Oct 3, 2011 at 9:13 AM, <mgould@isstrucksoftware.net> wrote:
The Ngpsql driver isn't old. They've released updates to it all through
version 8 and 9 so far as I know. We do some .Net work against Postgres and
it seems to work for what we're doing.Indeed, the latest release seems to be less than a month old..... It does
seem the project could release news items more frequently though. ;-)
Best Wishes,
Chris Travers
Yeah, I agree with you. Sorry for that.
On the good side, we released a new beta last week. :)
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Attachments:
top.letterheadimage/png; name=top.letterheadDownload+3-1
Hi,
Sorry for the delay.
I used Npgsql 2.0 last and it was slow when querying database to populate DataGridView or DropDownLists in Windows Forms application. To verify, I removed Npgsql and installed pgsql's ODBC driver. It worked very fast.
In another case, when the user brings focus on any DropDownList, the list fills with filtered records. This filling was slow when compared to the ODBC driver.
I checked Npgsql latest release on this page of PgFoundry. When you all are saying that Npgsql's last release was 9, I suspect whether I am looking the latest release on a correct website or not.
Regards,
Rohit Khare.
From: francisco@npgsql.org
Date: Mon, 3 Oct 2011 13:52:22 -0300
Subject: Re: [GENERAL] Why PGSQL has no developments in the .NET area?
To: chris.travers@gmail.com
CC: mgould@isstrucksoftware.net; pgsql-general@postgresql.org; passionate_programmer@hotmail.com
On Mon, Oct 3, 2011 at 13:46, Chris Travers <chris.travers@gmail.com> wrote:
On Mon, Oct 3, 2011 at 9:13 AM, <mgould@isstrucksoftware.net> wrote:
The Ngpsql driver isn't old. They've released updates to it all through version 8 and 9 so far as I know. We do some .Net work against Postgres and it seems to work for what we're doing.
Indeed, the latest release seems to be less than a month old..... It does seem the project could release news items more frequently though. ;-)
Best Wishes,Chris Travers
Yeah, I agree with you. Sorry for that.
On the good side, we released a new beta last week. :)
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com