dotnetcore / dotnetcore/FreeSql

jsonMap List 查询未实现

Open
#2,188 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
4.4k
Forks
910
PR merge metrics
No merged PRs in 30d

Description

#### Feature 特性
jsonMap List 查询未实现

```c#
// c# code
class Table11
{
public int Id { get; set; }

[JsonMap]
public TableOptions Options { get; set; }

[JsonMap]
public List OptionsList { get; set; }
}

class TableOptions
{
public int Value1 { get; set; }
public string Value2 { get; set; }
}

fsql.Select().Where(a => a.OptionsList.Any(q => q.Value2.Contains("xx"))).ToList();

```

#### 简要描述原因
返回错误:
Unhandled exception. System.Exception: FreeSql: Function expression a.OptionsList.Any(q => q.Value2.Contains("xx")) parsing is not implemented.

#### 使用场景
存储List 在db字段已JsonArray 存储,方便快速查询
SQL 语句是
```sql
WHERE (EXISTS (
SELECT 1 FROM OPENJSON(a.Value2)
WITH (Name NVARCHAR(100) '$.Value2')
WHERE Name LIKE '%xx%'))
```

freesql源码全局搜索未查找到 OPENJSON函数!!

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.