Microsoft.SqlServer.Management.SqlParser.Native 172.0.1

Microsoft.SqlServer.Management.SqlParser.Native

概述

此 nuget 包提供了 Microsoft.SqlServer.Management.SqlParser 的 MSIL 和本地预先编译 (AoT) 版本，供 Net8.0 应用程序使用。

AoT 二进制文件可由 AoT 控制台应用程序 消费。

有一个专门为使用 C++ 应用程序等本地调用者提供的入口点 - Parse

这是原型

    [System.Text.Json.Serialization.JsonSourceGenerationOptions(PropertyNamingPolicy = System.Text.Json.Serialization.JsonKnownNamingPolicy.CamelCase)]
    [System.Text.Json.Serialization.JsonSerializable(typeof(ParseResultBase))]
    internal partial class ParseResultContext : System.Text.Json.Serialization.JsonSerializerContext
    { 
    }

    public static class NativeApi
    {
        /// <summary>
        /// Native API for parsing TSQL
        /// </summary>
        /// <param name="pString">The text to parse, encoded in UTF 8</param>
        /// <param name="pVersion">An identifier of the version, encoded in UTF8. Can be a number associated with a 
        /// SQL Server version like "160" or a member of the TransactSqlVersion enumeration</param>
        /// <returns></returns>
        [UnmanagedCallersOnly(EntryPoint = "Parse")]
        public static IntPtr Parse(IntPtr pString, IntPtr pVersion)
        {
        }
    }

入门

这是一个示例 C++ 程序，列出调用 Parse 并打印结果的代码。

#include <windows.h>

typedef char* (*parse)(const char*, const char*);

int main()
{
    HMODULE h = ::LoadLibrary(L"win-x64\\native\\Microsoft.SqlServer.Management.SqlParser.dll");
    parse parser = (parse)::GetProcAddress(h, "Parse");
    char* result = parser("sel b from foo", "160");
    printf(result);
}

输出

{"batchCount":1,"parseErrors":[{"message":"Incorrect syntax near \u0027from\u0027.","start":{"lineNumber":1,"columnNumber":7,"offset":6},"end":{"lineNumber":1,"columnNumber":11,"offset":10},"isWarning":false,"type":1}],"resultId":1}