I don’t know about you, but I find it a pain to call stored procedures from code. Either I end up writing way too much code to specify each SqlParameter explicitly, or I use a tool like Microsoft’s Data Access Application Block’s SqlHelper classj to pass in the parameter values, which requires me to remember the correct parameter order (it actually supports both methods of calling a stored procedure). What a pain! What I need is a strongly typed stored procedure. Something that’ll tell me which parameters to pass and will break at compile time if the parameters change in...
NUnit 2.4 introduces a really nice programming model they call Constraint-Based Assert Model. I believe MbUnit 2.4 will also have this. I really like this approach to building asserts because it reads almost like English. Assert.That( myString, Is.EqualTo("Hello") );
Look at that fine piece of prose!
I’m so enamored of this approach I thought I’d try to bring it to Subsonic. Here is an example of two existing approaches to create a Query in Subsonic.
new Query("Products").WHERE("ProductId < 5");
new Query("Products").WHERE("ProductId", Comparison.LessThan, 5);
Now what don’t I like about these? Well in the first one, there’s no intellisence to guide me on making sure...
Real quickly, check out our brand spanking new build server. Notice anything different? No? Good! Hopefully everything is working just fine, but faster. As you know, I’m ever the optimist. What’s that trite phrase, “When the crap hits the fan, make lemonade”? Or something like that. So in this tragedy becomes triumph story, the bricking of my tiny little home built build server caused me to start thinking of a more permanent solution. In steps Eric Kemp, Rob Conery’s right hand man (in the clean sense of the idiom) on the Subsonic team. He converted the VMWare image to run on...
Rob Conery just announced that Beta 1 of SubSonic 2.0 is ready for your immediate data access needs. He’s looking for beta testers (open to anyone and everyone) to make sure this release is rock solid. I may attempt to claim a significant contribution, but do not believe me. I only contributed a teeny-tiny amount of code to this release. I am using a small bit of Subsonic in a current project (just using it to generate Stored Procedure wrappers since the existing database already has a legacy data model and stored procedures to work with). While I’m talking about...