Read some json values, Common Language Runtime detected an invalid program. about linq2db HOT 5 OPEN

SqlFn.JsonValue already exists inside of linq2db. No need to add a new function.

from linq2db.

Can you try to use this extension? #1230 (comment)
There is no need to define new mapping schema.

from linq2db.

Can you try to use this extension? #1230 (comment) There is no need to define new mapping schema.

Суть в том, что мне нужно динамически, из 1000 сохраненных в колонке с json значений прочитать только 5 параметров, заранее не известных.

Именно поэтому я пытаюсь использовать этот код

const int readColCount = 5;

                foreach (var col in Enumerable.Range(0, readColCount))
                {
                    var colExpr = $"JSON_VALUE({nameof(TestJsonWrite.JsonData)}, '$.\"{col}\"') AS '{col}'";
                    fm.Entity<TestJsonRead>()
                        .Property(x => Sql.Property<float?>(x, col.ToString()))
                        .IsExpression(row => Sql.Expr<float?>(colExpr), isColumn: true)
                        ;
                }

from linq2db.

SqlFn.JsonValue already exists inside of linq2db. No need to add a new function.

I know, but this is just an example, in fact, my solution should work with various databases, including Sql Server, Postgres, SQLite.

If linq2db has uniform support for this, it will be great.

from linq2db.

Addition
If i replace the float? to string?, then the error text changes to
"Dynamic column setter is not to be called."

`

foreach (var col in Enumerable.Range(0, readColCount))
{
var colExpr = $"JSON_VALUE({nameof(TestJsonWrite.JsonData)}, '$."{col}"') AS '{col}'";
fm.Entity()
.Property(x => Sql.Property<string?>(x, col.ToString()))
.IsExpression(row => Sql.Expr<string?>(colExpr), isColumn: true)
;
}
`
Sorry, but code editor is messing up the text.

from linq2db.