SqlCommand.DeriveParameters 失敗

錯誤訊息如下：

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 Libra錯誤原因：

使用回載方法_db.ExecuteDataSet(CommandType type,String sql)

而不是：

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

，或點擊開啟連結到連結

ExecuteDataSet重載方法如下：

public virtual DataSet ExecuteDataSet(
	DbCommand command
)

Database.ExecuteDataSet Method ( CommandType, String)

public virtual DataSet ExecuteDataSet(
	CommandType commandType,
	string commandText
)

Database.ExecuteDataSet Method (DbCommand, DataSet Method (String, Object[])

public virtual DataSet ExecuteDataSet(
	DbCommand command,
	DbTransaction transaction
)

Database.ExecuteDataSet Method (DbTransaction, CommandType, String)

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

public virtual DataSet ExecuteDataSet(
	DbTransaction transaction,
	CommandType commandType,
	string commandText
)

 以上就是SqlCommand.DeriveParameters failed的內容，更多相關內容請關注PHP中文網（www.php.cn）！