SqlCommand.DeriveParameters failed
程序员文章站
2022-05-31 18:06:23
...
错误信息如下:
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)!
上一篇: Fiddler如何抓取手机APP数据包
下一篇: php中数组首字符过滤代码
推荐阅读
-
解析Neatbeans(常见错误) build-impl.xml:305: Compile failed
-
Maven项目部署到Jboss出现Failed to create a new SAX parser
-
Android 中Failed to read key from keystore解决办法
-
丢失Android系统库或者Conversion to Dalvik format failed with error 1错误的解决方法
-
Android模拟器"Failed To Allocate memory 8"错误如何解决
-
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]的解决方法
-
MySQL Daemon failed to start错误解决办法
-
Win7系统笔记本电脑开机蓝屏显示Boot Failed该怎么办?
-
Android模拟器"Failed To Allocate memory 8"错误如何解决
-
SpringBoot启动报错Failed to determine a suitable driver class