sqlsharpener icon indicating copy to clipboard operation
sqlsharpener copied to clipboard

XML/JSON support

Open gfody opened this issue 9 years ago • 0 comments

if we had some sproc that returned an xml (or json) column, e.g.:

select id, name, tags=(
    select key [@key], value [@value]
    from tagTable where some_id=o.id
    for xml path('tag'), type)
from someTable o

and sqlsharpener could parse the for xml syntax to generate this corresponding dto:

public class sproc_result
{
    public int id;
    public string name;
    public List<tag> tags;

    public class tag { string key; string value; }
}

it seems very difficult but it would be a great feature

gfody avatar Aug 31 '16 23:08 gfody