เริ่มต้นเขียนเว็บด้วย visual studio 2013 ติดต่อฐานข้อมูล sql server 2008

using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.AspNetCore.Mvc;
using Dapper;
using HUM_Database;

namespace HUM_APIService02.Controllers.Settings.Shared
{
    [Route("api/Settings/[controller]")]
    public partial class SharedController : ControllerBase
    {
        /// <summary>
        /// ข้อมูลฝ่าย
        /// Usge : /api/Settings/Shared/mDivision
        ///      : https://localhost:5008/api/Settings/Shared/mDivision
        /// </summary>
        /// <returns>All Division</returns>
        [HttpGet]
        [Route("mDivision")]
        public IActionResult GetAllMDivisionX()
        {
            IEnumerable<HUM_Database.Models.Settings.MDivision> results2 = null;
            using (var cn = SexyDatabase.SexyConnection())
            {
                //results = cn.Query<dynamic>("Select * From mDivision Order By 1, 2, 3");
                results2 = cn.GetList<HUM_Database.Models.Settings.MDivision>();
            }
            return Ok(results2.ToList());
        }
    }
}

using Dapper;
using Newtonsoft.Json;
namespace HUM_Database.Models.Settings
{
    /// <summary>
    /// ข้อมูล ฝ่าย
    /// ex, cd MDivision
    /// </summary>
    /// <remarks>A = Transaction file.</remarks>
    [Table("mDivision")]
    public class MDivision
    {
        [Key] //Auto increment
        [JsonProperty("Id")]
        public int Id { get; set; }

        [Key, Required]
        [JsonProperty("code")]
        /// <summary>
        /// รหัสฝ่าย
        /// ex ? , cd Type
        /// </summary>
        public string Code { get; set; }

        [JsonProperty("nameth")]
        /// <summary>
        /// ชื่อไทย
        /// ex ? , cd Type
        /// </summary>
        public string NameTH { get; set; }

        [JsonProperty("nameus")]
        /// <summary>
        /// ชื่ออังกฤษ
        /// ex ? cd NO
        /// </summary>
        public string NameUS { get; set; }

        [JsonProperty("remark")]
        /// <summary>
        /// หมายเหตุ
        /// ex ? cd NO
        /// </summary>
        public string Remark { get; set; }
    }
}

function initCBO() {
    $.ajax({
        type: "GET",
        url: "/api/Settings/Shared/mDivision",
        data: {},//{email: $("#email").val()},
        success: function (data) {
            var he = $('#cboDivision');
            he.empty();//.trigger("change");  //Clear all items.
            var options = he.get(0).options;
            $.each(data, function (index, value) {
                options[options.length] = new Option(value.text, value.id);
            });
        },
        error: function (req, status, error) {
            //TODO
        }
    });
}