Hi,
Before even suggesting anything i would want to understand that , are you talking about 3 layers/Tiers..
I am assuming that you want to follow 3 layer approach, in that case from the UI make the call to get
public void Get()
{
BL.Get();
}
In the BL, Get the data...in case of any exceptions based on the requirement log the details either to file,db etc...I would suggest you to use Enterprise library 5, since it gives you all the feature by default with just few configurations.
public result Get()
{
DAL.Get();
}
In the DAL, based on the business functionality, invoke the query, Now again here either you can make use of T-Sql or Stored procedure, my preference would be to use stored procedure since it gives you lot of flexibility in terms of maintainability,security,modularity etc.
In DAL also i would suggest you to use the Enterprise library.
Dal
public result Get()
{
}
I hope this helps!.
Regards,
-Vinayak