Instant PR decline reasons

N+1 Queries

Always query all data you need before executing anything.

Incorrect:

foreach (var id in itemIds)
{

0 likes

0 forks

1 files

dotnet ef

1	# Creates a new migration
2	dotnet ef migrations add MigrationName --project "../Domain/Domain.csproj"
3
4	# Runs the migrations
5	dotnet ef database update --project "../Domain/Domain.csproj"
6
7	# Creates a SQL command that matches the migration
8	dotnet ef migrations script ---project "../Domain/Domain.csproj"
9
10	# Checks for pending model changes

0 likes

0 forks

1 files

azure mssql

1	DECLARE @user NVARCHAR(100) = N'your-resource-group-or-email';
2
3	CREATE USER [@user] FROM EXTERNAL PROVIDER;
4	ALTER ROLE db_datareader ADD MEMBER [@user];
5	ALTER ROLE db_datawriter ADD MEMBER [@user];
6	ALTER ROLE db_ddladmin ADD MEMBER [@user];
7	GO