That doesn't sound like business logic to me. Especially if there's a 1-1 mapping between "business logic" classes and database tables.
I abstract the data access layer into routines called "AddCustomer", "DeleteCustomer" etc and then implement two versions of this interface. One is a mock object (www.mock-objects.com) which returns dummy data and the other is one which actually queries the database. Richard > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]]On Behalf Of > Francesco Sanfilippo > Sent: 17 May 2002 16:20 > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] OT: N-Tier Design > > > 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. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
