Re: Using C# to create stored procedures

On Tue, Apr 03, 2007 at 04:00:17AM -0400, Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)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