CheckOrderByColumn_when_orderBycolumn_is_null_and_columns_is_not_null_returns_default_sort_column_enclosed_by_brackets
()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
string orderbyColumn = null;
var schema = new DataSetSchema()
{
Definition = new DataSetSchemaDefinition()
{
Columns = new List <DataSetSchemaColumn>()
{
new DataSetSchemaColumn()
{
ColumnName = "col1"
}
}
}
};
//act
var result = formatter.CheckOrderByColumn(schema, orderbyColumn);
//assert
Assert.AreEqual("[col1]", result);
//clean up
}
CheckOrderByColumn_when_orderBycolumn_is_NOT_nullOrEmpty_and_orderByColumn_starts_with_and_datasetcolumns_are_empty_returns_orderBycolumn
()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
string orderbyColumn = "[col1_v2]";
var schema = new DataSetSchema();
//act
var result = formatter.CheckOrderByColumn(schema, orderbyColumn);
//assert
Assert.AreEqual("[col1_v2]", result);
//clean up
}
CheckOrderByColumn_when_orderBycolumn_is_NOTnullOrEmpty_and_orderByColumn_does_not_startWith_bracket_returns_orderBy_enclosed_by_brackets
()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
string orderbyColumn = "col1";
var schema = new DataSetSchema();
//act
var result = formatter.CheckOrderByColumn(schema, orderbyColumn);
//assert
Assert.AreEqual("[col1]", result);
//clean up
}