/// <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; }