-
Notifications
You must be signed in to change notification settings - Fork 889
Expand file tree
/
Copy pathNpgsqlParameter`.cs
More file actions
122 lines (107 loc) · 4.08 KB
/
Copy pathNpgsqlParameter`.cs
File metadata and controls
122 lines (107 loc) · 4.08 KB
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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
using System;
using System.Data;
using System.Diagnostics;
using System.Threading;
using System.Threading.Tasks;
using Npgsql.Internal;
using NpgsqlTypes;
namespace Npgsql;
/// <summary>
/// A generic version of <see cref="NpgsqlParameter"/> which provides more type safety and
/// avoids boxing of value types. Use <see cref="TypedValue"/> instead of <see cref="NpgsqlParameter.Value"/>.
/// </summary>
/// <typeparam name="T">The type of the value that will be stored in the parameter.</typeparam>
public sealed class NpgsqlParameter<T> : NpgsqlParameter
{
/// <summary>
/// Gets or sets the strongly-typed value of the parameter.
/// </summary>
public T? TypedValue
{
get;
set
{
if (typeof(T) == typeof(object) && ShouldResetObjectTypeInfo(value))
ResetTypeInfo();
else
DisposeBindingState();
field = value;
}
}
/// <summary>
/// Gets or sets the value of the parameter. This delegates to <see cref="TypedValue"/>.
/// </summary>
public override object? Value
{
get => TypedValue;
set => TypedValue = (T)value!;
}
private protected override Type StaticValueType => typeof(T);
#region Constructors
/// <summary>
/// Initializes a new instance of <see cref="NpgsqlParameter{T}" />.
/// </summary>
public NpgsqlParameter() { }
/// <summary>
/// Initializes a new instance of <see cref="NpgsqlParameter{T}" /> with a parameter name and value.
/// </summary>
public NpgsqlParameter(string parameterName, T value)
{
ParameterName = parameterName;
TypedValue = value;
}
/// <summary>
/// Initializes a new instance of <see cref="NpgsqlParameter{T}" /> with a parameter name and type.
/// </summary>
public NpgsqlParameter(string parameterName, NpgsqlDbType npgsqlDbType)
{
ParameterName = parameterName;
NpgsqlDbType = npgsqlDbType;
}
/// <summary>
/// Initializes a new instance of <see cref="NpgsqlParameter{T}" /> with a parameter name and type.
/// </summary>
public NpgsqlParameter(string parameterName, DbType dbType)
{
ParameterName = parameterName;
DbType = dbType;
}
#endregion Constructors
private protected override PgConcreteTypeInfo MakeConcreteForTypedValue(PgTypeInfo typeInfo, out object? providerWriteState)
=> typeInfo.MakeConcreteForValue(
new() { NestedObjectDbNullHandling = ParameterDbNullHandling },
TypedValue,
out providerWriteState);
private protected override PgValueBinding BindTypedValue(PgConcreteTypeInfo concrete, object? providerWriteState, DataFormat? formatPreference)
=> concrete.BindParameterValue(TypedValue, providerWriteState, ParameterDbNullHandling, formatPreference);
private protected override ValueTask WriteTypedValue(bool async, PgConverter converter, PgWriter writer, CancellationToken cancellationToken)
{
Debug.Assert(TypedValue is not null);
if (async)
return converter.WriteAsync(writer, TypedValue, cancellationToken);
converter.Write(writer, TypedValue);
return new ValueTask();
}
private protected override void SetOutputTypedValue(NpgsqlDataReader reader, int ordinal)
=> TypedValue = reader.GetFieldValue<T>(ordinal);
private protected override NpgsqlParameter CloneCore() =>
// use fields instead of properties
// to avoid auto-initializing something like type_info
new NpgsqlParameter<T>
{
_precision = _precision,
_scale = _scale,
_size = _size,
_dbType = _dbType,
_npgsqlDbType = _npgsqlDbType,
_dataTypeName = _dataTypeName,
Direction = Direction,
IsNullable = IsNullable,
_name = _name,
TrimmedName = TrimmedName,
SourceColumn = SourceColumn,
SourceVersion = SourceVersion,
TypedValue = TypedValue,
SourceColumnNullMapping = SourceColumnNullMapping,
};
}