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
if we had some sproc that returned an xml (or json) column, e.g.:
and sqlsharpener could parse the
for xmlsyntax to generate this corresponding dto:it seems very difficult but it would be a great feature