/// <summary>
/// Returns the DataBAse XML as a data set use dataset.writexml to write to a file
/// </summary>
/// <returns></returns>
public DataSet GetDataSetFromDb()
{
var sqldb = new SqlUnitTest(_connectionString);
sqldb.ReadXmlSchema(_xmlSchema);
return(sqldb.GetDataSetFromDb());
}
/// <summary>
/// Get an Xml string of the passed in list of tables.
/// </summary>
/// <param name="tablesInXml">The Xml file of tables that is to be used.</param>
/// <param name="sqlDatabase">The sqlDatabase to be used.</param>
/// <returns>a string of the data from the tables requested.</returns>
public string GetXmlFromDataBase(StringCollection tablesInXml, SqlUnitTest sqlDatabase)
{
return(sqlDatabase.GetDataSetFromDb(tablesInXml).GetXml());
}