Set Visual studio 202x และ dotnet core netcore 8 ไม่ Append output path

 ให้เปิด .csproj และ เพิ่ม 

<PropertyGroup>

   <AppendTargetFrameworkToOutputPath>false</AppendTargetFrameworkToOutputPath>

   <AppendRuntimeIdentifierToOutputPath>false</AppendRuntimeIdentifierToOutputPath>

 </PropertyGroup>

Set sql server 2019 ให้ ทำงานกับ JSON data

 ต้อง Set database ทีทำงานให้ support ก่อน

ALTER DATABASE MYDB SET COMPATIBILITY_LEVEL = 130

CREATE TABLE [dbo].[Orders](

[OrderID] [int] NOT NULL,

[CustomerName] [nvarchar](50) NULL,

[OrderDetails] [nvarchar](max) NULL)

INSERT INTO Orders (OrderID, CustomerName, OrderDetails)

VALUES (1, 'John test', 

'{"items": [{"name": "Widget", "quantity": 2}, 

            {"name": "Gizmo", "quantity": 4}], 

  "total": 99.99}')

INSERT INTO Orders (OrderID, CustomerName, OrderDetails)

VALUES (2, 'betty ok', 

'{"items": [{"name": "Pen", "quantity": 3}, 

            {"name": "Gizmo", "quantity": 2}], 

  "total": 88}')

ทดสอบ query

SELECT *

FROM Orders

WHERE EXISTS (

   SELECT *

   FROM OPENJSON(OrderDetails, '$.items')

   WHERE JSON_VALUE(value, '$.name') = 'Widget'

)