BlogEngine.Core.Providers.DbBlogProvider.FillPackages C# (CSharp) Method

        public override List<InstalledPackage> FillPackages()
        {
            var packages = new List<InstalledPackage>();

            using (var conn = this.CreateConnection())
            {
                if (conn.HasConnection)
                {
                    using (var cmd = conn.CreateTextCommand(string.Format("SELECT PackageId, Version FROM {0}Packages ", tablePrefix)))
                    {
                        using (var rdr = cmd.ExecuteReader())
                        {
                            while (rdr.Read())
                            {
                                var p = new InstalledPackage()
                                {
                                    PackageId = rdr.GetString(0),
                                    Version = rdr.GetString(1)
                                };

                                packages.Add(p);
                            }
                        }
                    }
                }
            }

            return packages;
        }