Thanks for the fast reply, Pascal. I am new to the project, and love
it. I hope to contribute to it as well soon. Thanks.
On Nov 3, 4:32 pm, "Pascal Craponne" <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
