DotNet.WinForm.Example/Schema.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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

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

namespace DotNet.Example
{
    using DotNet.Business;
    using DotNet.Utilities;

    public class Schema
    {
        public void GetSchema()
        {
            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 tableType = dataRow["TABLE_TYPE"].ToString();
                string commandText = "SELECT COUNT(1) FROM " + tableName;
                int rowCount = int.Parse(DbHelper.ExecuteScalar(commandText).ToString());
                if (rowCount > 1000)
                {
                    System.Console.WriteLine("{0,8} {1,20} {2}", rowCount, tableName, tableType);
                }
            }
        }
    }
}