PaulStovell.NET » The Inline SQL application – Six Months Later

In my opinion (IMO) there is only one proper way to hide database/implementation specific stuff; Use a Data Access Layer (DAL). Whatever lies behind that can be as ugly-bugly as you want to, as long as it returns data according to a set of defined rules. I generally like the “EntityDataManager” naming convention; CustomerDataManager and OrderDataManager. Or use Agent instead of manager, it sounds cooler. We actually have a UIAgent class responsible for converting/formatting data depending on the clients UI.

SPs or Inline? If you have a very complicated, and perhaps old, database SPs might make more sense. Just to hide the worst of the database stuff from the DAL. But you can do alot with views too…

PaulStovell.NET » The Inline SQL application – Six Months Later

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>