dotnetcore / dotnetcore/FreeSql
jsonMap List 查询未实现
- 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.