beyond-code-github / LinqToQuerystring

A lightweight subset of oData querystring conventions that works with any IQueryable
MIT License
136 stars 63 forks source link

IQueryable<dynamic> is it supported? #42

Open BakriBadawi opened 10 years ago

BakriBadawi commented 10 years ago

I have an IQueryable and i which to filter it but the problem when I use LinqToQuerystring I got this exeption No method 'get_Item' exists on type 'System.Object'.

here is my code [HttpGet] public PageResult GetforGrid(ODataQueryOptions options, string data1) { try { DynamicTableRep dynamicTableRep = new DynamicTableRep(data1); dynamic tbltype = dynamicTableRep.GetType();

            var dynamicQueryable = dynamicTableRep.GetAllAsQueryable();
            IQueryable<dynamic> qResult = dynamicQueryable.LinqToQuerystring(this.Request.RequestUri.Query, true);

            var results = options.ApplyTo(qResult);
            return new PageResult<dynamic>(results as IEnumerable<dynamic>,
                Request.GetNextPageLink(), Request.GetInlineCount());
        }
        catch (Exception ex)
        {
            Logs.Log(ex);
            return null;
        }
    }

1 2

beyond-code-github commented 10 years ago

Hi there,

I'll need to get back to you on whether or not use of dynamic is possible. At this time it is not officially. supported

I know for sure that you can use LinqToQuerystring against an IDictionary<string, object> so if the data structure underlying the dynamic object can be put into that form then you may be able to do things that way.

Pete

shivu333 commented 9 years ago

@BakriBadawi may i know the solution for this error?

BakriBadawi commented 9 years ago

Until now i couldn't find a solution for this error.

shivu333 commented 9 years ago

@BakriBadawi for me it is working fine now, I am not sure, how it It looks like problem with URL. I will try to reproduce it & let you know if any luck. can you share your url pattern to examine?

BakriBadawi commented 9 years ago

@shivu333 this is smple of the URL ?$filter=substringof(%27a%27,Prefix)&$inlinecount=allpages&$top=10&$skip=0

Jogai commented 8 years ago

Well, now I get this feeling: All long help threads should have a sticky globally-editable post at the top saying 'DEAR PEOPLE FROM THE FUTURE: Here's what we've figured out so far ...'

beyond-code-github commented 8 years ago

Oh nooo! I'll admit I haven't had the time to invest in this recently, my comment from 2014 should still be relevant though.

Jogai commented 8 years ago

Thanks for the quick answer ;) It was more directed to @shivu333 because its working for him, but we dont know how...