public void Create_Default()
{
var test = new GetColumnNamesFromTableQuery("test1", "test2");
Assert.Equal("test1", test.ConnectionString);
Assert.Equal("test2", test.TableName);
}
/// <inheritdoc />
public void Handle(GetColumnNamesFromTableQuery query, IDbCommand dbCommand, CommandStringTypes commandType)
{
dbCommand.CommandText =
_commandCache.GetCommand(commandType, query.TableName);
var parameter = dbCommand.CreateParameter();
parameter.ParameterName = "@TableName";
parameter.DbType = DbType.AnsiString;
parameter.Value = query.TableName;
dbCommand.Parameters.Add(parameter);
}
public List <string> Handle(GetColumnNamesFromTableQuery query)
{
var columns = new List <string>();
using (var connection = _dbConnectionFactory.Create())
{
connection.Open();
using (var command = connection.CreateCommand())
{
_prepareQuery.Handle(query, command, CommandStringTypes.GetColumnNamesFromTable);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
columns.Add(_readColumn.ReadAsString(CommandStringTypes.GetColumnNamesFromTable, 0, reader));
}
}
}
}
return(columns);
}
/// <summary>
/// Handles the specified query.
/// </summary>
/// <param name="query">The query.</param>
/// <returns></returns>
public List <string> Handle(GetColumnNamesFromTableQuery query)
{
return(!_databaseExists.Exists(_connectionInformation.ConnectionString) ? new List <string>(0) : _decorated.Handle(query));
}
public void Create_Default()
{
var test = new GetColumnNamesFromTableQuery("test1", "test2");
Assert.Equal("test1", test.ConnectionString);
Assert.Equal("test2", test.TableName);
}
/// <inheritdoc />
public void Handle(GetColumnNamesFromTableQuery query, IDbCommand dbCommand, CommandStringTypes commandType)
{
//table name needs to be lower case
_decorated.Handle(new GetColumnNamesFromTableQuery(query.ConnectionString, query.TableName.ToLowerInvariant()), dbCommand,
commandType);
}
