CentOS下使用.Net Core 1.1部署WebApi

绝地灬酷狼 2023-10-17 14:26 1阅读 0赞

一、安装CentOS系统

二、在CentOS上安装最新的.Net Core

安装教程在官网已经很详细了。 [https://www.microsoft.com/net/core\#linuxcentos][https_www.microsoft.com_net_core_linuxcentos]

三、用VS2017新建一个WebApi Core项目

参看帖子：[http://www.cnblogs.com/keepcodingforever/p/6642183.html][http_www.cnblogs.com_keepcodingforever_p_6642183.html]

官方的文档参看：[https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api][https_docs.microsoft.com_en-us_aspnet_core_tutorials_first-web-api]

(注意Core1.0版本需要project.json文件，在最新的版本中已经不需要了)

四、链接MySQL，目前官方正式版本的MySQL Core驱动还没有发布，已经发布的是预览版本的。

[https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/][https_www.nuget.org_packages_MySql.Data.EntityFrameworkCore]

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Threading.Tasks;
    using Microsoft.AspNetCore.Http;
    using Microsoft.AspNetCore.Mvc;
    using MySql.Data.MySqlClient;
    
    namespace TestCore_WebApi.Controllers
    {
        [Produces("application/json")]
        [Route("api/Test/[action]")]
        public class TestController : Controller
        {
            public static string connectionString = "server=192.168.0.1;user id=root;pwd=root;database=test;SslMode=none;CharSet=utf8;";
            [HttpGet]
            public string TestAPI()
            {
                string str = "hello ";
                try
                {
                    string sql = "INSERT INTO price(`code`,time) VALUES('11111',NOW());";
                    MySqlHelper.ExecuteNonQuery(connectionString,sql);
    
                    sql = "select * from price limit 10";
                    
                    using (MySqlDataReader dr = MySqlHelper.ExecuteReader(connectionString, sql))
                    {
                        if (dr.HasRows)
                        {
                            while (dr.Read())
                            {
                                str += dr[0].ToString();
                            }
                        }
                    }
                }catch(Exception ex)
                {
                    return ex.Message;
                }
    
                return str;
            }
        }
    }

[https_www.microsoft.com_net_core_linuxcentos]: https://www.microsoft.com/net/core#linuxcentos
[http_www.cnblogs.com_keepcodingforever_p_6642183.html]: http://www.cnblogs.com/keepcodingforever/p/6642183.html
[https_docs.microsoft.com_en-us_aspnet_core_tutorials_first-web-api]: https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api
[https_www.nuget.org_packages_MySql.Data.EntityFrameworkCore]: https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/