CodeSmith Community
Your Code. Your Way. Faster!

TableSchema ExtendedProperties

Latest post 05-09-2007 2:22 PM by shannon. 1 replies.
  • 05-07-2007 6:16 PM

    • Chadich
    • Not Ranked
    • Joined on 01-16-2003
    • USA
    • Posts 4
    • Points 110

    TableSchema ExtendedProperties

    Simple question, I'm generating classes based on tables from SQL Server 2005 and I'd like to get some information in user-created Extended Properties from the table.  However, the extended properties don't seem to populate.  I enter and save a value into an extended property in sql srvr mgmt studio, script the table to ensure the property is saved, and then select my source table from my template and run my template, however when I debug and expand the collection of Extended Properties underlying the table schema object, it only ever has the default sql server provided one.

     Can anyone give me some suggestions as to how to troubleshoot this?

    Thanks much,

    Richard

    • Post Points: 35
  • 05-09-2007 2:22 PM In reply to

    • shannon
    • Top 50 Contributor
    • Joined on 03-06-2007
    • Posts 73
    • Points 5,350

    Re: TableSchema ExtendedProperties

    You may need to try SourceTable.Refresh();  The table data is cached during the first execution.
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems