public DatabaseTableRowCounts Constructor(string tableName, long rowCount)
{
DatabaseTableRowCounts target = new DatabaseTableRowCounts(tableName, rowCount);
return(target);
// TODO: add assertions to method DatabaseTableRowCountsTest.Constructor(String, Int64)
}
public string SqlStatement()
{
string result = DatabaseTableRowCounts.SqlStatement();
return(result);
// TODO: add assertions to method DatabaseTableRowCountsTest.SqlStatement()
}
/// <summary>
/// Gets the table row counts.
/// </summary>
/// <param name="database">The database.</param>
/// <returns>
/// table row counts
/// </returns>
public List <DatabaseTableRowCounts> GetTableRowCounts(string database)
{
this.ExecuteUseDatabase(database);
List <DatabaseTableRowCounts> results = new List <DatabaseTableRowCounts>();
DatabaseTableRowCounts resultrow;
string sqlString = DatabaseTableRowCounts.SqlStatement();
sqlString = string.Format("EXEC sp_executesql @statement = N'{0}'", sqlString.Replace("'", "''"));
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
using (SqlCommand command = new SqlCommand(sqlString, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
resultrow = new DatabaseTableRowCounts(
reader.GetString(reader.GetOrdinal("Table")),
reader.GetInt64(reader.GetOrdinal("RowCount")));
results.Add(resultrow);
}
}
connection.Close();
}
return(results);
}
