Skip to content

Instantly share code, notes, and snippets.

@kierunb
Last active December 11, 2019 12:25
Show Gist options
  • Save kierunb/fbb3a3e8d610f422efd6736cf7973ec9 to your computer and use it in GitHub Desktop.
Save kierunb/fbb3a3e8d610f422efd6736cf7973ec9 to your computer and use it in GitHub Desktop.

redis & c#

using StackExchange.Redis;

using Dapper;
using Microsoft.Data.SqlClient;

        [HttpGet]
        [Route("sql")]
        public string Sql()
        {
            string connString = "server=sqlserver;database=master;User Id=sa;Password=P@ssw0rd!!!!!";
            var sqlConn = new SqlConnection(connString);
            int tablesCount = (int)sqlConn.ExecuteScalar("select count(*) from sys.tables");

            return $"W bazie master jest {tablesCount} tabel";
        }

        [HttpGet]
        [Route("redis")]
        public string Redis()
        {
            var redis = ConnectionMultiplexer.Connect("redis");
            // to co jest w metodzie connect to jest nazwa hosta
            var db = redis.GetDatabase();
            db.StringSet("data", DateTime.Now.ToLongTimeString());
            var data = db.StringGet("data");
            return data;
        }

docker commands

https://nodejs.org/de/docs/guides/nodejs-docker-webapp/

docker run -d -p 9000:9000 -p 8000:8000 --name portainer --restart always -v /var/run/docker.sock:/var/run/docker.sock -v d:\portainer:/data portainer/portainer

docker-compose.yml

version: '3'
services:
  web:
    build: .
    ports:
    - "8333:80"
    links:
    - redis
  redis:
    image: redis
  sqlserver:
    image: mcr.microsoft.com/mssql/server
    ports:
      - 1433:1433
    environment:
      ACCEPT_EULA: "Y"
      SA_PASSWORD: "P@ssw0rd!!!!!"
      MSSQL_PID: "Express"

commands:

docker-compose build
docker-compose up
docker-compose down
docker-compose down -v --rmi all --remove-orphans

dotnet core + angular/react

https://medium.com/@ali.bahrami/deploy-an-angular-asp-net-core-webapi-on-docker-ab3546a06803

dotnet core 2.2

FROM mcr.microsoft.com/dotnet/core/sdk:2.2 AS build-env
WORKDIR /app

# Copy csproj and restore as distinct layers
COPY *.csproj ./
RUN dotnet restore

# Copy everything else and build
COPY . ./
RUN dotnet publish -c Release -o out

# Build runtime image
FROM mcr.microsoft.com/dotnet/core/aspnet:2.2
WORKDIR /app
COPY --from=build-env /app/out .
ENTRYPOINT ["dotnet", "aspnetapp.dll"]

dotnet core 3.1

#The Dockerfile assumes that your application is called aspnetapp. Change the Dockerfile to use the DLL file of your project

FROM mcr.microsoft.com/dotnet/core/sdk:3.1 AS build
WORKDIR /app

# Copy csproj and restore as distinct layers
COPY *.csproj ./
RUN dotnet restore

# Copy everything else and build
COPY . ./
RUN dotnet publish -c Release -o out

# Build runtime image
FROM mcr.microsoft.com/dotnet/core/aspnet:3.1 AS runtime
WORKDIR /app
COPY --from=build /app/out .
ENTRYPOINT ["dotnet", "core-webapi.dll"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment