/// <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;
}