Anatoly Lubarsky Logo
programming, design, integration, games, music

Enterprise Library 2.0 -- DataAccess block

I played a little bit with entlib 2.0 today. Good news is that DbCommandWrapper class is obsolete. Database class works now directly with System.Data.Common.DbCommand class. Instead of:


Database db = DatabaseFactory.CreateDatabase("MyDB");
string procName = "MyPROC";
DBCommandWrapper dbc = db.GetStoredProcCommandWrapper(procName);
dbc.AddInParameter("@myParam", DbType.String, myParam);

We now can write:


Database db = DatabaseFactory.CreateDatabase("MyDB");
string procName = "MyPROC";
DbCommand dbCommand = db.GetStoredProcCommand(procName);
db.AddInParameter(dbCommand, "@myParam", DbType.String, myParam);

What I don't like is the fact that you can not specify the size of the parameter inside AddInParameter in the normal way as you can do in AddOutParameter (the same behaviour exists in Entrperise Library 1.0). Because of this - DataAccess block passes the max size of the specified DbType and performance sucks.


Related Posts:

Thursday, February 16, 2006 1:57 AM

Comments

# re: Enterprise Library 2.0 -- DataAccess block
Yep, and working with blobs is a pain ...

2/16/2006 1:26 PM by AlexB

# re: Enterprise Library 2.0 -- DataAccess block
Surely you can just change the Entlib code to be how you want it and recompile? Isn't that the point of having the source code?

If you didn't you'd probably create your own wrapper classes similar to the Entlib anyway?

9/27/2006 1:12 AM by somebody

# re: Enterprise Library 2.0 -- DataAccess block
2 somebody:
Sure I can create my own wrapper class around SqlCommand class in this case instead of DataAccess application block.

Recompiling Entlib is the pain in the ass, imho. After the following release you should again change and recompile.

9/27/2006 1:25 AM by Anatoly Lubarsky

Login

Subscribe via RSS

Article Categories

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

Archives

(02) January, 2018
(01) June, 2013
(03) March, 2013
(02) February, 2013
(01) July, 2012
(01) April, 2012
(01) September, 2011
(01) August, 2011
(03) May, 2011
(01) December, 2010
(01) November, 2010
(01) October, 2010
(01) June, 2010
(01) May, 2010
(02) March, 2010
(01) January, 2010
(02) December, 2009
(03) September, 2009
(03) August, 2009
(09) July, 2009
(04) June, 2009
(03) May, 2009
(02) April, 2009
(03) March, 2009
(02) February, 2009
(02) January, 2009
(04) December, 2008
(04) November, 2008
(05) October, 2008
(04) September, 2008
(05) August, 2008
(04) July, 2008
(05) June, 2008
(07) May, 2008
(04) April, 2008
(03) March, 2008
(02) February, 2008
(03) January, 2008
(03) December, 2007
(05) November, 2007
(04) October, 2007
(05) September, 2007
(12) August, 2007
(11) July, 2007
(14) June, 2007
(13) May, 2007
(13) April, 2007
(10) March, 2007
(11) February, 2007
(14) January, 2007
(14) December, 2006
(12) November, 2006
(08) October, 2006
(09) September, 2006
(06) August, 2006
(08) July, 2006
(10) June, 2006
(09) May, 2006
(22) April, 2006
(25) March, 2006
(12) February, 2006
(14) January, 2006
(19) December, 2005
(17) November, 2005
(16) October, 2005
(16) September, 2005
(12) August, 2005
(14) July, 2005
(09) June, 2005
(12) May, 2005
(12) April, 2005
(20) March, 2005
(11) February, 2005
(12) January, 2005
(18) December, 2004
(13) November, 2004
(12) October, 2004
(14) September, 2004
(09) August, 2004
(23) July, 2004
(19) June, 2004
(29) May, 2004
(19) April, 2004
(16) March, 2004
(09) February, 2004
(06) January, 2004
(02) December, 2003
(01) November, 2003

Post Categories

.Net and C#
Android
Antispam
App. Development
Architecture
ASP.NET
Blogging
Deprecated Projects
Facebook Platform
Fun
Google
iOS
Javascript
Misc.
MSSQL
Music
My Games
Performance
Roller
Social Networks
Tools
Visual Studio
Web 2.0
WebServices

About Me

linkedin Profile
Recs
Who am I

My Sites

Billy Beet
x2line blogs