-
Notifications
You must be signed in to change notification settings - Fork 260
/
SqlCommandExecuteTest.cs
145 lines (133 loc) · 5.07 KB
/
SqlCommandExecuteTest.cs
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
// See the LICENSE file in the project root for more information.
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using Xunit;
namespace Microsoft.Data.SqlClient.ManualTesting.Tests
{
public static class SqlCommandExecuteTest
{
[Theory]
[MemberData(nameof(GetConnectionStrings))]
public static void ExecuteReaderAsyncTest(string connectionString)
{
int counter = 100;
while (counter-- > 0)
{
ExecuteReaderAsync(connectionString, CancellationToken.None).GetAwaiter().GetResult();
}
}
[Theory]
[MemberData(nameof(GetConnectionStrings))]
public static void ExecuteScalarAsyncTest(string connectionString)
{
int counter = 100;
while (counter-- > 0)
{
ExecuteScalarAsync(connectionString, CancellationToken.None).GetAwaiter().GetResult();
}
}
[Theory]
[MemberData(nameof(GetConnectionStrings))]
public static void ExecuteNonQueryAsyncTest(string connectionString)
{
int counter = 100;
while (counter-- > 0)
{
ExecuteNonQueryAsync(connectionString, CancellationToken.None).GetAwaiter().GetResult();
}
}
[Theory]
[MemberData(nameof(GetConnectionStrings))]
public static void ExecuteXmlReaderAsyncTest(string connectionString)
{
int counter = 100;
while (counter-- > 0)
{
ExecuteXmlReaderAsync(connectionString, CancellationToken.None).GetAwaiter().GetResult();
}
}
#region Execute Async
private static async Task ExecuteReaderAsync(string connectionString, CancellationToken token)
{
using (var connection = new SqlConnection(connectionString))
using (var cmd = GetCommand(connection))
using (var r = await cmd.ExecuteReaderAsync(token))
{
while (await r.ReadAsync(token))
{
await r.GetFieldValueAsync<string>(0);
await r.GetFieldValueAsync<string>(1);
await r.GetFieldValueAsync<string>(2);
}
}
}
private static async Task ExecuteScalarAsync(string connectionString, CancellationToken token)
{
using (var connection = new SqlConnection(connectionString))
using (var cmd = GetCommand(connection))
{
await cmd.ExecuteScalarAsync(token);
}
}
private static async Task ExecuteNonQueryAsync(string connectionString, CancellationToken token)
{
using (var connection = new SqlConnection(connectionString))
{
using (var cmd = GetCommand(connection))
{
await cmd.ExecuteNonQueryAsync(token);
}
}
}
private static async Task ExecuteXmlReaderAsync(string connectionString, CancellationToken token)
{
using (var connection = new SqlConnection(connectionString))
{
using (var cmd = GetCommand(connection))
{
cmd.CommandText += " FOR XML AUTO, XMLDATA";
var r = await cmd.ExecuteXmlReaderAsync(token);
}
}
}
private static SqlCommand GetCommand(SqlConnection cnn)
{
string aRecord = "('2455cf1b-ebcf-418d-8cce-88e21e1683e3', 'something', 'updated'),";
string query = "SELECT * FROM (VALUES"
+ string.Concat(Enumerable.Repeat(aRecord, 200)).Substring(0, (aRecord.Length * 200) - 1)
+ ") tbl_A ([Id], [Name], [State])";
cnn.Open();
var cmd = cnn.CreateCommand()
cmd.CommandText = query;
return cmd;
}
#endregion
public static IEnumerable<object[]> GetConnectionStrings()
{
SqlConnectionStringBuilder builder;
foreach (var item in DataTestUtility.ConnectionStrings)
{
builder = new SqlConnectionStringBuilder(item)
{
TrustServerCertificate = true,
Encrypt = true,
MultipleActiveResultSets = false,
ConnectTimeout = 10,
ConnectRetryCount = 3,
ConnectRetryInterval = 10,
LoadBalanceTimeout = 60,
MaxPoolSize = 10,
MinPoolSize = 0
};
yield return new object[] { builder.ConnectionString };
builder.TrustServerCertificate = false;
builder.Encrypt = false;
yield return new object[] { builder.ConnectionString };
}
}
}
}