The sql-server part of poshcodegen is nearly complete. And I'm using it in daily work.
The oracle part is a bit harder. Revisiting some old code I stumbled too often about #ToDo Comments. So its going on a little slower than expected.
Thinking that you prefer viewing at some real code, I post one of the Orcale test functions in Poshcode. Perhaps someone finds it there, just as I found the orginal http://poshcode.org/1011 from Steven Murawksi.
If your daily job is running ad hoc queries and stored procedure calls against SQL-Server Databases you may find something useful.
If you know how to access another RDBMS please join the project.
If you find a bug please send feedback. This is a complex area and it was too easy to introduce faults. We don't have automatic testing yet, but there is a rather complete set of test stored procedures for SQL-Server and for Oracle.
The second pitfall: too often the functions run perfectly too hours, but starting a fresh PowerShell I get errors. Often this is causes by the need to keep our own connection strings secret.
But now something useful, as far as you use ORCLE:
download | new post
Microsoft Script Explorer: Next Steps
vor 1 Monat