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

publicclass SchemaTable
   {
publicvoid 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);
               }
           }
       }
   }
}