poshcodegen

If you are interested in accessing databases and want to access stored procedures you might have found New-StoredProcFunction from Steven Murawski at http://poshcode.org/1011.



Meanwhile it became a real project an you find it at http://code.google.com/p/poshcodegen/.



As concrete object, it is as generator that produces wrappers to calls to stored procedures as PowerShell functions and those are really useful. Taken an abstract you it is just one example of a generator. Perhaps soon we will see many more.



At the moment the focus lies on SQL-Server and Version 2005 or later is required. I'm just testing a way to use it with SQL Server 2000 too.



Next I'll create an Oracle twin. (Bye bye ref cursor hide under the layer thinking runs better without you).



The first target are pure procedures, not packages. When you want to create application that run as well on SQL-Server as on Oracle you better forget creating your own packages at ones.



Procs in packages come later.

Bernd