> > The dal exposes more details therefore allows you to do more. However, by > exposing all these details, you get a tool that is harder to use (in the > sense that you have to repeat yourself) for all the other scenarios where > you don't need such details. >
But what are examples where you need to repeat yourself with the DAL (but not with an ORM)? I've never seen anyone use relational algebra in a real world project. > > That doesn't mean the tools you use aren't taking advantage of its principles (or failing to do so when they could be). > I've also learned in my experience that database normalization sometimes >> has to go in order to get, for instance, performance. >> > Are you suggesting an ORM handles denormalization more easily than the DAL? You also have to map data from the dal into you business layer by hand. >> > How so? Anthony