Add JSON support

[paule96]

Add JSON support

[paule96]

Looks quite good. Incredible how fast you implemented that 😯
So you decided to create DynamicTypes out of each element in the JSONArray and then query on it.
I guess because it's the easiest way todo right now. Nice to see.

[StefH]

Thanks for the idea.

A way to implement this is to create projects which depend on System.Text.Json and Newtonssoft.Json which provide extension methods like Where on JsonDocument and JObject.

[paule96]

@StefH you mean something like:

public static IQueryable<T> Where(this IQueryable<T> source, string expression){
   // TODO: parse expression
  // TODO: Rebuild all Property access expression to access `GetProperty(propertName)`
  // TODO: return result
} 

[StefH]

More like this:

public static IQueryable<T> Where(this JsonDocument source, string expression)
{
}

Or

public static IQueryable<T> Where(this IObject source, string expression)
{
}

[paule96]

but shouldn't the base of the Extension method be something enumerable?
Also a JsonDocument can also be {}, that would result in an error I guess.
Shouldn't it be more like:

public static IQueryable<ArrayEnumerator> Where(this ArrayEnumerator source, string expression)
{
}

Then you can access over Current the current JsonElement and test the expression.

and on the user code side it would look like:

var jsonDocument = JsonDocument.Parse(@"[
    {
        ""first"": 1,
        ""City"": ""Paris"",
        ""third"": ""012-04-23T18:25:43.511Z""
    }]");
if(jsonDocument.RootElement.ValueKind != JsonValueKind.Array){
   throw new Exception("Must be an array");
}
jsonDocument.RootElement.EnumerateArray().Where("City ==\"Paris\"");

That would also allow us to use the extension method to use it inside of a JSON document.

[paule96]

Hm I'm also not sure if the extension of Where is the correct idea. If I understand it correctly that would mean that we need to reimplement the ExpressionParser for it. Wouldn't it be better to allow, that the currently private methods of the ExpressionParser can be overwritten? In this case the ParseMemberAccess method. Then we could create kinda easy second project and make a special implementation of ParseMemberAccess for JsonElement.

But maybe I don't understand the project structure well enough jet.

[StefH]

#791 WIP...

[StefH]

I'm adding all methods and also working on System.Text.Json implementation. Can you take a look at the PR (WIP)?

[paule96]

Yes I will review today :)