Hi Mr. [EMAIL PROTECTED],
arrays as parameters are unhandled by now. This is a known issue and should
be solved soon (more or less :)).
the only workaround is to include the array literally in the query, ie:
var myProducts = from p in db.Departments
where new [] {1,2,3}.Contains(p.dept_no)
select p;
Pascal.
On Mon, Nov 3, 2008 at 21:41, <[EMAIL PROTECTED]> wrote:
>
> 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.
> >
>
--
Pascal.
jabber/gtalk: [EMAIL PROTECTED]
msn: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
