Platina-Data

Database for Platina integration-data, Region Örebro län. That is, for the moment, EF Core entities and db-contexts. There are two concrete db-contexts:

• SqlitePlatinaContext
• SqlServerPlatinaContext

Migrations exist for:

• SqlitePlatinaContext
• SqlServerPlatinaContext

You can create your own migrations for other database-providers.

1 Development

1.1 Signing

Drop the "StrongName.snk" file in the repository-root. The file should not be included in source control.

1.2 Migrations

We might want to create/recreate/update migrations. If we can accept data-loss we can recreate the migrations otherwhise we will have to update them. For each update we need to bump the migration-name suffix:

• Initial migration: "Function"
• First update: "Function1"
• Second update: "Function2"

Copy all the commands below and run them in the Package Manager Console.

If you want more migration-information you can add the -Verbose parameter:

Add-Migration Function -Context FunctionContext -OutputDir Some/Path/To/Your/Migrations -Project Project -StartupProject Project -Verbose;

1.2.1 Create migrations

Write-Host "Removing migrations...";
Remove-Migration -Context SqlitePlatinaContext -Force -Project Project -StartupProject Project;
Remove-Migration -Context SqlServerPlatinaContext -Force -Project Project -StartupProject Project;
Write-Host "Removing current migrations-directory...";
Remove-Item "Project\Migrations" -ErrorAction Ignore -Force -Recurse;
Write-Host "Creating migrations...";
Add-Migration Platina -Context SqlitePlatinaContext -OutputDir Migrations/Sqlite -Project Project -StartupProject Project;
Add-Migration Platina -Context SqlServerPlatinaContext -OutputDir Migrations/SqlServer -Project Project -StartupProject Project;
Write-Host "Finnished";

1.2.2 Update migrations

Copy all the commands below and run them in the Package Manager Console.

Write-Host "Updating migrations...";
Add-Migration Platina1 -Context SqlitePlatinaContext -OutputDir Migrations/Sqlite -Project Project -StartupProject Project;
Add-Migration Platina1 -Context SqlServerPlatinaContext -OutputDir Migrations/SqlServer -Project Project -StartupProject Project;
Write-Host "Finnished";

1.3 Scaffold-DbContext

If we want to know how we should code our DbContexts / Entities we can use Scaffold-DbContext. Create a database first with eg. Microsoft SQL Server Management Studio through the designer or with scripts. Then scaffold a db-context from it. Then we can look at the generated classes and see how we should "code first".

• Create a LocalDB-database named eg. "07390b07-29ed-4944-aced-df2ad5b4dbc2".
• Create your database tables etc.
• Run: Scaffold-DbContext "Data Source=(LocalDB)\MSSQLLocalDB;Initial Catalog=07390b07-29ed-4944-aced-df2ad5b4dbc2" Microsoft.EntityFrameworkCore.SqlServer -ContextDir "" -OutputDir "Your-directory"
• Delete the database

2 Links

• Migrations with Multiple Providers