June 13, 2018 at 11:41 pm
Comments posted to this topic are about the item SQL Server From .Net: Reading SQL Server Metadata in ADO.Net
June 14, 2018 at 7:55 am
There is a problem with formatting. After my question about tables (which should have been removed) everything is in the red comment text.
June 17, 2018 at 10:41 pm
Why ADO.NET on client side - SQL Server has OOB rich metadata functionality in information views
June 18, 2018 at 7:34 am
fregatepallada - Sunday, June 17, 2018 10:41 PMWhy ADO.NET on client side - SQL Server has OOB rich metadata functionality in information views
Good question actually. I guess it's mainly to give people another option. This was inspired by my research into the SqlConnection object.
However, when trying to reproduce SQL Server relations in a dataset (for the next article in the series) I found that the "ForeignKeys" collection did not even include the columns involved.
BTW, there is a great stairway series on SSC by Phil Factor about the metadata.
June 18, 2018 at 8:11 am
timwell - Monday, June 18, 2018 7:34 AMfregatepallada - Sunday, June 17, 2018 10:41 PMWhy ADO.NET on client side - SQL Server has OOB rich metadata functionality in information viewsGood question actually. I guess it's mainly to give people another option. This was inspired by my research into the SqlConnection object.
However, when trying to reproduce SQL Server relations in a dataset (for the next article in the series) I found that the "ForeignKeys" collection did not even include the columns involved.
BTW, there is a great stairway series on SSC by Phil Factor about the metadata.
Typical incomplete solution - there is a PARADE of technologies but neither of them have a COMPLETE set of CAPABILITIES
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply