using System;

using Microsoft.SemanticKernel.Connectors.SqlServer;

using Microsoft.Data.SqlClient;

​

//Notes:

// https://github.com/microsoft/semantic-kernel

// https://github.com/microsoft/semantic-kernel/releases

// https://github.com/microsoft/semantic-kernel/commit/f34bcf5c2cee29dc63dee534105c046a81cd9e7a

// https://github.com/microsoft/semantic-kernel/pull/11042

// https://www.nuget.org/packages/Microsoft.SemanticKernel.Connectors.SqlServer/

// https://learn.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlconnectionstringbuilder?view=sqlclient-dotnet-core-6.0

// https://stackoverflow.com/questions/15631602/how-can-i-set-an-sql-server-connection-string

//1.41

// https://github.com/microsoft/semantic-kernel/blob/dotnet-1.41.0/dotnet/src/Connectors/Connectors.Memory.SqlServer/SqlServerVectorStore.cs

// https://github.com/microsoft/semantic-kernel/blob/dotnet-1.41.0/dotnet/src/Connectors/VectorData.Abstractions/VectorStorage/IVectorStore.cs

//1.42

// https://github.com/microsoft/semantic-kernel/blob/dotnet-1.42.0/dotnet/src/Connectors/Connectors.Memory.SqlServer/SqlServerVectorStore.cs

//1.46

// https://github.com/microsoft/semantic-kernel/blob/dotnet-1.46.0/dotnet/src/Connectors/Connectors.Memory.SqlServer/SqlServerVectorStore.cs

//1.54

// https://github.com/microsoft/semantic-kernel/blob/dotnet-1.54.0/dotnet/src/Connectors/Connectors.Memory.SqlServer/SqlServerVectorStore.cs

// https://github.com/microsoft/semantic-kernel/blob/dotnet-1.54.0/dotnet/src/Connectors/VectorData.Abstractions/VectorStorage/VectorStore.cs

​

#nullable enable

​

    public static class DisposableExtensions

    {

        public struct PossiblyDisposableWrapperStruct<T> : IDisposable where T : class

        {

            public T Value { get; } = null!;

            public PossiblyDisposableWrapperStruct(T value) => this.Value = value;

            public void Dispose() => (Value as IDisposable)?.Dispose();

        }

​

        public static PossiblyDisposableWrapperStruct<T> AsDisposable<T>(this T value) where T : class =>  new PossiblyDisposableWrapperStruct<T>(value);

    }

​

​

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Environment version: {0} ({1}), {2}", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , Environment.Version, Environment.OSVersion);

        Console.WriteLine("{0} version: {1}\n", typeof(SqlServerVectorStore).Assembly.GetName().Name,  typeof(SqlServerVectorStore).Assembly.FullName);

        SqlServerVectorStore savedValue;

        SqlConnectionStringBuilder sConnB = new SqlConnectionStringBuilder ()

        {

            DataSource = "ServerName",

            InitialCatalog = "DatabaseName",

            UserID = "UserName",

            Password = "UserPassword"

        };

        var connectionString = sConnB.ConnectionString;

        using (var wrapper = new SqlServerVectorStore(connectionString).AsDisposable())

        {

            var vectorStore = wrapper.Value;

            //...

            // Use the vectorStore somehow

            Console.WriteLine(vectorStore is IDisposable);

            savedValue = vectorStore;

        }

    }

}