Is it possible to use JSON with Gridify, ApplyFiltering, GridifyQuery etc? More details below.

[aerondight997]

Assuming that I use Entity Framework Core, is it possible, for example, to pass JSON that is similar to this one '{"name": "John", "hobbies": ["Movies", "Football", "Hiking"]}' and perform a search through any of the provided extension methods?

The reason I am asking is that I am trying to avoid Entity-Attribute-Value pattern in one of the projects I am working on and would really like to use JSONB column in PostgreSQL in order to store product specifications (each product will have custom properties and there might be a lot of different types of products depending on requirements). I would use only one column for these specifications and obviously store all the data in JSON format, including nested properties if needed. Gridify looks like a very good tool to perform filtering on the products, however I am unable to find this use case covered anywhere except for the Client Library example, but it only shows the creation of JSON, not consumption by the extension method.

Can anyone help me out? Thanks in advance. :)

[alirezanet]

Hey @aerondight997,
Gridify doesn't currently support searching JSON files, but that sounds like a great idea for an additional extension library.
Since Gridify is mainly focused on LINQ queries, if you can structure your query using LINQ, it should work with Gridify as well.

[aerondight997]

That would genuinely be a fantastic addition to the library. JSON seems to be gaining a lot of popularity as solution that replaces Entity-Attribute-Value pattern.

I am unsure of how I would structure the query, since there are some specific operators that increase performance of the query on JSON, I will probably need to combine PostgreSQL queries themselves and Gridify. Its a good learning opportunity for me.

[alirezanet]

If you managed to do it via LINQ, please share your LINQ query so I would take a look if we can support it or not.

[aerondight997]

I will try my best, can't guarantee anything though but if I do it I will post it.