I have built a DataAccess namespace which has the raw methods that touch SQL Server:
ExecSPRetSC, ExecSPRetDT, ExecSPRetDS, ExecSPRetDR, etc. In my next level up, the BusinessLogic namespace, I have classes that are modeled after tables in my database: DBCountry, DBBanner, DBPerson, DBEmailProfile, etc. The above classes contain simple methods such as: Insert, Update, Delete, SelectOne, SelectAll, GetRandomRow as well as more specialized methods one would expect to see. Francesco >From: "Rolls, Robert" <[EMAIL PROTECTED]> >Reply-To: dotnet discussion <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [DOTNET] OT: N-Tier Design >Date: Fri, 17 May 2002 14:21:20 +1000 > >how many of you guys have raw SQL in the business Business Logic layer - or >do you have coressponding functions in you Data Access Layer i.e > >UI->onClick()->BBL->GetCustomers()->DAL->ExecuteQuery( SQL ); > >or > >UI->onClick()->BBL->GetCustomers()->DAL->GetCustomers() > > >Regards, >Robert Rolls > > >**********************************************************************" >This correspondence is for the named person's use only. It may >contain confidential or legally privileged information or both. " >No confidentiality or privilege is waived or lost by any " >mistransmission. If you receive this correspondence in error, please >immediately delete it from your system and notify the sender. You >must not disclose, copy or rely on any part of this correspondence >if you are not the intended recipient. > >Any views expressed in this message are those of the individual sender, >except where the sender expressly, and with authority, states them to >be the views of Vodafone. > >This email has been checked for viruses. >********************************************************************************************** > >You can read messages from the DOTNET archive, unsubscribe from DOTNET, or >subscribe to other DevelopMentor lists at http://discuss.develop.com. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
