问查询SQLite数据库的行数和列数

EN

namespace SQLiteExtractor
{
    class Program
    {
        static void Main()
        {
            string liteString = @"Data Source = .\testDB.db";
            connectToSQLite(liteString);
        }

        public static void connectToSQLite(string liteConString)
        {
            using SQLiteConnection liteCon = new SQLiteConnection(liteConString);
            liteCon.Open();

            string query = "SELECT * FROM test001";
            int sizeOfDR = 0;
            List<string> liteEntries = new List<string>();

            using var cmd = new SQLiteCommand(query, liteCon);
            using SQLiteDataReader SQLiteDR = cmd.ExecuteReader();

            while (SQLiteDR.Read())
            {
                liteEntries.Add(SQLiteDR.GetString(1));
            }

            foreach (string entry in liteEntries)
                Console.WriteLine(entry);
        }
    }
}