asp.net core 实践

github：https://github.com/zzhi/DotNetWeb

 

这是一个基于asp.net core web application的练习项目,目的是学习dotnet core新技能。

1，目前实现了基于mysql简单的增删查改功能(Dapper)。https://github.com/StackExchange/dapper-dot-net

 示例：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

[HttpPost]         [ValidateAntiForgeryToken]         public IActionResult Edit(int id, [Bind("ID,Genre,Price,ReleaseDate,Title")] Movie movie)         {             if (id != movie.ID)             {                 Log.Information("ID为空");                 return NotFound();             }               if (ModelState.IsValid)             {                 try                 {                     MySqlConnection con = new MySqlConnection(Config.DbServer);                       string sql = "UPDATE `movie` SET `Title`='" + movie.Title + "', `ReleaseDate`='" + Convert.ToDateTime(movie.ReleaseDate).ToString("yyyy-MM-dd HH:mm:ss") + "', `Genre`='" + movie.Genre + "', `Price`='" + movie.Price + "' WHERE ID =" + id;                     con.Execute(sql);                     Log.Information("操作成功");                 }                 catch (Exception ex)                 {                     Log.Information(ex.Message);                     throw new Exception(ex.Message);                 }                 return RedirectToAction("Index");             }             return View(movie);         }

　　

2，添加了日志功能(Serilog) https://github.com/serilog/serilog;

  #region 日志
            Log.Logger = new LoggerConfiguration()
              .MinimumLevel.Debug()//等级
              .WriteTo.LiterateConsole()//写到控制台
              .WriteTo.RollingFile("logs\\{Date}.txt")//写到文本
              .CreateLogger();
   #endregion

 

3，添加了Redis： https://www.nuget.org/packages/ServiceStack.Redis.Core/

 

  [Fact]
        public void SetGetTest()
        {
            
            var manager = new RedisManagerPool("localhost:6379");
            using (var client = manager.GetClient())
            {
                client.Set("foo", "bar");
                Console.WriteLine("Redis Test: foo={0}", client.Get<string>("foo"));
            }
        }

 

4，添加了xUnit.net ：https://xunit.github.io/docs/getting-started-dotnet-core.html

 

  {
    "version": "1.0.0-*",
    "testRunner": "xunit",
    "dependencies": {
      "xunit": "2.2.0-beta2-build3300",
      "Utility": "1.0.0-*",
      "System.Text.Encoding.CodePages": "4.3.0",
      "dotnet-test-xunit": "2.2.0-preview2-build1029"
    },
    "frameworks": {
      "netcoreapp1.0": {
        "dependencies": {
          "Microsoft.NETCore.App": {
            "type": "platform",
            "version": "1.0.0"
          }
        }
      }
    }

  }