สอบถามระหว่างการใช้ libary Mysql เพื่อเชื่อมคิลลี่โดยตรง กับการคิลลี่ mysql ผ่านทาง odbc Linkedserver ทางไหนเป็นที่นิยมหรือมีความเร็วมากกว่ากันครับ

[Route("api/extUtils/BasicSetting/Drug/PostDrugFilterByJDT")]
public IHttpActionResult PostDrugFilterByJDT(AjaxPostModel @params)
{
    int curPageIndex = @params.start; // (req.start / req.length) + 1 
    var sortCol = @params.order;
    var pageSize = @params.length;
    var searchValue = @params.search.value;

    string sCol = "WORKING_CODE";
    string sDir = "ASC";
    if (sortCol.Count > 0)
    {
        sCol = sortCol(0).column;
        sDir = sortCol(0).dir;
    }

    switch (sCol)
    {
        case "0":
            {
                sCol = "WORKING_CODE";
                break;
            }

        case "1":
            {
                sCol = "DRUG_NAME";
                break;
            }

        default:
            {
                sCol = "WORKING_CODE";
                break;
            }
    };

var strSQL = <Suparuck>
DECLARE @rowNumTotal int;
DECLARE @rowNumFilter int;
IF OBJECT_ID('tempdb..#DrugTemp') IS NOT NULL DROP Table #DrugTemp;
SELECT @rownumTotal = COUNT(1) FROM [INV].[dbo].[INV_MD];
SELECT * INTO  #DrugTemp FROM [INV].[dbo].[INV_MD] s
WHERE s.WORKING_CODE LIKE '%<%= searchValue %>%' OR DRUG_NAME LIKE '%<%= searchValue %>%';
SELECT @rowNumFilter = COUNT(1) FROM #DrugTemp;
SELECT *, @rowNumTotal AS rowNumTotal, @rowNumFilter AS rowNumFilter 
FROM #drugtemp ORDER BY <%= sCol + " " + sDir %> OFFSET <%= curPageIndex %> ROWS FETCH NEXT <%= pageSize %> ROWS ONLY;
DROP Table #DrugTemp;
</Suparuck>


    var dt = WL_DatabaseVB.DbHelper.Query(strSQL.Value);
    List<WL_Model.msrINV_MD> lst = new List<WL_Model.msrINV_MD>();
    int rowNumTotal = dt.Rows.Count > 0 ? dt.Rows(0).Item("rowNumTotal") : 0;
    int rowNumFilter = dt.Rows.Count > 0 ? dt.Rows(0).Item("rowNumFilter") : 0;
    dt.AsEnumerable().ToList().ForEach(r =>
    {
        WL_Model.msrINV_MD obj = new WL_Model.msrINV_MD();
        obj.WORKING_CODE = RepairDBNullValue(r.Item("Working_Code"));
        obj.DRUG_NAME = RepairDBNullValue(r.Item("Drug_Name"));
        obj.LOCATION = RepairDBNullValue(r.Item("Location"));
        obj.QTY_ON_HAND = IsDBNull(r.Item("QTY_ON_HAND")) ? 0 : r.Item("QTY_ON_HAND") / (double)IsDBNull(r.Item("STD_RATIO3")) ? 1 : r.Item("STD_RATIO3");
        obj.STD_RATIO3 = RepairDBNullValue(r.Item("STD_RATIO3"));
        obj.SALE_UNIT = RepairDBNullValue(r.Item("Sale_Unit"));
        lst.Add(obj);
    });
    return Ok(new
    {
        xyz = lst,
        error = "",
        recordsTotal = rowNumTotal,
        recordsFiltered = rowNumFilter
    });
}