adrianeyre/api-sql-container

Containerise Database

Technologies: .NET Core 3.1 API, Docker, SQL Server, Entity Framework

Background

The purpose of this repo is to define the pros and cons for containerising an Entity Framework Migrations vs Database dacpac solution. Each version has a simple API and database in docker containers.

Index

• Prerequisites
• Initial Setup
• Entity Framework
  • Setup
• Dacpac Database
  • Setup
• API Usage
• Database Management

Prerequisites

• Visual Studio 2019
• SQL Server Management Studio (SSMS)
• Docker Desktop

Initial Setup

• Download Docker Desktop, install and log in to the application
• To clone the repo and run the game

$ git clone https://github.com/adrianeyre/api-sql-container
$ cd api-sql-container

Entity Framework

Setup

• Open folder /EntityFrameworkMigrationsExample
• Load the application ApiSQLContainer.sln
• Set the start up project to docker-compose

Dacpac Database

Setup

• Open folder /DacPacExample/API
• Load the application DacPacApiExample.sln
• Set the start up project to docker-compose

API Usage

• Navigate to https://localhost:44325/api/products
• Navigate to https://localhost:44325/api/books

Database Management

• Open SQL Server Management Studio (SSMS)
• Login Credetials

  Server Name: 127.0.0.1,1433
  Authentication: SQL Server Authentication
  Login: sa
  Password: SecureP4ssW0rd