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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy