SqlCommand.DeriveParameters failed

SqlCommand.DeriveParameters failed because the SqlCommand.CommandText property value is an invalid multipart name SELECT * from tableA , the current limit of 4 is insufficient。 错误原因：

SqlCommand.DeriveParameters failed because the SqlCommand.CommandText property value is an invalid multipart name "SELECT * from tableA", the current limit of "4" is insufficient。

错误原因：

使用Enterprise Library进行数据库操作时，如果直接使用sql 语句而非存储过程，一定要用重载方法：
_db.ExecuteDataSet(CommandType type,String sql)

而不是：

public virtual DataSet ExecuteDataSet(

 string storedProcedureName,

 params Object[] parameterValues

)

详细介绍：点击打开链接

或者通过sql，获取到DbCommand，再执行：

ExecuteDataSet重载方法如下：

Database.ExecuteDataSet Method (DbCommand)

public virtual DataSet ExecuteDataSet(

 DbCommand command

)

Database.ExecuteDataSet Method (CommandType, String)

public virtual DataSet ExecuteDataSet(

 CommandType commandType,

 string commandText

)

Database.ExecuteDataSet Method (DbCommand, DbTransaction)

public virtual DataSet ExecuteDataSet(

 DbCommand command,

 DbTransaction transaction

)

Database.ExecuteDataSet Method (String, Object[])

public virtual DataSet ExecuteDataSet(

 string storedProcedureName,

 params Object[] parameterValues

)

Database.ExecuteDataSet Method (DbTransaction, CommandType, String)

public virtual DataSet ExecuteDataSet(

 DbTransaction transaction,

 CommandType commandType,

 string commandText

)

Database.ExecuteDataSet Method (DbTransaction, String, Object[])

public virtual DataSet ExecuteDataSet(

 DbTransaction transaction,

 string storedProcedureName,

 params Object[] parameterValues

)