Linq Query with array as parameter

Question

I know this question is similar to others but they have not provided me with an answer so far. I have an array of numbers in javascript which i pass back to my controller, Each number is an id for an object in the db which i will pull out and load into a jqgrid. The issue im having is with the query. I pass back the array and then call the function below in my repository.

public IQueryable<IOSSample> getSamplesForSamplePoints(Array samplePointIds)
    {
        return (from u in context.IOSSamples
                where samplePointIds.Contains(u.IOSSamplingPointId)
                select u);
    }

However the function does not like me using contains so im not sure how to go about this, any help would be much appreciated.

what is the error exactly? Maybe you need to type your parameters, try to use ICollection<int> instead of Array? — Bruno
– Bruno, Commented Sep 8, 2015 at 14:30
Is the Array of samplePointIds the same type as u.IOSSamplingPointId? — deadwards
– deadwards, Commented Sep 8, 2015 at 14:31

Bruno · Accepted Answer · 2015-09-10 15:22:48Z

3

If u.IOSSamplingPointId is an int, you need to use a typed array as your function input parameter:

public IQueryable<IOSSample> getSamplesForSamplePoints(ICollection<int> samplePointIds)
{
    return (from u in context.IOSSamples
            where samplePointIds.Contains(u.IOSSamplingPointId)
            select u);
}

edited Sep 10, 2015 at 15:22

answered Sep 8, 2015 at 14:34

Bruno

4,6757 gold badges65 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Linq Query with array as parameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related