How to get the parameters for a stored procedure using Enterprise library with generic database

Question

When i use this, i get the following exception

Parameter discovery is not supported for connections using GenericDatabase. You must specify the parameters explicitly, or configure the connection to use a type deriving from Database that supports parameter discovery.

Is there a right way other than this procedure.

EDIT

Database db = CustomDbFactory.CreateDataBase(connStrName); 
DbCommand command = db.DbProviderFactory.CreateCommand(); 
command.CommandText = @spName; 
command.CommandType = CommandType.StoredProcedure; 
db.DiscoverParameters(command); 
...

if you provide the code and configurations we may be able to help — Jason Meckley, Dec 21 '11 at 13:27
please edit your original post and provide the code and configuration there. placing it in the comments isn't helpful. — Jason Meckley, Dec 21 '11 at 14:39
@JasonMeckley: Done editing the question to add the code for your reference — Saravanan, Dec 22 '11 at 04:29

score 0 · Accepted Answer · answered Dec 22 '11 at 04:45

0

This feature is supported only the SqlDatabase objects only. Hence, instead of calling the DiscoverParameters on a GenericDatabase, I had to call it from a SqlDatabase.. Specifics Issue.

answered Dec 22 '11 at 04:45

Saravanan

7,637
5
41
72

How to get the parameters for a stored procedure using Enterprise library with generic database

1 Answers1

Linked