public int ExecuteScalarInteger(ConnectionSettings settings, string sql)
{
string connectionString = _connectionStringGenerator.GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
var server = new Server(new ServerConnection(connection));
return Convert.ToInt32(server.ConnectionContext.ExecuteScalar(sql));
}
}
public void ExecuteNonQuery(ConnectionSettings settings, string sql, bool runAgainstSpecificDatabase)
{
string connectionString = _connectionStringGenerator.GetConnectionString(settings, runAgainstSpecificDatabase);
using (var connection = new SqlConnection(connectionString))
{
var server = new Server(new ServerConnection(connection));
server.ConnectionContext.ExecuteNonQuery(sql);
}
}
public int ExecuteScalarInteger(ConnectionSettings settings, string sql)
{
string connectionString = _connectionStringGenerator.GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
var server = new Server(new ServerConnection(connection));
return(Convert.ToInt32(server.ConnectionContext.ExecuteScalar(sql)));
}
}
public void ExecuteNonQuery(ConnectionSettings settings, string sql, bool runAgainstSpecificDatabase)
{
string connectionString = _connectionStringGenerator.GetConnectionString(settings, runAgainstSpecificDatabase);
using (var connection = new SqlConnection(connectionString))
{
var server = new Server(new ServerConnection(connection));
server.ConnectionContext.ExecuteNonQuery(sql);
}
}
public string[] ReadFirstColumnAsStringArray(ConnectionSettings settings, string sql)
{
var list = new List<string>();
string connectionString = _connectionStringGenerator.GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
var server = new Server(new ServerConnection(connection));
using (SqlDataReader reader = server.ConnectionContext.ExecuteReader(sql))
{
while (reader.Read())
{
string item = reader[0].ToString();
list.Add(item);
}
}
}
return list.ToArray();
}
public string[] ReadFirstColumnAsStringArray(ConnectionSettings settings, string sql)
{
var list = new List <string>();
string connectionString = _connectionStringGenerator.GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
var server = new Server(new ServerConnection(connection));
using (SqlDataReader reader = server.ConnectionContext.ExecuteReader(sql))
{
while (reader.Read())
{
string item = reader[0].ToString();
list.Add(item);
}
}
}
return(list.ToArray());
}
