大家好，又见面了，我是你们的朋友全栈君。
这是我第一次与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
任何想法和帮助……
谢谢!
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/151537.html原文链接：https://javaforall.net
