}//test method
private void CheckDataType(DbTable dtColumns, string columnName, string dataType, int size = 0)
{
//find row
var colRow = dtColumns.FindRow("column_name", columnName);
Assert.AreEqual(dataType, (string)colRow["Data_Type"], "Data type does not match, column: " + columnName);
if (size > 0)
{
Assert.AreEqual(size, (int)colRow["character_maximum_length"], "Size does not match, column: " + columnName);
}
}