Home All Groups Group Topic Archive Search About

Using stored procedures in C# for postgreSQL using ODBC

Author
30 Jun 2006 10:36 AM
nishi.hirve@gmail.com
Hello,

I am writing one simple application in C# in which i m writing some
queries for retriving data from database. Database used is postgeSQL
which is used through ODBC.


I want to write queries using stored procedures, I don't know where to
write stored procedures for postgreSQL. I have written them for
sqlServer but not for postgreSQL.


Thanks in Advance,
Nishi

Author
1 Jul 2006 7:38 AM
Frans Bouma [C# MVP]
nishi.hi***@gmail.com wrote:

> Hello,
>
> I am writing one simple application in C# in which i m writing some
> queries for retriving data from database. Database used is postgeSQL
> which is used through ODBC.
>
>
> I want to write queries using stored procedures, I don't know where to
> write stored procedures for postgreSQL. I have written them for
> sqlServer but not for postgreSQL.

    PostgreSql uses 'functions' which are the stored procedures of
postgresql. Just download the client tools for postgresql and check the
SQL documentation online. Use Npgsql .NET provider for postgresql, it's
a full .NET provider, so you don't have to use the slower odbc route.

        FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

AddThis Social Bookmark Button