Using stored procedures in C# for postgreSQL using ODBC

  • Thread starter Thread starter nishi.hirve
  • Start date Start date
N

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
 
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.
Click to expand...

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