Posts

Showing posts with the label t4

SQL Server DAC columns and rows from TSqlObject

SQL Server DAC columns and rows from TSqlObject I am trying to write a T4 Template that generates triggers for all my tables in my database based on extended properties using Microsoft.SqlServer.Dac.Model , but I am very confused how everything works in this namespace. Microsoft.SqlServer.Dac.Model I use: Model.GetObjects(DacQueryScopes.All, ModelSchema.ExtendedProperty) to get a list of all the tables in the database model schema but I cannot for the life of me figure out how I am supposed to get information such as column names from the returned table objects. Possible solution here: stackoverflow.com/questions/17983499/how-to-traverse-a-dacpac – Matthew Alltop Jun 29 at 18:19 By clicking "Post Your Answer", you acknowledge that you have ...