Tag: Database
Table names - Singular or Plural
Earlier this morning I tweeted asking for a quick idea of whether to go with singular table names or plural table names. i.e. the difference between having a...
Tip of the Day #4 (Connection Strings in Config files)
From .NET 2.0 onwards a new and improved configuration management system has been put in place. You can now add a <connectionString> element to the config file...
Creating Many-to-Many joins
A topic that comes up from time to time in forums is how to join two tables together when there is a many-to-many relationship. Typical examples include...
DALs and the DAAB
I've been pondering something that was raised in passing earlier this week and that is the relationship between a DAL (Data Abstraction Layer) and the DAAB (...
What is a DAL (Part 4)
As has been mentioned previously, one of the purposes of the DAL is to shield that application from the database. That said, what happens if a DAL throws an...
What is a DAL (Part 3)
In this continuation of my series on the DAL I'm going to show the ability to create several DALs and have a Factory class instantiate the correct DAL based on...
What is a DAL? (Part 2)
In my last post about the DAL I presented a very basic DAL based on a static class. This is fine for small applications, but for larger applications the...
Normalising the data model
Sometimes I see on forums someone who is trying to get some SQL statement to wield data in a particular way but the data model is just thwarting their...
The Normal Forms of Database Normalization
I'm doing a clear out at the moment as I'm getting the house ready to sell - I'm planning to move to West Lothian - and I came across some old notes about...
Types of join
Occasionally there is a post on a forum asking what a certain type of join is all about, so I thought it would probably be good to have a stock explanation to...
Delete the row, or set a deleted flag?
For auditing purposes some database system run without deleting rows from the database - they just flag the row as being deleted and ensure that queries that...
