I am using Linq2Oracle connecting to Oracle 9i
I am receiving this error when I try to append a where clause to an IQueryable.
I Have a WorkOrder base Table, and I created an inherited OperationalWorkOrder class with discriminator of WorkOrderType=1
The following linq query works:
Code: Select all
IQueryable wo = from w in context.WorkOrder
where WoNumber == "SAL1234"
select w as OperationalWorkOrder;
...
foreach(...)//all ok
{
}
Code: Select all
IQueryable wo = from w in context.WorkOrder
select w as OperationalWorkOrder;
IQueryable SingleWO = wo.where(w => w.WoNumber == "SAL1234");
foreach(...) //Fails here.
{
}
I found a reference to this error on MS forums, but they indicate it was fixed for Linq2SQL in a previous version.
Any insight into this issue would be greatly appreciated.