Saturday, October 21, 2006
Stored Procs for DBs without Stored Procs?

Someone just asked me a good question: Since I said in a previous blog post that we use SQL Everywhere for unit testing instead of SQL Server [in certain scenarios], what exactly do we do with stored procedures? After all, SQL Everywhere does not support sprocs.

The answer is that we use a concept we call "Stored Procedure Facade", which allows us to simulate stored procedures for systems that normally do not support it. This is part of our Milos Solution Platform product. How do we do that? Well, check out this article of mine, which we had in the last Tablet PC CoDe Focus issue: http://www.code-magazine.com/Article.aspx?quickid=0512112. Scroll down and search for the word "facade" to find the details. (Use of Milos not required).

Talking about CoDe Focus issues: We are working on several more focus issues. To make sure you get those issues completely free of charge, tell us which ones you are interested in here.