Re: Using stored procedures in C# for postgreSQL using ODBC

nishi.hirve@xxxxxxxxx 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#)
------------------------------------------------------------------------
.

Relevant Pages

  • Best bit fields implementation under postgres
    ... I'm working on a database (postgresql) structure and some of the ... must store bit fields. ... Later on it must handle queries like "give me ...
    (comp.databases)
  • Using stored procedures in C# for postgreSQL using ODBC
    ... I am writing one simple application in C# in which i m writing some ... queries for retriving data from database. ... I want to write queries using stored procedures, ... write stored procedures for postgreSQL. ...
    (microsoft.public.dotnet.languages.vc)
  • Using stored procedures in C# for postgreSQL using ODBC
    ... I am writing one simple application in C# in which i m writing some ... queries for retriving data from database. ... I want to write queries using stored procedures, ... write stored procedures for postgreSQL. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Windows Ada database support.
    ... >>for example) promote the use of Object IDs (basically Row IDs). ... >>Still others don't support the concept at all (MySQL). ... >>within certain database design restrictions). ... PostgreSQL uses an API that opens/creates etc. and returns ...
    (comp.lang.ada)
  • Running queries on large data structure
    ... the money) that parses multiple large text files containing nested data ... data from the PostgreSQL database by different criteria. ... Networks ...
    (comp.lang.python)