.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:
https://learn.microsoft.com/ef/core/l...

Featuring: Erik Ejlskov Jensen (@ShayErikEJ erikej.github.io, Shay Rojansky (@ShayRojansky), Jiri Cincura

#AzureSql #EFCore #DotNet