|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Using stored procedures in C# for postgreSQL using ODBCHello,
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 nishi.hi***@gmail.com wrote:
> Hello, PostgreSql uses 'functions' which are the stored procedures of> > 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. 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#) ------------------------------------------------------------------------ |
|||||||||||||||||||||||