MsSql.Adapter.Generator 1.0.3

MsSql.Adapter.Generator

A Source Generator package that generates methods for a class, including associated request & response classes, based on the result.json file created by dotnet-mssql-collector tool.

This source generator requires the .NET 6 SDK. You can target earlier frameworks like .NET Core 3.1 etc, but the SDK must be at least 6.0.100

Add the package (and required dependencies) to your application using

dotnet add package MsSql.Adapter.Generator
dotnet add package MsSql.Adapter.Standard.Types
dotnet add package MsSql.Adapter.Utils

This adds the <PackageReference> to your project. You can additionally mark the generator package as PrivateAsets="all" and ExcludeAssets="runtime".

Setting PrivateAssets="all" means any projects referencing this one won't get a reference to the MsSql.Adapter.Generator package. Setting ExcludeAssets="runtime" ensures the MsSql.Adapter.Generator.Attributes.dll_ file is not copied to your build output (it is not required at runtime).

<Project Sdk="Microsoft.NET.Sdk.Web">

  <PropertyGroup>
    <TargetFramework>net6.0</TargetFramework>
    <LangVersion>Latest</LangVersion>
  </PropertyGroup>

  ~~~~
  <PackageReference Include="MsSql.Adapter.Generator" Version="1.0.0"
    PrivateAssets="all" ExcludeAssets="runtime" />
  

</Project>

Adding the package will automatically add a marker attribute, [MssqlAdapterAttribute], to your project.

To use the generator, add the [MssqlAdapterAttribute] attribute to a partial class. For example:

namespace Test
{
    [MsSqlAdapter]
    public partial class DalService
    {
    }
}

A class which holds the configuration needs to also exist in the same namespace (class name and properties names can be set in the attribute):

namespace Test
{
    [DataContract]
    public class DalServiceOptions
    {
        [DataMember(Order = 1)]
        public string ConnectionString { get; set; } = "";

        [DataMember(Order = 2)]
        public string? ConnectionUser { get; set; }

        [DataMember(Order = 3)]
        public string? ConnectionPassword { get; set; }
    }
}

This will generate an interface that can be used by the protobuf-net.Grpc. For example:

[ServiceContract(Name = "Test.ExampleDatabase.ExampleDatabaseService")]
public interface IDalService
{

    Task<FirstStoredProcedureResponse> FirstStoredProcedure(FirstStoredProcedureRequest req);
}

Additional files that can be used in javascript to add support for nullable values are generated in obj/GeneratedFiles/javascript/ folder.

For a boilerplate project which creates a gRPC service check MsSql.Adapter