public Blog MyNotepad : Imho
{
}
Browse by Tags
All Tags »
Data (
RSS)
-
|
You cannot store every date in sql server. The valid range of dates is from 1/1/1753 (1-1-1753) to 12/31/9999 (31-12-9999). The range of the .NET DateTime type is far larger. So before storing a datetime in a sql server database you have to perform a...
|
-
|
Reports are not my favorite part of an application. But to may an end user the reports are the most valuable parts of the system. They are a well presented and clear overview of hours, even days, of work behind the keyboard. So taking good care of the...
|
-
|
Mapping collections in nHibernate is at first sight quite confusing. There are loads and loads of possibilities. The official documentation is somewhat academic. This is good because, once you have got it, it is a clear reference. But it is bad because...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
<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...
|
-
|
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...
|
-
|
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...
|
-
|
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"...
|
-
|
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...
|
-
|
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...
|
-
|
Firebird is an open source database which is pretty popular. Own of the downsides of open source stuff is imho the fragmented support. Firebird is a good example of this. You can use it in Visual Studio 2005, but all documentation is mainly directed inward...
|
-
|
Another story from the app with the sprocs . That was a classical 2-tier CS application which we transformed into an asp.net 1.1 app. Once a year the application has to copy and transform huge amounts of data. This is done by running a batch of stored...
|
More Posts
Next page »