/// <summary> /// Gets all Blogs in database /// </summary> /// <returns> /// List of Blogs /// </returns> public override List<Blog> FillBlogs() { var blogs = new List<Blog>(); using (var conn = this.CreateConnection()) { if (conn.HasConnection) { using (var cmd = conn.CreateTextCommand(string.Format("SELECT BlogId, BlogName, Hostname, IsAnyTextBeforeHostnameAccepted, StorageContainerName, VirtualPath, IsPrimary, IsActive, IsSiteAggregation FROM {0}Blogs ", this.tablePrefix))) { using (var rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var b = new Blog { Id = rdr.GetGuid(0), Name = rdr.GetString(1), Hostname = rdr.GetString(2), IsAnyTextBeforeHostnameAccepted = rdr.GetBoolean(3), StorageContainerName = rdr.GetString(4), VirtualPath = rdr.GetString(5), IsPrimary = rdr.GetBoolean(6), IsActive = rdr.GetBoolean(7), IsSiteAggregation = rdr.GetBoolean(8) }; blogs.Add(b); b.MarkOld(); } } } } } return blogs; }