Question: when quering jsonb, is it possible to define the properties in camcelcase ( JsonProperty, Column, something else)?

[andreas-soroko]

Hey,

imagine we have 2 models like

public class Model1 {
    public Guid Id {get; set;}
    //....
    [Column(TypeName = "jsonb")]
    public Model2 Data {get;set;}
}

public class Model2 {
    //....
    public string SomeField {get;set;}
}

and model2 gets serialized with camelcase settings

the following call

string someValue = "";
Model1.AsNoTracking().Where(s => s.Data.SomeField == someValue).ToListAsync();

creates the following query

SELECT u.id, u.data
      FROM model1 AS u
      WHERE u.data->>'SomeField' = @__someValue_0

but right would be

SELECT u.id, u.data
      FROM model1 AS u
      WHERE u.data->>'someField' = @__someValue_0

is there a way to tell the provider he should use camelcase ?
i tried jsonproperty ( from newtonsoft ) and also ColumnAttribute but booth gets ignored

[roji]

Duplicate of #1107