Re: BLL & DAL: How are they different?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

<zhaojk@xxxxxxxxx> wrote in message news:d6237cfa-f310-4780-b333-063b0a99ffb6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Question: I suppose colParamaters should always be an array of string,
such that when we add more parameters to a stored procedure in the
RDBMS, we don't have to modify the code in the DAL, right?

Depends on the RDBMS but, for SQL Server, I use the SqlParameters collection:
http://www.google.co.uk/search?sourceid=navclient&hl=en-GB&ie=UTF-8&rlz=1T4GZEZ_en-GBGB252GB252&q=SqlParameters

BTW, do DAL mostly have static methods?

Depends... The Microsoft DAAB does, and mine does because I based it on the Microsoft one...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

.

Relevant Pages

  • Re: BLL & DAL: How are they different?
    ... stored procedure names which are used in the DAL. ... So long as your DAL is capable of interfacing with SQL Server (either because that's the only RDBMS it supports or because it uses a factory pattern), you should simply be able to drop your DAL into both projects without modification. ... foreach (SqlParameter objSqlParameter in plstSqlParameters) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Working mostly with Stored Procedures in RDBMS.
    ... and Triggers in an RDBMS. ... Can a Trigger call a Stored Procedure? ... the DB it's easier - although some tools can handle the DB and clients ...
    (comp.databases)
  • Working mostly with Stored Procedures in RDBMS.
    ... and Triggers in an RDBMS. ... Writing an INSERT query in a Stored ... Can a Trigger call a Stored Procedure? ...
    (comp.databases)
  • Re: BLL & DAL: How are they different?
    ... And what if you aren't a stored procedure person...? ... the DAL code only, right? ... Depends on the RDBMS but, for SQL Server, I use the SqlParameters ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Retrieving Stored Procedure Returns
    ... >CallableStatement after executing a Stored procedure. ... The RDBMS is MS ... the name spGetNextBatch makes the think there's an actual return value ...
    (comp.lang.java.programmer)