Noocyte’s Weblog

February 28, 2008

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

Filed under: Link, Work — Tags: , , — noocyte @ 10:07

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

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: