asp.net core 實踐

標籤：codepage   dex   ati   ram   pool   region   write   strong   mysq   

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

 

這是一個基於asp.net core web application的練習項目,目的是學習dotnet core新技能。

1，目前實現了基於mysql簡單的增刪查改功能(Dapper)。https://github.com/StackExchange/dapper-dot-net

 樣本：

[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"          }        }      }    }
  }

 

asp.net core 實踐