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