PostgreSQL Discussion - Visual Studio 2005 .Net -> Npgsql -> Postgresql

Author

Visual Studio 2005 .Net -> Npgsql -> Postgresql

Philippe Lang

2005-05-27, 3:23 am

Hi,

I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating
it as a RAD tool for developing GUI front-ends to Postgresql.

RAD means for me something similar to Delphi: you configure a database
connexion, drop a few objects on a form, controls, you bind the controls
to the datasource, and finished. No glue code or whatever.

In Visual Studio 2005, that's something I could achieve with a Microsoft
database - Access or SQL Server -. When you select one of these
databases, code is being generated, that works, really, no problem.

Although Npgsql seems to be a very nice library to access Postgresql, I
was not able to do that. Adding a database to the project is fine for MS
Access / SQL Server / Oracle databases, but I'm still searching how to
do it for Postgresql.

So my question is: is it reasonable to expect as much integration of
Postgresql in Visual Studio than with the other databases? Does anyone
work under Visual Studio as easily with Postgresql than with MS Access /
SQL Server?

-----------
Philippe

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Douglas McNaught

2005-05-27, 7:23 am

"Philippe Lang" <philippe.lang@attiksystem.ch> writes:

> Although Npgsql seems to be a very nice library to access Postgresql, I
> was not able to do that. Adding a database to the project is fine for MS
> Access / SQL Server / Oracle databases, but I'm still searching how to
> do it for Postgresql.
>
> So my question is: is it reasonable to expect as much integration of
> Postgresql in Visual Studio than with the other databases? Does anyone
> work under Visual Studio as easily with Postgresql than with MS Access /
> SQL Server?

While knowing very little about Microsoft technologies, I would say
that what you are looking for is a function of the quality of the
database driver. So talk to the Npgsql folks about your specific
problems rather than posting to -general.

-Doug

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Listas Evandro

2005-05-27, 7:23 am

Try using with ODBC works great for VS2005

On 5/27/05, Philippe Lang <philippe.lang@attiksystem.ch> wrote:
> Hi,
>
> I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating
> it as a RAD tool for developing GUI front-ends to Postgresql.
>
> RAD means for me something similar to Delphi: you configure a database
> connexion, drop a few objects on a form, controls, you bind the controls
> to the datasource, and finished. No glue code or whatever.
>
> In Visual Studio 2005, that's something I could achieve with a Microsoft
> database - Access or SQL Server -. When you select one of these
> databases, code is being generated, that works, really, no problem.
>
> Although Npgsql seems to be a very nice library to access Postgresql, I
> was not able to do that. Adding a database to the project is fine for MS
> Access / SQL Server / Oracle databases, but I'm still searching how to
> do it for Postgresql.
>
> So my question is: is it reasonable to expect as much integration of
> Postgresql in Visual Studio than with the other databases? Does anyone
> work under Visual Studio as easily with Postgresql than with MS Access /
> SQL Server?
>
> -----------
> Philippe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Shelby Cain

2005-05-27, 11:23 am

--- Philippe Lang <philippe.lang@attiksystem.ch> wrote:
>
> So my question is: is it reasonable to expect as much integration of
> Postgresql in Visual Studio than with the other databases? Does
> anyone
> work under Visual Studio as easily with Postgresql than with MS
> Access /
> SQL Server?
>

Open the controls toolbox in VS.Net. Select the "General" category and
right-click anywhere on the pane. Select Add/Remove items and navigate
to the Npgsql.dll located in your Postgresql install directory. You'll
now have the Connection/Command/etc controls that you can place on
forms.

As an aside, I'd highly recommend learning how ADO.Net works at the
fundamental level so that you can (if necessary) code these things
manually instead of having to rely on the forms designer provided by
VS.Net.

Regards,

Shelby Cain

____________________
____________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Brar Piening

2005-05-27, 11:23 am

See:
http://gborg.postgresql.org/piperma...May/001374.html

Philippe Lang schrieb:

>Hi,
>
>I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating
>it as a RAD tool for developing GUI front-ends to Postgresql.
>
>RAD means for me something similar to Delphi: you configure a database
>connexion, drop a few objects on a form, controls, you bind the controls
>to the datasource, and finished. No glue code or whatever.
>
>In Visual Studio 2005, that's something I could achieve with a Microsoft
>database - Access or SQL Server -. When you select one of these
>databases, code is being generated, that works, really, no problem.
>
>Although Npgsql seems to be a very nice library to access Postgresql, I
>was not able to do that. Adding a database to the project is fine for MS
>Access / SQL Server / Oracle databases, but I'm still searching how to
>do it for Postgresql.
>
>So my question is: is it reasonable to expect as much integration of
>Postgresql in Visual Studio than with the other databases? Does anyone
>work under Visual Studio as easily with Postgresql than with MS Access /
>SQL Server?
>
>-----------
>Philippe
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links