CoreEx/src/CoreEx.Database.SqlServer/SqlServerExtensions.Parameters.cs at main · Avanade/CoreEx · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
namespace CoreEx.Database.SqlServer;

public static partial class SqlServerExtensions
{
    /// <summary>
    /// Adds the named parameter and value, using the specified <see cref="SqlDbType"/> and <see cref="ParameterDirection"/>, to the <see cref="DbCommand.Parameters"/>.
    /// </summary>
    /// <param name="parameters">The <see cref="DatabaseParameterCollection"/>.</param>
    /// <param name="name">The parameter name.</param>
    /// <param name="value">The parameter value.</param>
    /// <param name="sqlDbType">The parameter <see cref="SqlDbType"/>.</param>
    /// <param name="direction">The <see cref="ParameterDirection"/> (default to <see cref="ParameterDirection.Input"/>).</param>
    /// <returns>A <see cref="DbParameter"/>.</returns>
    public static SqlParameter AddParameter<T>(this DatabaseParameterCollection parameters, string name, T? value, SqlDbType? sqlDbType = null, ParameterDirection direction = ParameterDirection.Input)
    {
        var p = (SqlParameter)parameters.ThrowIfNull().Database.CreateParameter();
        p.ParameterName = DatabaseParameterCollection.ParameterizeName(name);
        if (sqlDbType.HasValue)
            p.SqlDbType = sqlDbType.Value;

        p.Value = DatabaseParameterCollection.ConvertToDbValue(value, parameters.Database);
        p.Direction = direction;

        parameters.Add(p);
        return p;
    }

    /// <summary>
    /// Adds the named parameter and value, using the specified <see cref="SqlDbType"/> and <see cref="ParameterDirection"/>.
    /// </summary>
    /// <param name="parameters">The <see cref="DatabaseParameterCollection"/>.</param>
    /// <param name="name">The parameter name.</param>
    /// <param name="value">The parameter value.</param>
    /// <param name="sqlDbType">The parameter <see cref="SqlDbType"/>.</param>
    /// <param name="direction">The <see cref="ParameterDirection"/> (default to <see cref="ParameterDirection.Input"/>).</param>
    /// <returns></returns>
    public static TSelf Param<TSelf, T>(this IDatabaseParameters<TSelf> parameters, string name, T? value, SqlDbType? sqlDbType = null, ParameterDirection direction = ParameterDirection.Input)
    {
        parameters.ThrowIfNull().Parameters.AddParameter(name, value, sqlDbType, direction);
        return (TSelf)parameters;
    }

    /// <summary>
    /// Adds a named parameter and value <paramref name="when"/> <see langword="true"/>.
    /// </summary>
    /// <typeparam name="TSelf">The owning <see cref="Type"/>.</typeparam>
    /// <typeparam name="T">The parameter <see cref="Type"/>.</typeparam>
    /// <param name="parameters">The <see cref="IDatabaseParameters{TSelf}"/>.</param>
    /// <param name="when">Adds the parameter when <see langword="true"/>.</param>
    /// <param name="name">The parameter name.</param>
    /// <param name="value">The parameter value.</param>
    /// <param name="sqlDbType">The parameter <see cref="SqlDbType"/>.</param>
    /// <param name="direction">The <see cref="ParameterDirection"/> (default to <see cref="ParameterDirection.Input"/>).</param>
    /// <returns>The <see cref="DatabaseParameterCollection"/> to support fluent-style method-chaining.</returns>
    public static TSelf ParamWhen<TSelf, T>(this IDatabaseParameters<TSelf> parameters, bool? when, string name, Func<T> value, SqlDbType sqlDbType, ParameterDirection direction = ParameterDirection.Input)
    {
        parameters.ThrowIfNull();
        value.ThrowIfNull();

        if (when == true)
            parameters.Parameters.AddParameter(name, value(), sqlDbType, direction);

        return (TSelf)parameters;
    }

    /// <summary>
    /// Adds a named parameter when invoked <paramref name="with"/> a non-default value.
    /// </summary>
    /// <typeparam name="TSelf">The owning <see cref="Type"/>.</typeparam>
    /// <typeparam name="TWith">The with <see cref="Type"/>.</typeparam>
    /// <typeparam name="TValue">The parameter <see cref="Type"/>.</typeparam>
    /// <param name="parameters">The <see cref="IDatabaseParameters{TSelf}"/>.</param>
    /// <param name="with">The value <b>with</b> which to verify is non-default.</param>
    /// <param name="name">The parameter name.</param>
    /// <param name="value">The parameter value.</param>
    /// <param name="sqlDbType">The parameter <see cref="SqlDbType"/>.</param>
    /// <param name="direction">The <see cref="ParameterDirection"/> (default to <see cref="ParameterDirection.Input"/>).</param>
    /// <returns>The current <see cref="DatabaseParameterCollection"/> instance to support chaining (fluent interface).</returns>
    public static TSelf ParamWith<TSelf, TWith, TValue>(this IDatabaseParameters<TSelf> parameters, TWith? with, string name, Func<TValue> value, SqlDbType sqlDbType, ParameterDirection direction = ParameterDirection.Input)
        => ParamWhen(parameters, with is not null && !EqualityComparer<TWith>.Default.Equals(with, default!), name, value, sqlDbType, direction);

    /// <summary>
    /// Adds a named parameter when invoked <paramref name="with"/> a non-default value.
    /// </summary>
    /// <typeparam name="TSelf">The owning <see cref="Type"/>.</typeparam>
    /// <typeparam name="T">The parameter <see cref="Type"/>.</typeparam>
    /// <param name="parameters">The <see cref="IDatabaseParameters{TSelf}"/>.</param>
    /// <param name="with">The value <b>with</b> which to verify is non-default.</param>
    /// <param name="name">The parameter name.</param>
    /// <param name="value">The parameter value; where not specified the <paramref name="with"/> value will be used.</param>
    /// <param name="sqlDbType">The parameter <see cref="SqlDbType"/>.</param>
    /// <param name="direction">The <see cref="ParameterDirection"/> (default to <see cref="ParameterDirection.Input"/>).</param>
    /// <returns>The current <see cref="DatabaseParameterCollection"/> instance to support chaining (fluent interface).</returns>
    public static TSelf ParamWith<TSelf, T>(this IDatabaseParameters<TSelf> parameters, T? with, string name, Func<T>? value, SqlDbType sqlDbType, ParameterDirection direction = ParameterDirection.Input)
        => ParamWhen(parameters, with is not null && !EqualityComparer<T>.Default.Equals(with, default!), name, value ?? (() => with!), sqlDbType, direction);
}