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;
}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/portainerversion: '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-orphanshttps://medium.com/@ali.bahrami/deploy-an-angular-asp-net-core-webapi-on-docker-ab3546a06803
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"]#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"]