MatchesSql with named paramters

[milomg]

.Where(x => x.MatchesSql) currently doesn't allow for ? or repeating a parameter in SQL queries. I'm currently using a custom LINQ operator that supports an anonymous object for parameters. However, it would be nice to have this ability built in to Marten.

My current implementation looks like this and can probably be merged with MatchesSql:

public static class MatchesSqlNamedExtensions
{
    public static bool MatchesSqlNamed(this object doc, string sql, object parameters)
    {
        return true;
    }
}

public class NamedWhereFragment : IWhereFragment
{
    private readonly string _sql;
    private readonly IDictionary<string, object> _parameters;

    public NamedWhereFragment(string sql, IDictionary<string, object> parameters)
    {
        _sql = sql;
        _parameters = parameters;
    }

    public void Apply(CommandBuilder builder)
    {
        var sql = _sql;
        _parameters.Each(x =>
        {
            var param = builder.AddParameter(x.Value);
            sql = sql.Replace(":" + x.Key, ":" + param.ParameterName);
        });
        builder.Append(sql);
    }

    public bool Contains(string sqlText)
    {
        return _sql.Contains(sqlText);
    }
}

public class MatchesSqlNamedParser : IMethodCallParser
{
    private static readonly MethodInfo _sqlMethod =
        typeof(MatchesSqlNamedExtensions).GetMethod(nameof(MatchesSqlNamedExtensions.MatchesSqlNamed), new[] { typeof(object), typeof(string), typeof(object) });

    public bool Matches(MethodCallExpression expression)
    {
        return Equals(expression.Method, _sqlMethod);
    }

    public IWhereFragment Parse(IQueryableDocument mapping, ISerializer serializer, MethodCallExpression expression)
    {
        if (expression.Method.Equals(_sqlMethod))
        {
            var parameters = expression.Arguments[2].Value();
            return new NamedWhereFragment(
                expression.Arguments[1].Value().As<string>(), 
                parameters.GetType().GetProperties().ToDictionary(x => x.Name, x => x.GetValue(parameters, null))
            );
        }

        return null;
    }
}