dotnetcore / dotnetcore/FreeSql

postgres下插入只包含字符串的json会报错

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

Description

```c#
using Newtonsoft.Json.Linq;

internal class Program
{
static void Main(string[] args)
{
IFreeSql fsql = new FreeSql.FreeSqlBuilder()
.UseConnectionString(FreeSql.DataType.PostgreSQL, @"Host=127.0.0.1;Port=5432;Username=postgres;Password=123; Database=freesqltest;")
.UseMonitorCommand(cmd => Console.WriteLine($"Sql:{cmd.CommandText}"))
.UseNoneCommandParameter(true)
.UseAutoSyncStructure(true)
.Build();

fsql.CodeFirst.SyncStructure();

fsql.Insert(new MyTestObj() { Json = "aaabbb" }).ExecuteAffrows();
}
}

class MyTestObj
{
public JToken Json { get; set; }
}
```
包:

![image](https://github.com/dotnetcore/FreeSql/assets/6988665/f768a2d6-f778-42d2-8387-ef8fbe987f6d)

freesql生成的sql:INSERT INTO "MyTestObj"("Json") VALUES('aaabbb')

可以正确插入的sql应该为 INSERT INTO "MyTestObj"("Json") VALUES('"aaabbb"')

update同理

不过数值类型没问题

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.