<output id="qn6qe"></output>

    1. <output id="qn6qe"><tt id="qn6qe"></tt></output>
    2. <strike id="qn6qe"></strike>

      亚洲 日本 欧洲 欧美 视频,日韩中文字幕有码av,一本一道av中文字幕无码,国产线播放免费人成视频播放,人妻少妇偷人无码视频,日夜啪啪一区二区三区,国产尤物精品自在拍视频首页,久热这里只有精品12

      Docker 之web api 訪問 host sql server

      運(yùn)行 Docker

      C:\Users\Administrator>docker run -it  -p 5000:5000 --name myapidocker1 webapiv1

       

      root@3b3e97bb6e21:/# dir

      bin  boot  dev  etc  home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  test  tmp  usr  var

       

       

      C:\Users\Administrator>docker ps

      CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS                    NAMES

      3b3e97bb6e21        webapiv1            "bash"              9 seconds ago       Up 8 seconds        0.0.0.0:5000->5000/tcp   myapidocker1

       

      deploy 編譯后的dll,編譯選項(xiàng)選擇如下

       

       

       

      D:\Work\My\opensource\Dotnet2\WebAPIForDocker\bin\Debug>docker cp netcoreapp2.1/publish myapidocker1:/test/api3

       

      查看配置,注意linux sqlserver 端口號必須指定

       

      root@3b3e97bb6e21:/test/api3/publish# cat appsettings.json

      {

        "Logging": {

          "LogLevel": {

            "Default": "Information"

          }

        },

        "AllowedHosts": "*",

        "ConnectionStrings": {

          "DefaultConnection": "Max Pool Size = 51200;Server=localhost,1433;User ID=sa;Pwd=XXXXX;DataBase=Order;"

        }

      }

       

      進(jìn)入到容器

       

      如果不小心關(guān)閉了,docker 的終端,再次進(jìn)入docker

       

      C:\Users\Administrator>docker exec -it myapidocker1 /bin/bash

      root@3b3e97bb6e21:/# dir

      bin  boot  dev  etc  home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  test  tmp  usr  var

       

       

      運(yùn)行 core

      root@3b3e97bb6e21:/test/api3/publish# dotnet WebAPIForDocker.dll

       

      info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[0]

            User profile is available. Using '/root/.aspnet/DataProtection-Keys' as key repository; keys will not be encrypted at rest.

      Hosting environment: Production

      Content root path: /test/api3/publish

      Now listening on: http://[::]:5000

      Application started. Press Ctrl+C to shut down.

       

       

      打開另一個(gè)終端,在docker 內(nèi)部訪問

       

      root@3b3e97bb6e21:/# curl http://localhost:5000/api/orders/getHostName

      3b3e97bb6e21root@3b3e97bb6e21:/

       

      3b3e97bb6e21root@3b3e97bb6e21:/# curl http://localhost:5000/api/orders/getOrderList

      [{"item1":"ja201808204778560863744992601","item2":"08/20/2018 18:29:16"},{"item1":"201808205628636382300589946","item2":"08/20/2018 18:29:18"},{"item1":"201808205753427170575780018","item2":"08/20/2018 18:29:19"},{"item1":"201808204749312987745111125","item2":"08/20/2018 18:29:21"},{"item1":"201808204725778270582113008","item2":"08/20/2018 18:29:22"},{"item1":"201808204776350327734840932","item2":"08/20/2018 18:29:27"},{"item1":"201808205627318305959441050","item2":"08/20/2018 18:29:30"},{"item1":"201808205593544898683339668","item2":"08/20/2018 18:29:34"},{"item1":"201808205707984438836626731","item2":"08/20/2018 18:29:35"},{"item1":"201808205573431454844603206","item2":"08/20/2018 18:29:39"}]root@3b3e97bb6e21:/#

       

       

      webAPI部分代碼:

       

      [Route("api/[controller]")]

          public class OrdersController : Controller

          {

              private IConfigOptions m_configOptions;

              private ILogger m_logger;

              public OrdersController(IConfigOptions configOptions, ILogger<OrdersController> logger)

              {

                  m_configOptions = configOptions;

                  m_logger = logger;

              }

              // GET api/values

              [Route("[action]")]

              [HttpGet]

              public ActionResult<IEnumerable<Tuple<string, string>>> GetOrderList()

              {

                  m_logger.LogDebug(" ConnectionString:" + m_configOptions.ConnectionString);

                  //Console.WriteLine(" ConnectionString:" + m_configOptions.ConnectionString);

                  List<Tuple<string, string>> list = new List<Tuple<string, string>>();

                  try

                  {

                      using (SqlConnection sqlCon = new SqlConnection(m_configOptions.ConnectionString))

                      {

       

                          sqlCon.Open();

                          string sql = "select top 10 * from [dbo].[Order]";

       

                          using (SqlCommand cmd = new SqlCommand(sql, sqlCon))

                          {

                              var reader = cmd.ExecuteReader();

                              while (reader.Read())

                              {

                                  list.Add(new Tuple<string, string>(reader["orderNum"].ToString(), reader["InDate"].ToString()));

                              }

                          }

                      }

                  }

                  catch(Exception ex)

                  {

                      m_logger.LogError(ex, ex.Message, "Get");

                  }

       

                  return list;

              }

       

              // GET api/values/5

              [Route("[action]")]

              [HttpGet]

              public ActionResult<string> GetHostName()

              {

                  string hostName = Dns.GetHostName();

                  return hostName;

              }

       

             

          }

       

      webAPI部分代碼:

      posted @ 2018-12-26 23:29  b0b0  閱讀(798)  評論(0)    收藏  舉報(bào)
      主站蜘蛛池模板: 暖暖免费观看电视在线高清| 国产精品无码无卡在线播放| 亚洲 欧美 清纯 校园 另类| 天天躁夜夜躁天干天干2020| 91精品蜜臀国产综合久久| 免费av网站| 国产精品青草久久久久福利99| 湖州市| 国内精品亚洲成av人片| 国产成人无码免费视频在线| 免费观看全黄做爰大片| 亚洲色大成网站WWW国产| 亚洲色大成网站www永久男同| 丰满人妻被黑人猛烈进入| 日韩中文字幕综合第二页| 91久久精品美女高潮不断| 国产91小视频在线观看| 国产一区二区不卡在线看| 久久久精品2019中文字幕之3| 无码福利写真片视频在线播放| 综合图区亚洲另类偷窥| 国产精品无码无片在线观看3d| 综合偷自拍亚洲乱中文字幕 | 福利一区二区在线观看| 日韩av毛片福利国产福利| 亚洲AV无码一二区三区在线播放| 狠狠躁夜夜躁人人爽天天5| 免费无码一区二区三区蜜桃| 2019亚洲午夜无码天堂| 简阳市| 麻花传媒在线观看免费| 亚洲精品揄拍自拍首页一| 国产乱久久亚洲国产精品| 无码专区 人妻系列 在线| 欧美精品一区二区三区中文字幕| 亚洲一区二区国产av| 亚洲婷婷综合色高清在线| 91一区二区三区蜜桃臀| 亚洲精品国产精品国在线| 免费黄色大全一区二区三区| 久久久精品波多野结衣av |