1-) MSSQL RMOS - sql to json format

select  top 20 * from rez for json path,INCLUDE_NULL_VALUES

MSSQL DE BİR KISMINI GÖSTEREBİLİR AŞAĞIDAKİ KOD İLE C# TARAFINDA DENE hepsini alır

DECLARE @json NVARCHAR(MAX);

SET @json = (select * from rez FOR JSON path,INCLUDE_NULL_VALUES)

select @json as jsonn

2-) aşağıdaki null olanları almaz

select  top 20 * from rez for json path

MSSQL DE BİR KISMINI GÖSTEREBİLİR AŞAĞIDAKİ KOD İLE C# TARAFINDA DENE

DECLARE @json NVARCHAR(MAX);

SET @json = (select * from rez FOR JSON path)

select @json as jsonn

 3-) JOİNLİ

select * from urun

left join Kategori on urun.kategoriId=Kategori.id

 for json auto

kaynak : https://stackoverflow.com/questions/68311827/how-to-use-left-join-with-for-json-path-in-mssql