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。

错误原因：

使用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)