SqlCommand.DeriveParameters failed

The error message is as follows:

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

Error reason:

When using Enterprise Library for database operations, if you use SQL statements directly instead of stored procedures, you must use the overload method:
_db.ExecuteDataSet(CommandType type, String sql)

instead of:

public virtual DataSet ExecuteDataSet(
	string storedProcedureName,
	params Object[] parameterValues
)

Detailed introduction: Click to open the link

or get the Db through sql Command, then execute:

ExecuteDataSet overload method is as follows:

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.Execute DataSet 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
)

The above is the content of SqlCommand.DeriveParameters failed. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!