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

为什么80%的码农都做不了架构师？>>>   

 

数据库连接如下:

<add key="BusinessDbConnection" value="Data Source=localhost;Initial Catalog=PRM;User Id = sa ; Password = "@sa ;" />

 

代码如下:

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

 

希望能起点而参考作用.

 

转载于:https://my.oschina.net/iwenr/blog/227928