Re: [GENERAL] Using C# to create stored procedures

Andrus, As a C# developer myself, I'd recommend learning pl/pg sql for writring stored procs. It's designed specifically for the kinds of iterations and other operations you need when hanlding a recordset. It's nothing like transact-sql of SQL Server. If you must have full C# integration, then

Re: [GENERAL] Using C# to create stored procedures

> Awhile back I read an article claiming that .NET could only host one > language, or at least only languages that differed merely in trivial > syntactic details --- its execution engine isn't flexible enough for > anything truly interesting. Haven't looked into that for myself > though ... any co

Re: [GENERAL] Using C# to create stored procedures

2007/4/3, Andrus <[EMAIL PROTECTED]>: I needd to re-write a lot of compliatated SQL select statements to run them in server which generate reports. Currently they are running in client side. Client application uses procedural language to do additional processing of data retrieved from PostgreSQ

Re: [GENERAL] Using C# to create stored procedures

Who dreads PL/pgSQL? It's a pretty easy language to learn. Granted, not as easy as one you already know, but I'm not aware of any RDBMS that supports C# as a stored procedure language. I needd to re-write a lot of compliatated SQL select statements to run them in server which generate reports.

Re: [GENERAL] Using C# to create stored procedures

.org Subject: Re: [GENERAL] Using C# to create stored procedures Date: Mon, 2 Apr 2007 10:43:24 -0700 MIME-Version: 1.0 Received: from postgresql.org ([200.46.204.71]) by bay0-mc2-f20.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 2 Apr 2007 10:45:23 -0700 Received: from localhost

Re: [GENERAL] Using C# to create stored procedures

On Tue, Apr 03, 2007 at 04:00:17AM -0400, Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > Both MS SQL Server and IBM DB2 (on windows) supports .net stored > > procedures in C#, VB, or any other .net hosted language. > > Awhile back I read an article claiming that .NET could only

Re: [GENERAL] Using C# to create stored procedures

Tom, Awhile back I read an article claiming that .NET could only host one language, or at least only languages that differed merely in trivial syntactic details --- its execution engine isn't flexible enough for anything truly interesting. Jim Hugunin (creator of Jython, which is Python on Ja

Re: [GENERAL] Using C# to create stored procedures

Magnus Hagander <[EMAIL PROTECTED]> writes: > Both MS SQL Server and IBM DB2 (on windows) supports .net stored > procedures in C#, VB, or any other .net hosted language. Awhile back I read an article claiming that .NET could only host one language, or at least only languages that differed merely i

Re: [GENERAL] Using C# to create stored procedures

Guy Rouillier wrote: > Andrus wrote: >> Last change for this project was 3 years ago. >> So I think that it is dead. >> >> I'm writing application in C#. >> I expected that I can wrote stored procedures in C# also using >> something like mod_mono in Apache. >> >> So it seems that most reasonable w

Re: [GENERAL] Using C# to create stored procedures

Andrus wrote: Last change for this project was 3 years ago. So I think that it is dead. I'm writing application in C#. I expected that I can wrote stored procedures in C# also using something like mod_mono in Apache. So it seems that most reasonable way is to learn dreaded plpgsql language

Re: [GENERAL] Using C# to create stored procedures

Last change for this project was 3 years ago. So I think that it is dead. I'm writing application in C#. I expected that I can wrote stored procedures in C# also using something like mod_mono in Apache. So it seems that most reasonable way is to learn dreaded plpgsql language and write stor

Re: [GENERAL] Using C# to create stored procedures

On Fri, Mar 30, 2007 at 12:19:44PM +0300, Andrus wrote: > Any idea how to write server-side stored procedures in C# for > PostgreSQL database ? There's an old project called PL/Mono , but as far as I know it's unmaintained. You might wa

Re: [GENERAL] Using C# to create stored procedures

On Fri, Mar 30, 2007 at 12:19:44PM +0300, Andrus wrote: > Any idea how to write server-side stored procedures in C# for PostgreSQL > database ? > > In windows .NET 2 framework should be used and in Linuc/Mac/Windows MONO > should be used for this. > > How to install MONO engine as server-side

[GENERAL] Using C# to create stored procedures

Any idea how to write server-side stored procedures in C# for PostgreSQL database ? In windows .NET 2 framework should be used and in Linuc/Mac/Windows MONO should be used for this. How to install MONO engine as server-side language to PostgreSQL ? How to call .NET dlls from PostgreSQL stor