unQuery/src/unQuery.PerformanceTests/GetRowTests.cs at 81344b7a36f9a8ea68bdc1b138008d967bcfb229 · improvedk/unQuery · 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
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
using NUnit.Framework;
using System;
using System.Data;
using Microsoft.Data.SqlClient;
using unQuery.SqlTypes;

namespace unQuery.PerformanceTests
{
	public class GetRowTests : TestFixture
	{
		[Test]
		public TestResult Typed_NoParameters()
		{
			return RunTest(5.5,
				() =>
				{
					using (var conn = GetOpenConnection())
					using (var cmd = new SqlCommand("SELECT name, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'", conn))
					{
						var reader = cmd.ExecuteReader();
						reader.Read();

						var obj = new SysAllObject {
							name = (string)reader["name"],
							create_date = (DateTime)reader["create_date"],
							object_id = (int)reader["object_id"],
							schema_id = (int)reader["schema_id"],
							type = (string)reader["type"]
						};
					}
				},
				() => {
					var obj = DB.GetRow<SysAllObject>("SELECT name, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'");
				}
			);
		}

		[Test]
		public TestResult Typed_FiveParameters()
		{
			return RunTest(10,
				() =>
				{
					using (var conn = GetOpenConnection())
					using (var cmd = new SqlCommand("SELECT @Name AS name, @CreateDate AS create_date, @ObjectID AS object_id, @SchemaID AS schema_id, @Type AS type", conn))
					{
						cmd.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = "name";
						cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = DateTime.Now;
						cmd.Parameters.Add("@ObjectID", SqlDbType.Int).Value = 25;
						cmd.Parameters.Add("@SchemaID", SqlDbType.Int).Value = 27;
						cmd.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = "type";

						var reader = cmd.ExecuteReader();
						reader.Read();

						var obj = new SysAllObject {
							name = (string)reader["name"],
							create_date = (DateTime)reader["create_date"],
							object_id = (int)reader["object_id"],
							schema_id = (int)reader["schema_id"],
							type = (string)reader["type"]
						};
					}
				},
				() =>
				{
					var obj = DB.GetRow<SysAllObject>("SELECT @Name AS name, @CreateDate AS create_date, @ObjectID AS object_id, @SchemaID AS schema_id, @Type AS type", new {
						Name = Col.VarChar("name", 100),
						CreateDate = Col.DateTime(DateTime.Now),
						ObjectID = 25,
						SchemaID = 27,
						Type = Col.VarChar("type", 20)
					});
				}
			);
		}

		[Test]
		public TestResult Dynamic_NoParameters()
		{
			return RunTest(1,
				() =>
				{
					using (var conn = GetOpenConnection())
					using (var cmd = new SqlCommand("SELECT name, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'", conn))
					{
						var reader = cmd.ExecuteReader();
						reader.Read();

						dynamic obj = new {
							name = (string)reader["name"],
							create_date = (DateTime)reader["create_date"],
							object_id = (int)reader["object_id"],
							schema_id = (int)reader["schema_id"],
							type = (string)reader["type"]
						};
					}
				},
				() => {
					var obj = DB.GetRow("SELECT name, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'");
				}
			);
		}

		[Test]
		public TestResult Dynamic_FiveParameters()
		{
			return RunTest(4,
				() =>
				{
					using (var conn = GetOpenConnection())
					using (var cmd = new SqlCommand("SELECT @Name AS name, @CreateDate AS create_date, @ObjectID AS object_id, @SchemaID AS schema_id, @Type AS type", conn))
					{
						cmd.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = "name";
						cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = DateTime.Now;
						cmd.Parameters.Add("@ObjectID", SqlDbType.Int).Value = 25;
						cmd.Parameters.Add("@SchemaID", SqlDbType.Int).Value = 27;
						cmd.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = "type";

						var reader = cmd.ExecuteReader();
						reader.Read();

						dynamic obj = new {
							name = (string)reader["name"],
							create_date = (DateTime)reader["create_date"],
							object_id = (int)reader["object_id"],
							schema_id = (int)reader["schema_id"],
							type = (string)reader["type"]
						};
					}
				},
				() => {
					var obj = DB.GetRow("SELECT @Name AS name, @CreateDate AS create_date, @ObjectID AS object_id, @SchemaID AS schema_id, @Type AS type", new {
						Name = Col.VarChar("name", 100),
						CreateDate = Col.DateTime(DateTime.Now),
						ObjectID = 25,
						SchemaID = 27,
						Type = Col.VarChar("type", 20)
					});
				}
			);
		}
	}
}