I have posted this question in some linq to sql forums, but the same
logic doesn't seem to quite work with dblinq. I am using the oracle
provider.
In my application I am sending a string of employee departments like:
"1,2,3"
I want to write a linq to sql query where e.dept_no is equal to 1, 2,
or 3. Can you do this with linq.
In sql the query would be
select * from employees e where e.dept_no in (1, 2, 3)
I have tried:
int[] departments = {1,2,3};
var myProducts = from p in db.Departments
where departments.Contains(p.dept_no)
select p;
And I get: System.ArgumentException: S0548: Can't analyze Contains()
method
Does that mean that the contains logic has not yet been implemented
for dblinq?
Thanks for your help.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
