using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

​

    namespace Integration.PatientImport.Service.Infrastructure;             

public class Program

{

    public static void Main()

    {

        List<Guid> guidList = new List<Guid>

{

    Guid.Parse("6F9619FF-8B86-D011-B42D-00C04FC964FF"),

    Guid.Parse("79D4F4A6-AB00-4A7D-B9D9-C3B6B7B994D5"),

    Guid.Parse("A2D5F7C1-3D3E-46B9-95D9-2F2B85B1698D"),

    Guid.Parse("D7CEB15D-1D8E-4A17-9A61-6B895B39F8EB"),

    Guid.Parse("E16B6D2E-CA9F-40C0-891F-1E3F6C61B4A4")

};

​

guidList.Sort(new SqlGuidComparer());

​

foreach (Guid guid in guidList)

{

    Console.WriteLine(guid);

}

    }

}

​

    public class SqlGuidComparer : IComparer<Guid>

{

    public int Compare(Guid x, Guid y)

    {

        byte[] xBytes = x.ToByteArray();

        byte[] yBytes = y.ToByteArray();

​

        // Reverse the byte order of the first 4 bytes to match SQL Server's sorting

        Array.Reverse(xBytes, 0, 4);

        Array.Reverse(yBytes, 0, 4);

​

        // Compare the bytes lexicographically

        for (int i = 0; i < 16; i++)

        {

            int result = xBytes[i].CompareTo(yBytes[i]);

            if (result != 0)

            {

                return result;

            }

        }

​

        return 0;

    }

}