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 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()); }