public ReadFirstColumnAsStringArray ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : string[] | ||
settings | AliaSQL.Core.Model.ConnectionSettings | |
sql | string | |
return | string[] |
public string[] ReadFirstColumnAsStringArray(ConnectionSettings settings, string sql)
{
var list = new List<string>();
string connectionString = _connectionStringGenerator.GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
string item = reader[0].ToString();
list.Add(item);
}
}
}
}
return list.ToArray();
}