//прочитать всю таблицу
        public DataTable ReadAll(string tableName)
        {
            Connection.Open();
            DataTable dataTable = new DataTable();
            string sqlQuery = $"SELECT * FROM {tableName}";
            using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlQuery, Connection))
            {
                adapter.Fill(dataTable);
            }
            Connection.Close();
            return dataTable;
        }

//прочитать колонку
public object[] ReadColumn(string tableName, string columnName)
        {
            Connection.Open();
            var result = new List<object>(); ;
            string sqlQuery = $"SELECT {columnName} FROM {tableName}";
            SQLCommand = new SQLiteCommand(sqlQuery, Connection);
            SQLiteDataReader reader = SQLCommand.ExecuteReader();
            while (reader.Read())
            {
                result.Add(reader.GetValue(0));
            }
            reader.Close();
            Connection.Close();
            return result.ToArray();
        }

//прочитать ячейку (по ID)
public object ReadCell(string tableName, string columnName, long id)
        {
            Connection.Open();
            object result = null;
            string sqlQuery = $"SELECT {columnName} FROM {tableName} WHERE id = {id}";
            SQLCommand = new SQLiteCommand(sqlQuery, Connection);
            SQLiteDataReader reader = SQLCommand.ExecuteReader();
            while (reader.Read())
            {
                result = reader.GetValue(0);
            }
            reader.Close();
            Connection.Close();
            return result;
        }