Good question! It shows that there is a way, a developer thinks about databases that miiiight be different from the way, a database administrator thinks about it.
For example: You think in an object oriented way whilst a database administrator thinks in a structured, more relational way of storing data in an efficient manner. This is why he will always try to create schemas that reflects fully normalized table structures, foreign key constraints and that sorta stuff.
However,... this will result in people like you to think about what the hell might be the best way to transform the data in a way that allows you to work with it in your environment, i.e. an object oriented - and more over - type safe way. This is where Object Relational Mappers come into play.
No matter what they are called, NHibernate, EF, Linq2Sql,... nah...to hell with it: Maybe even Strongly Typed Datasets: They all do the same: Allow you to work object oriented with data.
If you don't want that, the answer is simple: Don't use a relational database. There are plenty of other fish in the sea... just have a look around and check object oriented databased.
Christian Jacob, Aug 20, 2010
I think what you are looking for is an ORM product. Check this example: http://en.wikipedia.org/wiki/NHibernate
Pankaj Mhatre, Aug 13, 2010