public void SqlTables(
[Argument(Help = "Identificação da fonte de dados")]
string dataSource,
[Argument(Help = "String de ligação ao servidor de SQL, e.g. 'Server=SqlServerTestMachine;Trusted_Connection=True;'")]
string connectionString,
[Argument(Help = "Identificador da base de dados")]
string catalogName,
[Argument(Help = "Identificador(es) da(s) tabela(s)", IsRequired = false)]
string[] tableNameCollection = null)
{
try
{
App.Console.WriteWithColor("A enviar solicitação ao servidor...", false, ConsoleColor.Yellow);
var producerFacade = ServiceProvider.GetService <IRelationalDatabasesProducerService>();
RelationalDatabaseDataSet results =
tableNameCollection != null
? producerFacade.GetTables(dataSource, connectionString,
CatalogName.FromArray(new[] { catalogName }), TableName.FromArray(tableNameCollection))
: producerFacade.GetTables(dataSource, connectionString,
CatalogName.FromArray(new[] { catalogName }));
App.Console.WriteWithColor("A receber resposta do servidor.", false, ConsoleColor.Yellow);
string output = TableViewExtensions.ToTableView(results.Table).Build().ToString();
App.Console.Write(output, true);
}
catch
{
// ignored
}
}
