In my last post I discussed wrapping up the two core objects of nHibernate, the session manager factory and the session, in a helper class. At the end of the story I briefly mentioned how to use helper objects in a repository. In this post I am further exploring the actual database actions of the helper...

In a relative short span of time nHibernate has become a major member of my toolbox. It has become the way to work with a database, not only a small hap-snap apps but it's also making big strides into a constantly evolving system I'm working on. Setting up nHibernate several times has given me...

This post is an extended and revised version of " Back to basics, just reading some data from a DB ". Feedback on that provided more than enough inspiration for this one. Are you already drowning in the enormous amount of TLA's, tools, utilities, methodologies and whatever else ? Let's...

<update>A revised and extended version of this post also handles creating a customer domain object, which does have some behavior. It does also covers some methods to make the behavior of the datareader a little cleaner. The post can be found here </update> Are you already drowning in the...

This is another story from the app with the sprocs , an app where a lot of the business logic (BL) is inside a large number of stored procedures (sprocs). These are written by the domain expert himself. As the BL changes the app changes as well, which leads to change of the table structures (the database...

The term RAD is more or less a hot topic on Codebetter. It started with a "RAD kills" post by Jeffrey which lead many people to chime in. As I almost glorified RAD it's time to write something more elaborate on how I think you can work with RAD without making a mess out of it. This will dance around...

I was given a nice little Pocket PC application which worked well but took far too long to start. My first code walk through was a WTF. It was the common scenario, a well known major consulting firm producing code which demonstrated they did not quite understand what they were doing. But instead of just...

A sql select query looks something like this : SELECT MyCol FROM MyTable WHERE MyCol = 'A' ORDER BY Mycol It has a couple of parts SELECT FROM specifies the output columns WHERE specifies the rows ORDER BY specifies the sort order of the output rows What puzzles me is that the order of these three parts...

If SQL had known attributes I should have decorated my Like query with [ AirCode ]. Several comments questioned wheter and how it was vulnerable to a sql-injection attack. Well, the aircode version is. The original is harder to break. The vulnerable one : orgSql = "SELECT id, Info FROM Table1"; sqlDataAdapterBuildSql...