Anatoly Lubarsky Logo
MSSQL, .NET, Design. Life and Music

Enterprise Library DAAB: AddParameter vs. AddInParameter

I'm playing a bit with Entlib. now. Let's say I'm using it a lot actually :). Speaking of Data Access Block in Enterprise Library I'm coming to conclusion that it is not productive to use AddInParameter construction in Database object because:


  1. It does not support parameter size causing ADO.NET pass the max allowed for the specified type.
  2. There is no support for parameter InOut direction (aka AddInOutParameter ?) which I find very useful lately.

I'm going to use AddParameter instead of AddInParameter, despite that it is a bit less readable. Like so:


db.AddParameter(dbCommand,
    "@ProductId",
    DbType.Int32,
    4,
    ParameterDirection.InputOutput,
    true,
    0,
    0,
    null,
    DataRowVersion.Default,
    review.ProductId);

Related Posts:

Saturday, March 25, 2006 8:39 PM

If your feedback doesn't appear right away, please be patient as it may take a few minutes to publish.

Post a Comment

Protected by CAPTCHAEnter the code you see
Name (*)  
E-mail (*)  
Url
Remember

Comment (*)  

Login

Fosimo on CNET Download.com!
RSS
Add to Google Add to My Yahoo! Subscribe with Bloglines

Article Categories

.Net Framework
ASP.NET Tips
C# Win32 API
HTML, CSS, Web
Javascript Tips
MSSQL Tips
System
System.Net
WebServices

Archives

(01) October, 2008
(07) September, 2008
(09) August, 2008
(05) July, 2008
(05) June, 2008
(07) May, 2008
(06) April, 2008
(03) March, 2008
(02) February, 2008
(04) January, 2008
(03) December, 2007
(05) November, 2007
(06) October, 2007
(07) September, 2007
(13) August, 2007
(11) July, 2007
(14) June, 2007
(16) May, 2007
(14) April, 2007
(10) March, 2007
(17) February, 2007
(21) January, 2007
(17) December, 2006
(14) November, 2006
(13) October, 2006
(13) September, 2006
(14) August, 2006
(12) July, 2006
(11) June, 2006
(12) May, 2006
(22) April, 2006
(36) March, 2006
(14) February, 2006
(14) January, 2006
(20) December, 2005
(17) November, 2005
(17) October, 2005
(17) September, 2005
(14) August, 2005
(18) July, 2005
(12) June, 2005
(17) May, 2005
(13) April, 2005
(22) March, 2005
(12) February, 2005
(14) January, 2005
(19) December, 2004
(15) November, 2004
(13) October, 2004
(16) September, 2004
(12) August, 2004
(29) July, 2004
(25) June, 2004
(33) May, 2004
(26) April, 2004
(18) March, 2004
(11) February, 2004
(07) January, 2004
(03) December, 2003
(02) November, 2003

Post Categories

.Net and C#
Antispam
App. Development
Architecture
ASP.NET
Blogging
del.icio.us
Fosimo
Fun
Google
Javascript
Misc.
MSSQL
Music
Performance
Roller
Social Networks
Tools
Visual Studio
Web 2.0
WebServices
Yahoo

About Me

linkedin Profile
Recs
Recs Books
Who am I

My Sites

onecone
x2line blogs