During this long flu season I thought it was interesting that every major DB is jumping on the Embedded CLR idea.  This of course is not a new idea, Embedded Java has been around for a while, but it is great news for .NET developers.

Oracle CLR support

DB2 CLR Support

PostGreSQL CLR Support

I would expect other vendors are not far behind (I wonder if Sybase will join the list!)

Now the question is how portable are these stored procedures.  Somehow I don’t think they are going to be a portable as developers would like.  I have done some work with MS SQL, PostgreSql and Oracle with ADO.NET and the providers make the code very portable.  If only the Sprocs were as portable!

Other PostgreSql Information:

PostgreSQL .NET Data Provider

PostgreSql 8 supports Windows Natively

Good PostgreSql Links