emildr

Inscrit 2 months ago

0 j'aimes

0 forks

1 fichiers

Instant PR decline reasons

Always query all data you need before executing anything.

Incorrect:

foreach (var id in itemIds)
{

0 j'aimes

0 forks

1 fichiers

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 j'aimes

0 forks

1 fichiers

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

Plus récent Plus ancien

Français