MS Sqlserver and dotnet demo on openshift

Running MSSql container on openshift, in addition to .net core application based on .net MVC and entity framework connecting to MSSql server running on openshift.
you cn find the .net core application on following github repo
https://github.com/wael2000/dotnet-core-mvc-ef-mssql

Below the scripts have been used during the demo

minishift --profile demo --vm-driver=virtualbox start

oc login https://192.168.99.100 -u system

docker login -u system -p $(oc whoami -t) docker-registry-default.192.168.99.100.nip.io

docker pull microsoft/mssql-server-linux

docker tag microsoft/mssql-server-linux docker-registry-default.192.168.99.100.nip.io/openshift/mssql-server-linux

docker push docker-registry-default.192.168.99.100.nip.io/openshift/mssql-server-linux

oc adm policy add-scc-to-user anyuid -z default

start application based on sqlserver image with following parameters
ACCEPT_EULA Y
SA_PASSWORD P@ssw0rd2000
MSSQL_PID Developer

oc rsh POD_NAME

cd /opt/mssql-tools/bin
./sqlcmd -S localhost -U SA -P P@ssw0rd2000


CREATE DATABASE [Blogging];
GO
USE [Blogging];
GO
CREATE TABLE [Blog] ( [BlogId] int NOT NULL IDENTITY, [Url] nvarchar(max) NOT NULL, CONSTRAINT [PK_Blog] PRIMARY KEY ([BlogId]) );
GO
CREATE TABLE [Post] ( [PostId] int NOT NULL IDENTITY, [BlogId] int NOT NULL, [Content] nvarchar(max), [Title] nvarchar(max), CONSTRAINT [PK_Post] PRIMARY KEY ([PostId]), CONSTRAINT [FK_Post_Blog_BlogId] FOREIGN KEY ([BlogId]) REFERENCES [Blog] ([BlogId]) ON DELETE CASCADE );
GO
INSERT INTO [Blog] (Url) VALUES ('http://blogs.msdn.com/dotnet'), ('http://blogs.msdn.com/webdev'), ('http://blogs.msdn.com/visualstudio')
GO