Re: Using C# to create stored procedures - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Using C# to create stored procedures
Date
Msg-id 20070403083614.GA8638@svr2.hagander.net
Whole thread Raw
In response to Re: Using C# to create stored procedures  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Apr 03, 2007 at 04:00:17AM -0400, Tom Lane wrote:
> Magnus Hagander <magnus@hagander.net> 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 in trivial
> syntactic details --- its execution engine isn't flexible enough for
> anything truly interesting.  Haven't looked into that for myself
> though ... any comments?

It can certainly host different languages - there are (to me known)
implementations of C#, Visual Basic, JScript, Java, Python, Cobol and
others. These langauges are certainly pretty different. The whole thing is
designed with C# as the *primary* language, so there are definitly parts of
that "leaked through" into requirements for other languages. But it's
doable.

That said, they'll always need *some* changes, and the framework is the
framework regardless of which language (which makes code in cobol.net look
really freakish. Then again, most cobol code look freakish to me).

Haven't tried that one myself, but I can certainly tell that the VB.Net
code is sufficiently VB:ish to make it very hard to read/use for someone
who hates VB. But API calls are teh same, so it's at least *possible* to
read it.

//Magnus


pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Re: Using C# to create stored procedures
Next
From: Tim Perrett
Date:
Subject: PGSQL with high number of database rows?