Using stored procedures in C# for postgreSQL using ODBC

[nishi.hirve]

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

 

[Frans Bouma [C# MVP]]

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#)
------------------------------------------------------------------------