Maison > Article > développement back-end > 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 )
以上就是SqlCommand.DeriveParameters failed的内容,更多相关内容请关注PHP中文网(www.php.cn)!