Data Access Application Block in 3.0 - Need Some Help

Apr 23, 2007 at 9:50 PM
I need some help - I'm new to .Net and am trying to use the newest Data Access Application Blocks (April 07) in my first project. I'm not using Application Block configuration - one can supposedly define the database object directly in code using a config string (comes from the app config file in this case) and that's what I'm trying to do.

I have the following in my Data Access Layer module:

using DAAB = Microsoft.Practices.EnterpriseLibrary.Data;
using DAABSQL = Microsoft.Practices.EnterpriseLibrary.Data.Sql;

dbConnString = ConfigurationManager.AppSettings"ConnectionString";
DAAB.Sql.SqlDatabase VaultReconDB = new DAAB.Sql.SqlDatabase(dbConnString);

I'm trying to return a data reader using a stored proc, but Intellisense does not list DbCommand (which is shown as the command object type in the Help info) to allow me to specify my stored-proc name. This makes me think I'm doing something invalid - I've tried qualifying my command-setup statement every way I can see through Intellisense.

I'm trying to get to something like this:
DbCommand SPCommand = db.GetStoredProcCommand("GetMarketList");

Can someone let me know what I may be doing wrong? Thanks in advance!!
Apr 23, 2007 at 11:52 PM
Hi texasprd,

You're probably looking for the Enterprise Libary forum. This is the CodePlex site discussion forum.

Find it here:
Apr 24, 2007 at 1:29 PM
Thanks, and sorry - I will repost in that forum. This forum was the only one I could find yesterday when I tried to go through the Enterprise Library Community pointer via Start-Programs-etc.

Thanks again.