Adding a new graphql library

[CristianBarragan]

Hi I have made a library to parse graphql queries into raw sql queries using mainly dapper.

Article

I would like to added it as library so the community can benefit from it.

Cheers

[benjie]

Please send a PR

[CristianBarragan]

Cheers @benjie , I dont have permissions to raise a PR

Path: graphql.github.io\src\code\language-support\c-net\server\coffee-beanery.md

---

name: Coffee Beanery
description: High-performance GraphQL-to-SQL execution engine for .NET
url: https://cristianbarragan.github.io/GraphQL-Coffee-Beanery/
github: CristianBarragan/GraphQL-Coffee-Beanery
tags:

• tools-and-libraries
• backend

---

GraphQL-to-SQL engine for .NET. Generate optimized SQL from GraphQL queries using Dapper, eliminate N+1 queries, configure joins through mappings, and customize every layer of the execution pipeline.

using Microsoft.AspNetCore;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Builder;
using Domain.Shared.Extension;
using Microsoft.Extensions.DependencyInjection;

WebHost
    .CreateDefaultBuilder(args)
    .ConfigureServices(services =>
	
		services.AddCoffeeBeanery(connectionString);
		
        builder.Services.AddGraphQLServer()
            .AddQueryType(d =>
            {
                d.Field("wrapper")
                    .ResolveWith<WrapperQueryResolver>(r => r.GetWrapper(default, default,
                        default));
            })
            .AddMutationType(d =>
            {
                d.Name("Mutation");

                d.Field("wrapper")
                    .Argument("wrapper", d => d.Type<WrapperInputType>())
                    .Argument("order", a =>
                        a.Type<AnyType>())
                    .ResolveWith<WrapperMutationResolver>(r => r.UpsertWrapper(default, default, default));
            })
            .SetPagingOptions(new PagingOptions() { DefaultPageSize = 10, IncludeTotalCount = true })
            .AddFiltering()
            .AddType<DynamicSortModule.SortInput>()
            .AddType<EnumType<SortDirection>>()
            .AddTypeModule<DynamicSortModule>()
            .InitializeOnStartup();
	)
    .Configure(builder =>
        builder
            .UseRouting()
            .UseEndpoints(e => e.MapGraphQL()))
    .Build()
    .Run();

public class ProductMappingSet : IMappingSet<CustomerMappingType, Domain.Model.Model>
{
    public void Register(CustomerMappingType type, Domain.Model.Model model)
    {
        new ProductMapping(type.ToString(), model.ToString()).Register();
    }
}

public class ProductMapping : BaseModelMappingRegistration<Product>
{
    public ProductMapping(string alias, string model) : base(alias, model)
    {
    }

    protected override NodeMap BuildMap()
    {
        var map = new NodeMap();

        map.ModelChildren.AddRange(new[]
        {
            new LinkKey
            {
                AliasFrom  = A(nameof(Product)),
                From       = nameof(Product),
                FromColumn = nameof(Product.ContractKey),
                AliasTo    = A(nameof(Contract)),
                To         = nameof(Contract),
                ToColumn   = nameof(Contract.ContractKey)
            }
        });
        
        map.ModelParents.AddRamge(new[]
		{
			new LinkKey
			{
				AliasFrom  = A(nameof(Product)),
				From       = nameof(Product),
				FromColumn = nameof(Product.CustomerKey),
				AliasTo    = A(nameof(Customer)),
				To         = nameof(Customer),
				ToColumn   = nameof(Customer.CustomerKey)
			}
        });

        map.ModelToEntityLinks.AddRange(new[]
        {
            new LinkKey
            {
                AliasFrom  = A(nameof(Product)),
                From       = nameof(Product),
                FromColumn = nameof(Product.ContractKey),
                AliasTo    = A(nameof(DataEntity.Contract)),
                To         = nameof(DataEntity.Contract),
                ToColumn   = nameof(DataEntity.Contract.ContractKey)
            }
        });

        map.FieldMaps.AddRange(new[]
        {
            new FieldMap
            {
                SourceAlias       = A(nameof(Product)),
                DestinationAlias  = A(nameof(DataEntity.Contract)),
                SourceName        = nameof(Product.ContractKey),
                DestinationEntity = nameof(DataEntity.Contract),
                DestinationName   = nameof(DataEntity.Contract.ContractKey)
            },
            new FieldMap
            {
                SourceAlias       = A(nameof(Product)),
                DestinationAlias  = A(nameof(DataEntity.Contract)),
                SourceName        = nameof(Product.ProductType),
                DestinationEntity = nameof(DataEntity.Contract),
                DestinationName   = nameof(DataEntity.Contract.ContractType),
                FromEnum = new Dictionary<string, int>(StringComparer.OrdinalIgnoreCase)
                {
                    { ProductType.CreditCard.ToString(),   (int)ProductType.CreditCard },
                    { ProductType.Mortgage.ToString(),     (int)ProductType.Mortgage },
                    { ProductType.PersonalLoan.ToString(), (int)ProductType.PersonalLoan }
                },
                ToEnum = new Dictionary<string, int>(StringComparer.OrdinalIgnoreCase)
                {
                    { ContractType.CreditCard.ToString(),   (int)ContractType.CreditCard },
                    { ContractType.Mortgage.ToString(),     (int)ContractType.Mortgage },
                    { ContractType.PersonalLoan.ToString(), (int)ContractType.PersonalLoan }
                }
            }
        });

        return map;
    }
}

[benjie]

Please refer to: https://docs.github.com/en/pull-requests/collaborating-with-pull-requests/proposing-changes-to-your-work-with-pull-requests/creating-a-pull-request