/// <summary>
/// Recuperar informações de uma base de dados
/// </summary>
/// <param name="dbInfo">Parâmetros de acesso ao banco</param>
/// <returns>Informações de uma base de dados</returns>
public List <ICaptionDescription> GetDataBaseInfo(IParametrosAcessoBanco dbInfo)
{
if (dbInfo.TipoBanco == TipoBancoEnum.SqlServer)
{
var builder = new SqlConnectionStringBuilder()
{
DataSource = dbInfo.ServerName,
InitialCatalog = dbInfo.DataBaseName,
IntegratedSecurity = dbInfo.IntegratedSecurity,
UserID = dbInfo.UserName,
Password = dbInfo.Password
};
using (var connection = new SqlConnection(builder.ToString()))
{
connection.Open();
const string sql = "SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES";
using (var command = new SqlCommand(sql, connection))
{
var total = command.ExecuteScalar();
return(new List <ICaptionDescription>
{
new CaptionAndDescription("Total de tabelas", Convert.ToInt32(total).ToString())
});
}
}
}
return(new List <ICaptionDescription>());
}
public MeuDicionarioObj(TableModel tableModel, IParametrosAcessoBanco dbInfo)
{
Tabela = tableModel;
_dbInfo = dbInfo;
}
