.NET Data Community Standup-Improve your SQL schema and scripts with .NET based static code analysis

By harnessing the power of the .NET DacFX framework and the related .NET T-SQL parser, you can improve the quality of your database schema and scripts with static T-SQL analysis.

ErikEJ has recently revived this 15-year-old technology with support for .NET 6 and later and has brought a number of third-party rules back from the grave.

In this EF Core community standup we will have a closer look - from generation of a simple HTML report with findings to managing and creating your own analyzer rules using modern .NET.

⏲️ Chapters:
00:00 Countdown
02:30 Lift off for .NET Data Community Standup
04:15 Welcome Erik EJ
05:13 On today's show
06:15 .NET framework - DACFx
08:45 Demo
27:21 Q&A
38:40 Applying custom rules
41:25 Demo
57:42 Database project/MSBuild.SDK.SqlProj
58:33 CTA
01:02:38 Wrap

Community Links:


#AzureSql #EFCore #DotNet

[saicharan]

Applying the custom rules is amazing. I really like your EF power tools project Erik, big fan.

[OggVorbis]

Thank you so much. I am literally amazed how few modern devs that came on from the web side of things don't even know about this dB development treasure available for SQL server. Btw I use dacpac for dB migration.preferred method.ill be glad to exchange best practices with same minded folks too