SQL Server From .Net: Reading SQL Server Metadata in ADO.Net

  • timwell

    SSCarpal Tunnel

    Points: 4895

    Comments posted to this topic are about the item SQL Server From .Net: Reading SQL Server Metadata in ADO.Net

  • timwell

    SSCarpal Tunnel

    Points: 4895

    There is a problem with formatting. After my question about tables (which should have been removed) everything is in the red comment text.

  • fregatepallada

    SSC-Addicted

    Points: 407

    Why ADO.NET on client side - SQL Server has OOB rich metadata functionality in information views

  • timwell

    SSCarpal Tunnel

    Points: 4895

    fregatepallada - Sunday, June 17, 2018 10:41 PM

    Why 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.

  • fregatepallada

    SSC-Addicted

    Points: 407

    timwell - Monday, June 18, 2018 7:34 AM

    fregatepallada - Sunday, June 17, 2018 10:41 PM

    Why 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.

    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