SQLiteDatabase.ExecuteScalar C# (CSharp) Method

    public string ExecuteScalar(string sql)
    {
        SQLiteConnection cnn = new SQLiteConnection(dbConnection);
        cnn.Open();
        SQLiteCommand mycommand = new SQLiteCommand(cnn);
        mycommand.CommandText = sql;
        object value = mycommand.ExecuteScalar();
        cnn.Close();
        if (value != null)
        {
            return value.ToString();
        }
        return "";
    }

        protected string GetStats()
        {
            long   entitySpaceUsed = long.Parse(db.ExecuteScalar("SELECT SUM(size) FROM entities"));
            long   blockSpaceUsed  = long.Parse(db.ExecuteScalar("SELECT SUM(size) FROM blocks"));
            long   chunks          = long.Parse(db.ExecuteScalar("SELECT count(id) from blocks"));
            long   diffSpace       = entitySpaceUsed - blockSpaceUsed;
            string stats           = "";

            stats += $"Space used for entites => {entitySpaceUsed.GetBytesReadable()}\n";
            stats += $"Space used for blocks => {blockSpaceUsed.GetBytesReadable()}\n";
            stats += $"Space saved => {diffSpace.GetBytesReadable()}\n";
            stats += $"Blocks used => {chunks}\n";
            stats += "\n";
            return(stats);
        }