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

From the creator

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/learn-more/community-standups#June26_2024 Featuring: Erik Ejlskov Jensen (@ShayErikEJ erikej.github.io, Shay Rojansky (@ShayRojansky), Jiri Cincura #AzureSql #EFCore #DotNet

Published 2024-06-27 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.