oracle的executereader,尝试使用Oracle Data Access ODP.NET 11.2执行ExecuteReader()时出现InvalidOperationExceptio…

这是我第一次与Oracle合作,而且我们都讨厌在你使用特定模型的同时使用外国产品,尽管这是我们的工作,我们必须做到.

现在我已经安装了Oracle 11g,并复制并引用了Oracle.DataAccess.dll,创建了一个方法,用于打开连接并尝试从服务器上创建的视图中检索某些对象.

方法:

public BindingList GetHeaderReceivers()

{

try

{

using (OracleConnection db = new OracleConnection(BaseDataAccess.ConnString))

{

string cmdText = “select * from p_customer t”;

BindingList headerReceivers = new BindingList();

OracleCommand cmd = new OracleCommand(cmdText) { CommandType = CommandType.Text };

db.Open();

OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (reader.Read())

headerReceivers.Add(HeaderReceiver.GetInstance(reader));

CustBranchRepository rep = new CustBranchRepository();

headerReceivers.ForEach(p => p.DetailsBranch = rep.GetDetailReceivers(p.Id));

reader.Close();

db.Close();

return headerReceivers;

}

}

catch (Exception ex)

{

ExporterLogger.Log(ex);

return null;

}

}

现在,当ExecuteReader()提交时,我得到了这个InvalidOperationException.

Operation is not valid due to the current state of the object.

StackTrace:

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

at Exporter.Boss.DataAccess.CustomerRepository.GetHeaderReceivers() in …Exporter\Exporter.Boss.DataAccess\CustomerRepository.cs:line 25

任何想法和帮助……

谢谢!