C# GetSchema Get List of Table 获取数据库中所有的表名以及表中的纪录条数的方法

// --------------------------------------------------------------------
//  All Rights Reserved , Copyright (C) 2011 , Hairihan TECH, Ltd. 
// --------------------------------------------------------------------

using System.Data;
using System.Data.SqlClient;

namespace DotNet.Example
{
     using DotNet.BaseManager;
     using DotNet.Utilities;
     using DotNet.DbUtilities;

     public  class SchemaTable
    {
         public  void GetSchemaTable()
        {
            SqlConnection connection =  new SqlConnection(BaseSystemInfo.BusinessDbConnection);
            connection.Open();
            DataTable dt = connection.GetSchema( " Tables ");
            connection.Close();
             foreach (DataRow dataRow  in dt.Rows)
            {
                 string tableName = dataRow[ " TABLE_NAME "].ToString();
                 string commandText =  " SELECT COUNT(*) FROM  " + tableName;
                 int rowCount =  int.Parse(DbHelper.ExecuteScalar(commandText).ToString());
                 if (rowCount >  1000)
                {
                    System.Console.WriteLine( " {0,8} {1} ", rowCount, tableName);
                }
            }
        }
    }
}

本文转自jirigala_bao 51CTO博客，原文链接:http://blog.51cto.com/jirigala/812757