If you write code to SQL Server then you might be interested in this: I have written a tSQLt tdd training course which has helped over 500 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club.

DacFX Links

I thought it would be a good idea to gather together a list of links for DacFx, blogs code or articles - if you have anything that you think should be included in this list please send it and I will include it.

The first thing to read is the “DacFx Public Model Tutorial” this by Kevin Cunnane from the Microsoft SSDT team and is highly recommended:

http://blogs.msdn.com/b/ssdt/archive/2013/12/23/dacfx-public-model-tutor…

Then there are the DacFx samples on codeplex:

https://dacsamples.codeplex.com/SourceControl

To help experiment with the API then using Linqpad is pretty cool:

http://sqlblog.com/blogs/jamie_thomson/archive/2014/09/26/querying-a-dac…

My DacFx links:

Dacpac Explorer - This is a demo to show how to use the querying functionality to follow references and relationships to get to different objects:

https://sqlserverfunctions.wordpress.com/2014/09/26/dacpac-explorer/

Sample on Github:

https://github.com/GoEddie/DacFxApi

CountLinesOfTSqlCode - Also uses the TSql Script Dom API to get lines of code in a dacpac
DumpIndexProperties - Dump out an indexes properties
ShowTableColumns - Show columns in (on?) a table

Subscribe

* indicates required

Please select all the ways you would like to hear from Agile Sql Club:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.