sqlsharpener
sqlsharpener copied to clipboard
XML/JSON support
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