Arch Forum 2024-11-21

Participants: Backend devs, Andy, Magnus Victor and Zak

Agenda

• DB
• EditorConfig

DB

A walkthrough of important points regarding MERGE/Upsert, NOLOCK, Include index and SP migrations: Presentation here

Example of unsafe NOLOCK C# code from presentation is here: https://gist.github.com/viblo-majority/7ba143583cbabd970897c2e8eb14e2bb

During the presentation Lars raised the question if its possible to validate that no MERGEs are used. We could do this, but its not completely trivial, and for now its better to focus on moving all SPs to one-file-per-SP style, since that would be a prerequisite for such a validation anyway.

EditorConfig

In the last Arch Forum meeting Rasmus presented EditorConfig as a replacement for resharper DotSettings based formatting/linting. Victor and Rasmus now presented a concrete proposal, we should use the default .editorconfig (created by dotnet new editorconfig). Victor showed an example of what it would be like in User with a Draft PR here.

No objects were raised, this is what we will go with.