/
SQLUtil.cs
70 lines (56 loc) · 1.87 KB
/
SQLUtil.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
using System;
using System.Data.SqlClient;
namespace SSRSMigrate.Utility
{
public static class SQLUtil
{
private static Func<string> getConnectionStringFunc;
public static void Initialize(Func<string> connectionStringFunc)
{
if (connectionStringFunc == null)
throw new ArgumentException("connectionStringFunc");
getConnectionStringFunc = connectionStringFunc;
}
private static SqlConnection GetConnection()
{
string connectionString = getConnectionStringFunc();
SqlConnection conn = new SqlConnection(connectionString);
return conn;
}
public static T ExecuteScalar<T>(string query)
{
return Execute<T>(c => c.ExecuteScalar<T>(query));
}
public static int ExecuteNonQuery(string query)
{
return Execute<int>(c => c.ExecuteNonQuery(query));
}
private static T Execute<T>(Func<SqlConnection, T> func)
{
if (getConnectionStringFunc == null)
throw new NullReferenceException("SQLUtil must be initialized first by calling Initialize.");
using (SqlConnection conn = GetConnection())
{
conn.Open();
return func(conn);
}
}
#region SqlConnection Extensions
public static T ExecuteScalar<T>(this SqlConnection conn, string query)
{
using (var command = new SqlCommand(query, conn))
{
return (T)command.ExecuteScalar();
}
}
public static int ExecuteNonQuery(this SqlConnection conn, string query)
{
using (var command = new SqlCommand(query, conn))
{
return command.ExecuteNonQuery();
}
}
#endregion
}
}