Being sick of all the hassles it took to keep my own server up and running I've moved it to a public hoster . Which does offer asp.net hosting but like many others code is only given medium trust . My site was using nHibernate. That does have serious problems under this trust level. I've been...

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...

In this post I'm going to take a closer look at XSD, the XML schema language. Like most of you I came into touch with XSD through.NET datasets and for quite some time I didn't quite get the perspective it deserves. Before exploring XSD itself I'll take a brief historical tour and will kick...

As a First answer: nothing at all. I've seen a number of demo's, seen people work with it, read about it and I like it. Quite a nice tool. My problem is that I cannot work with it myself. I have "Visual Studio Team system for workgroups" edition. Which includes many team server tools...

Just like last time getting the Firebird database working on my new machine was a long way of trial and error. I have Visual Studio 2005, installed sp1 and it’s running on Vista. Installing FB has become easier but support is still very fragmented. Worse is that essential parts contain typos which...

The connection string to a database should never be hard coded in your application. There is (almost) always a difference between the development and production database server. Besides that IT management should have an easy way to change the configuration. Part of this has been automated by the wizards...