public void DeleteExistingBlogger(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
Blogger blogger = GetBloggerByID(id);
//first check if the blogger has blogs
List<Blog> blogs = GetBlogsByBloggerId(blogger.BloggerID);
//if there are blogs, for each blog start with deleting posts
if (blogs.Count > 0)
{
foreach (Blog blog in blogs)
{
List<Post> posts = GetPostsByBlogID(blog.BlogID);
if (posts.Count > 0)
{
foreach (Post post in posts)
{
db.Posts.Remove(post);
}
}
//then, delete all blogs which are now empty
db.Blogs.Remove(blog);
}
}
//finally, delete the blogger
db.Bloggers.Remove(blogger);
db.SaveChanges();
}
}
/// <summary>
/// Returns a single Log event
/// </summary>
/// <param name="id">Id of the log event as a string</param>
/// <returns>A single Log event</returns>
public LogEntry GetById(string id)
{
RecipesEntities db = new RecipesEntities();
int iId;
if(Int32.TryParse(id, out iId))
return db.LogEntries.Find(iId);
return null;
}
public void AddNewPost(Post post)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
db.Posts.Add(post);
db.SaveChanges();
}
}
public void AddNewBlogger(Blogger blogger)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
db.Bloggers.Add(blogger);
db.SaveChanges();
}
}
public void DeleteExistingBlog(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
Blog blog = GetBlogByID(id);
//if posts exist, delete posts
List<Post> posts = GetPostsByBlogID(blog.BlogID);
if (posts.Count > 0)
{
foreach (Post post in posts)
{
db.Posts.Remove(post);
}
}
//then delete blog
db.Blogs.Remove(blog);
db.SaveChanges();
}
}
public static void Execute(RecipesEntities context)
{
try
{
//recipes
AddBasicRecipeData.Execute(context);
AddDetailedRecipeData.Execute(context);
//blogs
AddBlogEngineBloggerData.PopulateBloggers(context);
AddBlogEngineBlogData.PopulateBlogs(context);
AddBlogPostData.AddPosts(context);
//yahoo
AddYahoo.AddSymbols(context);
//logging
AddLogRelevantData.Execute(context);
}
catch (DbEntityValidationException vex)
{
foreach (var err in vex.EntityValidationErrors)
{
foreach (var err2 in err.ValidationErrors)
{
string msg = err2.ErrorMessage;
}
}
}
}
public void DeleteExistingPost(Post post)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
db.Posts.Remove(post);
db.SaveChanges();
}
}
public List<Blog> GetAllBlogs()
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return db.Blogs.ToList();
}
}
public void EditExistingPost(Post post)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
db.Entry(post).State = EntityState.Modified;
db.SaveChanges();
}
}
public int TotalPostsForLabel(int blogId, string label)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
Label lbl = db.Labels.Single(l => l.Name == label);
List<int> postIds = db.PostLabels
.Where(pl => pl.LabelID == lbl.LabelID)
.Select(p => p.PostID).ToList();
return GetPostsByBlogID(blogId)
.Where(p => postIds.Contains(p.PostID)).Count();
}
}
public List<Label> GetAllLabels()
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return db.Labels.Include(p => p.PostLabels).ToList();
}
}
public Blog GetBlogByID(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
Logger.WriteEntry(string.Format("Blog with id={0} returned by method {1}.", id, methodName), GetType().FullName, (int)LogTypeNames.Info);
return db.Blogs.Find(id);
}
}
public int TotalPosts(int blogId)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return GetPostsByBlogID(blogId).Count();
}
}
public static void AddPosts(RecipesEntities context)
{
List<Post> posts = new List<Post>{
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12082012_b, RestOfContent = BlogPostsProgramming.content_12082012_r, Keywords = BlogPostsProgramming.content_12082012_k, Description = BlogPostsProgramming.content_12082012_d, DateCreated = new DateTime(2012, 8, 12), PostID = 1, Title = "Securing Access to Windows 7 Folder from Everyone but a Single User", BloggerUrl = "http://justmycode.blogspot.com/2012/08/securing-access-to-windows-7-folder.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_03102012_b, RestOfContent = BlogPostsProgramming.content_03102012_r, Keywords = BlogPostsProgramming.content_03102012_k, Description = BlogPostsProgramming.content_03102012_d, DateCreated = new DateTime(2012, 10, 3), PostID = 2, Title = "jQuery Show/Hide Toggle", BloggerUrl = "http://justmycode.blogspot.com/2012/10/jquery-showhide-toggle.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07092012_b, RestOfContent = BlogPostsProgramming.content_07092012_r, Keywords = BlogPostsProgramming.content_07092012_k, Description = BlogPostsProgramming.content_07092012_d, DateCreated = new DateTime(2012, 9, 7), PostID = 3, Title = "Playing with Google Search Results ", BloggerUrl = "http://justmycode.blogspot.com/2012/09/playing-with-google-search-results-2.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_08112012_b, RestOfContent = BlogPostsProgramming.content_08112012_r, Keywords = BlogPostsProgramming.content_08112012_k, Description = BlogPostsProgramming.content_08112012_d, DateCreated = new DateTime(2012, 11, 8), PostID = 4, Title = "Yahoo Data Download", BloggerUrl = "http://justmycode.blogspot.com/2012/11/yahoo-data-download.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25102012_b, RestOfContent = BlogPostsProgramming.content_25102012_r, Keywords = BlogPostsProgramming.content_25102012_k, Description = BlogPostsProgramming.content_25102012_d, DateCreated = new DateTime(2012, 10, 25), PostID = 5, Title = "Automating Website Authentication", BloggerUrl = "http://justmycode.blogspot.com/2012/10/automating-website-authentication.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14102012_b, RestOfContent = BlogPostsProgramming.content_14102012_r, Keywords = BlogPostsProgramming.content_14102012_k, Description = BlogPostsProgramming.content_14102012_d, DateCreated = new DateTime(2012, 10, 14), PostID = 6, Title = "Crystal Reports, C#, Object as Data Source", BloggerUrl = "http://justmycode.blogspot.com/2012/10/crystal-reports-c-object-as-data-source.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07102012_b, RestOfContent = BlogPostsProgramming.content_07102012_r, Keywords = BlogPostsProgramming.content_07102012_k, Description = BlogPostsProgramming.content_07102012_d, DateCreated = new DateTime(2012, 10, 7), PostID = 7, Title = "A Simple Show/Hide Technique with jQuery", BloggerUrl = "http://justmycode.blogspot.com/2012/10/a-simple-showhide-technique-with-jquery.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_27092012_b, RestOfContent = BlogPostsProgramming.content_27092012_r, Keywords = BlogPostsProgramming.content_27092012_k, Description = BlogPostsProgramming.content_27092012_d, DateCreated = new DateTime(2012, 9, 27), PostID = 8, Title = "Playing With Google Search Results - 2", BloggerUrl = "http://justmycode.blogspot.com/2012/09/playing-with-google-search-results-2.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_13092012_b, RestOfContent = BlogPostsProgramming.content_13092012_r, Keywords = BlogPostsProgramming.content_13092012_k, Description = BlogPostsProgramming.content_13092012_d, DateCreated = new DateTime(2012, 9, 13), PostID = 9, Title = "Learning MVC: No parameterless constructor defined for this object", BloggerUrl = "http://justmycode.blogspot.com/2012/09/learning-mvc-no-parameterless.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11092012_b, RestOfContent = BlogPostsProgramming.content_11092012_r, Keywords = BlogPostsProgramming.content_11092012_k, Description = BlogPostsProgramming.content_11092012_d, DateCreated = new DateTime(2012, 9, 11), PostID = 10, Title = "Running an Command Line Program in C# and Getting Output", BloggerUrl = "http://justmycode.blogspot.com/2012/09/running-command-line-program-in-c-and.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09082012_b, RestOfContent = BlogPostsProgramming.content_09082012_r, Keywords = BlogPostsProgramming.content_09082012_k, Description = BlogPostsProgramming.content_09082012_d, DateCreated = new DateTime(2012, 8, 9), PostID = 11, Title = "Learning MVC: Display a Custom Error Page, Log Error and Send Email", BloggerUrl = "http://justmycode.blogspot.com/2012/08/learning-mvc-display-custom-error-page.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06082012_b, RestOfContent = BlogPostsProgramming.content_06082012_r, Keywords = BlogPostsProgramming.content_06082012_k, Description = BlogPostsProgramming.content_06082012_d, DateCreated = new DateTime(2012, 8, 6), PostID = 12, Title = "Learning MVC: Game of Life in MVC", BloggerUrl = "http://justmycode.blogspot.com/2012/08/learning-mvc-game-of-life-in-mvc.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05082012_b, RestOfContent = BlogPostsProgramming.content_05082012_r, Keywords = BlogPostsProgramming.content_05082012_k, Description = BlogPostsProgramming.content_05082012_d, DateCreated = new DateTime(2012, 8, 5), PostID = 13, Title = "The Case of a Strangely Coloured ProgressBar", BloggerUrl = "http://justmycode.blogspot.com/2012/08/the-case-of-strangely-coloured.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_04082012_b, RestOfContent = BlogPostsProgramming.content_04082012_r, Keywords = BlogPostsProgramming.content_04082012_k, Description = BlogPostsProgramming.content_04082012_d, DateCreated = new DateTime(2012, 8, 4), PostID = 14, Title = "Installing Windows Updates via Shell Script", BloggerUrl = "http://justmycode.blogspot.com/2012/08/installing-windows-updates-via-shell.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_31072012_b, RestOfContent = BlogPostsProgramming.content_31072012_r, Keywords = BlogPostsProgramming.content_31072012_k, Description = BlogPostsProgramming.content_31072012_d, DateCreated = new DateTime(2012, 7, 31), PostID = 15, Title = "Game of Life Exercise and Extension Methods", BloggerUrl = "http://justmycode.blogspot.com/2012/07/game-of-life-exercise-and-extension.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_17072012_b, RestOfContent = BlogPostsProgramming.content_17072012_r, Keywords = BlogPostsProgramming.content_17072012_k, Description = BlogPostsProgramming.content_17072012_d, DateCreated = new DateTime(2012, 7, 17), PostID = 16, Title = "Learning MVC: Vertical Pop-Out Menu", BloggerUrl = "http://justmycode.blogspot.com/2012/07/learning-mvc-vertical-pop-out-menu.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05072012_b, RestOfContent = BlogPostsProgramming.content_05072012_r, Keywords = BlogPostsProgramming.content_05072012_k, Description = BlogPostsProgramming.content_05072012_d, DateCreated = new DateTime(2012, 7, 5), PostID = 17, Title = "Learning MVC: Editing the Variable Length List", BloggerUrl = "http://justmycode.blogspot.com/2012/07/learning-mvc-editing-variable-length.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14062012_b, RestOfContent = BlogPostsProgramming.content_14062012_r, Keywords = BlogPostsProgramming.content_14062012_k, Description = BlogPostsProgramming.content_14062012_d, DateCreated = new DateTime(2012, 6, 14), PostID = 18, Title = "Learning MVC: Unit Testing Validation in MVC", BloggerUrl = "http://justmycode.blogspot.com/2012/06/learning-mvc-unit-testing-validation-in.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12062012_b, RestOfContent = BlogPostsProgramming.content_12062012_r, Keywords = BlogPostsProgramming.content_12062012_k, Description = BlogPostsProgramming.content_12062012_d, DateCreated = new DateTime(2012, 6, 12), PostID = 19, Title = "Learning MVC: Unit Testing CRUD actions in MVC", BloggerUrl = "http://justmycode.blogspot.com/2012/06/learning-mvc-unit-testing-crud-actions.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15052012_b, RestOfContent = BlogPostsProgramming.content_15052012_r, Keywords = BlogPostsProgramming.content_15052012_k, Description = BlogPostsProgramming.content_15052012_d, DateCreated = new DateTime(2012, 5, 15), PostID = 20, Title = "Learning MVC: Updating the Many-to-many Relationship", BloggerUrl = "http://justmycode.blogspot.com/2012/05/updating-many-to-many-relationship-with.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_13052012_b, RestOfContent = BlogPostsProgramming.content_13052012_r, Keywords = BlogPostsProgramming.content_13052012_k, Description = BlogPostsProgramming.content_13052012_d, DateCreated = new DateTime(2012, 5, 13), PostID = 21, Title = "Learning MVC - Code First and Many-to-many Relationship", BloggerUrl = "http://justmycode.blogspot.com/2012/05/learning-mvc-code-first-and-many-to.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02052012_b, RestOfContent = BlogPostsProgramming.content_02052012_r, Keywords = BlogPostsProgramming.content_02052012_k, Description = BlogPostsProgramming.content_02052012_d, DateCreated = new DateTime(2012, 5, 2), PostID = 22, Title = "Converting a Physical PC to VM with VMWare Converter", BloggerUrl = "http://justmycode.blogspot.com/2012/05/converting-physical-pc-to-vm-with.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_04042012_b, RestOfContent = BlogPostsProgramming.content_04042012_r, Keywords = BlogPostsProgramming.content_04042012_k, Description = BlogPostsProgramming.content_04042012_d, DateCreated = new DateTime(2012, 4, 4), PostID = 23, Title = "QML ScrollBar", BloggerUrl = "http://justmycode.blogspot.com/2012/04/qml-scrollbar.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_01042012_b, RestOfContent = BlogPostsProgramming.content_01042012_r, Keywords = BlogPostsProgramming.content_01042012_k, Description = BlogPostsProgramming.content_01042012_d, DateCreated = new DateTime(2012, 4, 1), PostID = 24, Title = "Return Multiple Values to QML from C++", BloggerUrl = "http://justmycode.blogspot.com/2012/04/return-multiple-values-to-qml-from-c.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_29032012_b, RestOfContent = BlogPostsProgramming.content_29032012_r, Keywords = BlogPostsProgramming.content_29032012_k, Description = BlogPostsProgramming.content_29032012_d, DateCreated = new DateTime(2012, 3, 29), PostID = 25, Title = "Connecting QML to C++, More Practical Example", BloggerUrl = "http://justmycode.blogspot.com/2012/03/connecting-qml-to-c-more-practical.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_28032012_b, RestOfContent = BlogPostsProgramming.content_28032012_r, Keywords = BlogPostsProgramming.content_28032012_k, Description = BlogPostsProgramming.content_28032012_d, DateCreated = new DateTime(2012, 3, 28), PostID = 26, Title = "Connecting QML to C++, First Attempt", BloggerUrl = "http://justmycode.blogspot.com/2012/03/connecting-qml-to-c-first-attempt.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26032012_b, RestOfContent = BlogPostsProgramming.content_26032012_r, Keywords = BlogPostsProgramming.content_26032012_k, Description = BlogPostsProgramming.content_26032012_d, DateCreated = new DateTime(2012, 3, 26), PostID = 27, Title = "Improved QML Simple Splitter", BloggerUrl = "http://justmycode.blogspot.com/2012/03/improved-qml-simple-splitter.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25032012_b, RestOfContent = BlogPostsProgramming.content_25032012_r, Keywords = BlogPostsProgramming.content_25032012_k, Description = BlogPostsProgramming.content_25032012_d, DateCreated = new DateTime(2012, 3, 25), PostID = 28, Title = "The Most Basic Splitter Component Possible", BloggerUrl = "http://justmycode.blogspot.com/2012/03/most-basic-splitter-component-possible.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_20032012_b, RestOfContent = BlogPostsProgramming.content_20032012_r, Keywords = BlogPostsProgramming.content_20032012_k, Description = BlogPostsProgramming.content_20032012_d, DateCreated = new DateTime(2012, 3, 20), PostID = 29, Title = "QML Check Box", BloggerUrl = "http://justmycode.blogspot.com/2012/03/qml-check-box.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_19032012_b, RestOfContent = BlogPostsProgramming.content_19032012_r, Keywords = BlogPostsProgramming.content_19032012_k, Description = BlogPostsProgramming.content_19032012_d, DateCreated = new DateTime(2012, 3, 19), PostID = 30, Title = "QML Drop Down Menu", BloggerUrl = "http://justmycode.blogspot.com/2012/03/qml-drop-down-menu.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_18032012_b, RestOfContent = BlogPostsProgramming.content_18032012_r, Keywords = BlogPostsProgramming.content_18032012_k, Description = BlogPostsProgramming.content_18032012_d, DateCreated = new DateTime(2012, 3, 18), PostID = 31, Title = "QML Improved Tree View", BloggerUrl = "http://justmycode.blogspot.com/2012/03/qml-improved-tree-view.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14032012_b, RestOfContent = BlogPostsProgramming.content_14032012_r, Keywords = BlogPostsProgramming.content_14032012_k, Description = BlogPostsProgramming.content_14032012_d, DateCreated = new DateTime(2012, 3, 14), PostID = 32, Title = "QML TreeView Exercise", BloggerUrl = "http://justmycode.blogspot.com/2012/03/qml-treeview-exersice.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_08032012_b, RestOfContent = BlogPostsProgramming.content_08032012_r, Keywords = BlogPostsProgramming.content_08032012_k, Description = BlogPostsProgramming.content_08032012_d, DateCreated = new DateTime(2012, 3, 8), PostID = 33, Title = "A Disabled Tab and Adding Tabs on the Fly", BloggerUrl = "http://justmycode.blogspot.com/2012/03/disabled-tab-and-adding-tabs-on-fly.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07032012_b, RestOfContent = BlogPostsProgramming.content_07032012_r, Keywords = BlogPostsProgramming.content_07032012_k, Description = BlogPostsProgramming.content_07032012_d, DateCreated = new DateTime(2012, 3, 7), PostID = 34, Title = "Loading Tabs Dynamically", BloggerUrl = "http://justmycode.blogspot.com/2012/03/loading-tabs-dynamically.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06032012_b, RestOfContent = BlogPostsProgramming.content_06032012_r, Keywords = BlogPostsProgramming.content_06032012_k, Description = BlogPostsProgramming.content_06032012_d, DateCreated = new DateTime(2012, 3, 6), PostID = 35, Title = "Customizing a Tab Control with QML", BloggerUrl = "http://justmycode.blogspot.com/2012/03/customizing-tab-control-with-qml.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05032012_b, RestOfContent = BlogPostsProgramming.content_05032012_r, Keywords = BlogPostsProgramming.content_05032012_k, Description = BlogPostsProgramming.content_05032012_d, DateCreated = new DateTime(2012, 3, 5), PostID = 36, Title = "ListView in QML", BloggerUrl = "http://justmycode.blogspot.com/2012/03/listview-in-qml.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_04032012_b, RestOfContent = BlogPostsProgramming.content_04032012_r, Keywords = BlogPostsProgramming.content_04032012_k, Description = BlogPostsProgramming.content_04032012_d, DateCreated = new DateTime(2012, 3, 4), PostID = 37, Title = "Starting With QML", BloggerUrl = "http://justmycode.blogspot.com/2012/03/starting-with-qml.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26022012_b, RestOfContent = BlogPostsProgramming.content_26022012_r, Keywords = BlogPostsProgramming.content_26022012_k, Description = BlogPostsProgramming.content_26022012_d, DateCreated = new DateTime(2012, 2, 26), PostID = 38, Title = "Writing my First Web Script for Alfresco", BloggerUrl = "http://justmycode.blogspot.com/2012/02/writing-my-first-web-script-for.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_23022012_b, RestOfContent = BlogPostsProgramming.content_23022012_r, Keywords = BlogPostsProgramming.content_23022012_k, Description = BlogPostsProgramming.content_23022012_d, DateCreated = new DateTime(2012, 2, 23), PostID = 39, Title = "Amusing", BloggerUrl = "http://justmycode.blogspot.com/2012/02/amusing.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14022012_b, RestOfContent = BlogPostsProgramming.content_14022012_r, Keywords = BlogPostsProgramming.content_14022012_k, Description = BlogPostsProgramming.content_14022012_d, DateCreated = new DateTime(2012, 2, 14), PostID = 40, Title = "Restricting Access to Content in Alfresco", BloggerUrl = "http://justmycode.blogspot.com/2012/02/restricting-access-to-content-in.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12022012_b, RestOfContent = BlogPostsProgramming.content_12022012_r, Keywords = BlogPostsProgramming.content_12022012_k, Description = BlogPostsProgramming.content_12022012_d, DateCreated = new DateTime(2012, 2, 12), PostID = 41, Title = "Assigning a Workflow to the Web Form", BloggerUrl = "http://justmycode.blogspot.com/2012/02/assigning-workflow-to-web-form.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09022012_b, RestOfContent = BlogPostsProgramming.content_09022012_r, Keywords = BlogPostsProgramming.content_09022012_k, Description = BlogPostsProgramming.content_09022012_d, DateCreated = new DateTime(2012, 2, 9), PostID = 42, Title = "Simple Reporting with Alfresco", BloggerUrl = "http://justmycode.blogspot.com/2012/02/simple-reporting-with-alfresco.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06022012_b, RestOfContent = BlogPostsProgramming.content_06022012_r, Keywords = BlogPostsProgramming.content_06022012_k, Description = BlogPostsProgramming.content_06022012_d, DateCreated = new DateTime(2012, 2, 6), PostID = 43, Title = "Web Form and Web Project with Alfresco", BloggerUrl = "http://justmycode.blogspot.com/2012/02/web-form-and-web-project-with-alfresco.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_03022012_b, RestOfContent = BlogPostsProgramming.content_03022012_r, Keywords = BlogPostsProgramming.content_03022012_k, Description = BlogPostsProgramming.content_03022012_d, DateCreated = new DateTime(2012, 2, 3), PostID = 44, Title = "Installing Alfresco", BloggerUrl = "http://justmycode.blogspot.com/2012/02/installing-alfresco.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02022012_b, RestOfContent = BlogPostsProgramming.content_02022012_r, Keywords = BlogPostsProgramming.content_02022012_k, Description = BlogPostsProgramming.content_02022012_d, DateCreated = new DateTime(2012, 2, 2), PostID = 45, Title = "Understanding Alfresco", BloggerUrl = "http://justmycode.blogspot.com/2012/02/understanding-alfresco.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09012012_b, RestOfContent = BlogPostsProgramming.content_09012012_r, Keywords = BlogPostsProgramming.content_09012012_k, Description = BlogPostsProgramming.content_09012012_d, DateCreated = new DateTime(2012, 1, 9), PostID = 46, Title = "TFS Is Back : Migrate from VSS to TFS 2010", BloggerUrl = "http://justmycode.blogspot.com/2012/01/tfs-is-back-migrate-from-vss-to-tfs.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15122011_b, RestOfContent = BlogPostsProgramming.content_15122011_r, Keywords = BlogPostsProgramming.content_15122011_k, Description = BlogPostsProgramming.content_15122011_d, DateCreated = new DateTime(2011, 12, 15), PostID = 47, Title = "Learning MVC: SQL CE Membership Provider for ASP.Net", BloggerUrl = "http://justmycode.blogspot.com/2011/12/learning-mvc-sql-ce-membership-provider.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09122011_b, RestOfContent = BlogPostsProgramming.content_09122011_r, Keywords = BlogPostsProgramming.content_09122011_k, Description = BlogPostsProgramming.content_09122011_d, DateCreated = new DateTime(2011, 12, 9), PostID = 48, Title = "Learning MVC: User Data in a Partial View", BloggerUrl = "http://justmycode.blogspot.com/2011/12/learning-mvc-user-data-in-partial-view.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06122011_b, RestOfContent = BlogPostsProgramming.content_06122011_r, Keywords = BlogPostsProgramming.content_06122011_k, Description = BlogPostsProgramming.content_06122011_d, DateCreated = new DateTime(2011, 12, 6), PostID = 49, Title = "Learning MVC: Scalable Navigation", BloggerUrl = "http://justmycode.blogspot.com/2011/12/learning-mvc-scalable-navigation.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_03122011_b, RestOfContent = BlogPostsProgramming.content_03122011_r, Keywords = BlogPostsProgramming.content_03122011_k, Description = BlogPostsProgramming.content_03122011_d, DateCreated = new DateTime(2011, 12, 3), PostID = 50, Title = "Learning MVC: Custom Html Helpers", BloggerUrl = "http://justmycode.blogspot.com/2011/12/learning-mvc-custom-html-helpers.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02122011_b, RestOfContent = BlogPostsProgramming.content_02122011_r, Keywords = BlogPostsProgramming.content_02122011_k, Description = BlogPostsProgramming.content_02122011_d, DateCreated = new DateTime(2011, 12, 2), PostID = 51, Title = "Learning MVC: Adding Autocomplete Dropdown", BloggerUrl = "http://justmycode.blogspot.com/2011/12/learning-mvc-adding-autocomplete.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_01122011_b, RestOfContent = BlogPostsProgramming.content_01122011_r, Keywords = BlogPostsProgramming.content_01122011_k, Description = BlogPostsProgramming.content_01122011_d, DateCreated = new DateTime(2011, 12, 1), PostID = 52, Title = "Learning MVC: Installing Application on IIS", BloggerUrl = "http://justmycode.blogspot.com/2011/12/learning-mvc-installing-application-on.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_28112011_b, RestOfContent = BlogPostsProgramming.content_28112011_r, Keywords = BlogPostsProgramming.content_28112011_k, Description = BlogPostsProgramming.content_28112011_d, DateCreated = new DateTime(2011, 11, 28), PostID = 53, Title = "Learning MVC: Model Binders", BloggerUrl = "http://justmycode.blogspot.com/2011/11/learning-mvc-model-binders.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_27112011_b, RestOfContent = BlogPostsProgramming.content_27112011_r, Keywords = BlogPostsProgramming.content_27112011_k, Description = BlogPostsProgramming.content_27112011_d, DateCreated = new DateTime(2011, 11, 27), PostID = 54, Title = "Learning MVC: A Quick Note on Validation", BloggerUrl = "http://justmycode.blogspot.com/2011/11/learning-mvc-quick-note-on-validation.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26112011_b, RestOfContent = BlogPostsProgramming.content_26112011_r, Keywords = BlogPostsProgramming.content_26112011_k, Description = BlogPostsProgramming.content_26112011_d, DateCreated = new DateTime(2011, 11, 26), PostID = 55, Title = "Learning MVC: A Repository Pattern", BloggerUrl = "http://justmycode.blogspot.com/2011/11/learning-mvc-repository-pattern.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_23112011_b, RestOfContent = BlogPostsProgramming.content_23112011_r, Keywords = BlogPostsProgramming.content_23112011_k, Description = BlogPostsProgramming.content_23112011_d, DateCreated = new DateTime(2011, 11, 23), PostID = 56, Title = "Learning MVC: A multi-user application concept", BloggerUrl = "http://justmycode.blogspot.com/2011/11/learning-mvc-multi-user-application.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_22112011_b, RestOfContent = BlogPostsProgramming.content_22112011_r, Keywords = BlogPostsProgramming.content_22112011_k, Description = BlogPostsProgramming.content_22112011_d, DateCreated = new DateTime(2011, 11, 22), PostID = 57, Title = "NuGet, Entity Framework 4.1 and DbContext API", BloggerUrl = "http://justmycode.blogspot.com/2011/11/nuget-entity-framework-41-and-dbcontext.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_18112011_b, RestOfContent = BlogPostsProgramming.content_18112011_r, Keywords = BlogPostsProgramming.content_18112011_k, Description = BlogPostsProgramming.content_18112011_d, DateCreated = new DateTime(2011, 11, 18), PostID = 58, Title = "Tortoise SVN for Windows and Checking Out Code from Google", BloggerUrl = "http://justmycode.blogspot.com/2011/11/tortoise-svn-for-windows-and-checking.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14112011_b, RestOfContent = BlogPostsProgramming.content_14112011_r, Keywords = BlogPostsProgramming.content_14112011_k, Description = BlogPostsProgramming.content_14112011_d, DateCreated = new DateTime(2011, 11, 14), PostID = 59, Title = "Generating a C# Class Based on the Underlying SQL", BloggerUrl = "http://justmycode.blogspot.com/2011/11/generating-c-class-based-on-underlying.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11112011_b, RestOfContent = BlogPostsProgramming.content_11112011_r, Keywords = BlogPostsProgramming.content_11112011_k, Description = BlogPostsProgramming.content_11112011_d, DateCreated = new DateTime(2011, 11, 11), PostID = 60, Title = "Understanding Git, GitHub and GitExtensions", BloggerUrl = "http://justmycode.blogspot.com/2011/11/understanding-git-github-and.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09112011_b, RestOfContent = BlogPostsProgramming.content_09112011_r, Keywords = BlogPostsProgramming.content_09112011_k, Description = BlogPostsProgramming.content_09112011_d, DateCreated = new DateTime(2011, 11, 9), PostID = 61, Title = "Flash in WPF Application the MVVM way (the easy part)", BloggerUrl = "http://justmycode.blogspot.com/2011/11/flash-in-wpf-application-mvvm-way-easy.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05112011_b, RestOfContent = BlogPostsProgramming.content_05112011_r, Keywords = BlogPostsProgramming.content_05112011_k, Description = BlogPostsProgramming.content_05112011_d, DateCreated = new DateTime(2011, 11, 5), PostID = 62, Title = "Flash in WPF Application the MVVM way (the hard part)", BloggerUrl = "http://justmycode.blogspot.com/2011/11/flash-in-wpf-application-mvvm-way-hard.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_03112011_b, RestOfContent = BlogPostsProgramming.content_03112011_r, Keywords = BlogPostsProgramming.content_03112011_k, Description = BlogPostsProgramming.content_03112011_d, DateCreated = new DateTime(2011, 11, 3), PostID = 63, Title = "Small Things Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2011/11/small-things-learned-today.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02112011_b, RestOfContent = BlogPostsProgramming.content_02112011_r, Keywords = BlogPostsProgramming.content_02112011_k, Description = BlogPostsProgramming.content_02112011_d, DateCreated = new DateTime(2011, 11, 2), PostID = 64, Title = "A Confusing Issue with the Ampersand in the XML", BloggerUrl = "http://justmycode.blogspot.com/2011/11/xcentre-y620-fontidautomationhi25l.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25102011_b, RestOfContent = BlogPostsProgramming.content_25102011_r, Keywords = BlogPostsProgramming.content_25102011_k, Description = BlogPostsProgramming.content_25102011_d, DateCreated = new DateTime(2011, 10, 25), PostID = 65, Title = "Setting up a Composite WPF Application Properly", BloggerUrl = "http://justmycode.blogspot.com/2011/10/setting-up-composite-wpf-application.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_24102011_b, RestOfContent = BlogPostsProgramming.content_24102011_r, Keywords = BlogPostsProgramming.content_24102011_k, Description = BlogPostsProgramming.content_24102011_d, DateCreated = new DateTime(2011, 10, 24), PostID = 66, Title = "Small Things Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2011/10/small-things-learned-today.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_16102011_b, RestOfContent = BlogPostsProgramming.content_16102011_r, Keywords = BlogPostsProgramming.content_16102011_k, Description = BlogPostsProgramming.content_16102011_d, DateCreated = new DateTime(2011, 10, 16), PostID = 67, Title = "WPF Commands Part 1", BloggerUrl = "http://justmycode.blogspot.com/2011/10/wpf-commands-part-1.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_13102011_b, RestOfContent = BlogPostsProgramming.content_13102011_r, Keywords = BlogPostsProgramming.content_13102011_k, Description = BlogPostsProgramming.content_13102011_d, DateCreated = new DateTime(2011, 10, 13), PostID = 68, Title = "Using the EventAggregator", BloggerUrl = "http://justmycode.blogspot.com/2011/10/using-eventaggregator.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12102011_b, RestOfContent = BlogPostsProgramming.content_12102011_r, Keywords = BlogPostsProgramming.content_12102011_k, Description = BlogPostsProgramming.content_12102011_d, DateCreated = new DateTime(2011, 10, 12), PostID = 69, Title = "First Encounter with Windows 7", BloggerUrl = "http://justmycode.blogspot.com/2011/10/first-encounter-with-windows-7.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11102011_b, RestOfContent = BlogPostsProgramming.content_11102011_r, Keywords = BlogPostsProgramming.content_11102011_k, Description = BlogPostsProgramming.content_11102011_d, DateCreated = new DateTime(2011, 10, 11), PostID = 70, Title = "Customising the app.config file during installation", BloggerUrl = "http://justmycode.blogspot.com/2011/10/customising-appconfig-file-during.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10102011_b, RestOfContent = BlogPostsProgramming.content_10102011_r, Keywords = BlogPostsProgramming.content_10102011_k, Description = BlogPostsProgramming.content_10102011_d, DateCreated = new DateTime(2011, 10, 10), PostID = 71, Title = "I broke things, so now I will jiggle things randomly until they unbreak", BloggerUrl = "http://justmycode.blogspot.com/2011/10/i-broke-things-so-now-i-will-jiggle.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_04102011_b, RestOfContent = BlogPostsProgramming.content_04102011_r, Keywords = BlogPostsProgramming.content_04102011_k, Description = BlogPostsProgramming.content_04102011_d, DateCreated = new DateTime(2011, 10, 4), PostID = 72, Title = "An Application Needs to Create An Event Source in the Event Log", BloggerUrl = "http://justmycode.blogspot.com/2011/10/application-needs-to-create-event.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_22082011_b, RestOfContent = BlogPostsProgramming.content_22082011_r, Keywords = BlogPostsProgramming.content_22082011_k, Description = BlogPostsProgramming.content_22082011_d, DateCreated = new DateTime(2011, 8, 22), PostID = 73, Title = "Small things learned today: Raise Base Class Event in Derived Classes", BloggerUrl = "http://justmycode.blogspot.com/2011/08/small-things-learned-today-raise-base.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15082011_b, RestOfContent = BlogPostsProgramming.content_15082011_r, Keywords = BlogPostsProgramming.content_15082011_k, Description = BlogPostsProgramming.content_15082011_d, DateCreated = new DateTime(2011, 8, 15), PostID = 74, Title = "Third Party DLL random thoughts ...", BloggerUrl = "http://justmycode.blogspot.com/2011/08/third-party-dll-random-thoughts.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_17072011_b, RestOfContent = BlogPostsProgramming.content_17072011_r, Keywords = BlogPostsProgramming.content_17072011_k, Description = BlogPostsProgramming.content_17072011_d, DateCreated = new DateTime(2011, 7, 17), PostID = 75, Title = "BindingList", BloggerUrl = "http://justmycode.blogspot.com/2011/07/bindinglist.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_28062011_b, RestOfContent = BlogPostsProgramming.content_28062011_r, Keywords = BlogPostsProgramming.content_28062011_k, Description = BlogPostsProgramming.content_28062011_d, DateCreated = new DateTime(2011, 6, 28), PostID = 76, Title = "Cryptic Error Message", BloggerUrl = "http://justmycode.blogspot.com/2011/06/cryptic-error-message.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10052010_b, RestOfContent = BlogPostsProgramming.content_10052010_r, Keywords = BlogPostsProgramming.content_10052010_k, Description = BlogPostsProgramming.content_10052010_d, DateCreated = new DateTime(2010, 5, 10), PostID = 77, Title = "Where has my stored procedure parameter gone?", BloggerUrl = "http://justmycode.blogspot.com/2010/05/where-has-my-stored-procedure-parameter.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11122009_b, RestOfContent = BlogPostsProgramming.content_11122009_r, Keywords = BlogPostsProgramming.content_11122009_k, Description = BlogPostsProgramming.content_11122009_d, DateCreated = new DateTime(2009, 12, 11), PostID = 78, Title = "Unit Testing With Compact Framework and Visual Studio", BloggerUrl = "http://justmycode.blogspot.com/2009/12/unit-testing-with-compact-framework-and.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_24112009_b, RestOfContent = BlogPostsProgramming.content_24112009_r, Keywords = BlogPostsProgramming.content_24112009_k, Description = BlogPostsProgramming.content_24112009_d, DateCreated = new DateTime(2009, 11, 24), PostID = 79, Title = "Compact Framework and NUnit", BloggerUrl = "http://justmycode.blogspot.com/2009/11/compact-framework-and-nunit.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_19112009_b, RestOfContent = BlogPostsProgramming.content_19112009_r, Keywords = BlogPostsProgramming.content_19112009_k, Description = BlogPostsProgramming.content_19112009_d, DateCreated = new DateTime(2009, 11, 19), PostID = 80, Title = "Compact Framework and forms management", BloggerUrl = "http://justmycode.blogspot.com/2009/11/compact-framework-and-forms-management.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_03102009_b, RestOfContent = BlogPostsProgramming.content_03102009_r, Keywords = BlogPostsProgramming.content_03102009_k, Description = BlogPostsProgramming.content_03102009_d, DateCreated = new DateTime(2009, 10, 3), PostID = 81, Title = "Doing Some Stuff on Another Computer", BloggerUrl = "http://justmycode.blogspot.com/2009/10/doing-some-stuff-on-another-computer.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_01102009_b, RestOfContent = BlogPostsProgramming.content_01102009_r, Keywords = BlogPostsProgramming.content_01102009_k, Description = BlogPostsProgramming.content_01102009_d, DateCreated = new DateTime(2009, 10, 1), PostID = 82, Title = "Simple WCF client/server", BloggerUrl = "http://justmycode.blogspot.com/2009/10/simple-wcf-clientserver.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_16092009_b, RestOfContent = BlogPostsProgramming.content_16092009_r, Keywords = BlogPostsProgramming.content_16092009_k, Description = BlogPostsProgramming.content_16092009_d, DateCreated = new DateTime(2009, 9, 16), PostID = 83, Title = "A Small Unit Testing Gem", BloggerUrl = "http://justmycode.blogspot.com/2009/09/small-unit-testing-gem.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10092009_b, RestOfContent = BlogPostsProgramming.content_10092009_r, Keywords = BlogPostsProgramming.content_10092009_k, Description = BlogPostsProgramming.content_10092009_d, DateCreated = new DateTime(2009, 9, 10), PostID = 84, Title = "Thread Pooling", BloggerUrl = "http://justmycode.blogspot.com/2009/09/thread-pooling.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_01092009_b, RestOfContent = BlogPostsProgramming.content_01092009_r, Keywords = BlogPostsProgramming.content_01092009_k, Description = BlogPostsProgramming.content_01092009_d, DateCreated = new DateTime(2009, 9, 1), PostID = 85, Title = "Studying Interprocess Communication", BloggerUrl = "http://justmycode.blogspot.com/2009/09/studying-interprocess-communication.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_24082009_b, RestOfContent = BlogPostsProgramming.content_24082009_r, Keywords = BlogPostsProgramming.content_24082009_k, Description = BlogPostsProgramming.content_24082009_d, DateCreated = new DateTime(2009, 8, 24), PostID = 86, Title = "Human Readable Entries For The Event Log", BloggerUrl = "http://justmycode.blogspot.com/2009/08/human-readable-entries-for-event-log.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_30072009_b, RestOfContent = BlogPostsProgramming.content_30072009_r, Keywords = BlogPostsProgramming.content_30072009_k, Description = BlogPostsProgramming.content_30072009_d, DateCreated = new DateTime(2009, 7, 30), PostID = 87, Title = "WebOS Development - First Steps", BloggerUrl = "http://justmycode.blogspot.com/2009/07/webos-development-first-steps.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_29072009_b, RestOfContent = BlogPostsProgramming.content_29072009_r, Keywords = BlogPostsProgramming.content_29072009_k, Description = BlogPostsProgramming.content_29072009_d, DateCreated = new DateTime(2009, 7, 29), PostID = 88, Title = "WebOS Development", BloggerUrl = "http://justmycode.blogspot.com/2009/07/webos-development.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_22072009_b, RestOfContent = BlogPostsProgramming.content_22072009_r, Keywords = BlogPostsProgramming.content_22072009_k, Description = BlogPostsProgramming.content_22072009_d, DateCreated = new DateTime(2009, 7, 22), PostID = 89, Title = "Mifare 1K Memory Structure", BloggerUrl = "http://justmycode.blogspot.com/2009/07/mifare-1k-memory-structure.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_19072009_b, RestOfContent = BlogPostsProgramming.content_19072009_r, Keywords = BlogPostsProgramming.content_19072009_k, Description = BlogPostsProgramming.content_19072009_d, DateCreated = new DateTime(2009, 7, 19), PostID = 90, Title = "Smart Cards Do Not Hurt Anymore", BloggerUrl = "http://justmycode.blogspot.com/2009/07/smart-cards-do-not-hurt-anymore.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_17072009_b, RestOfContent = BlogPostsProgramming.content_17072009_r, Keywords = BlogPostsProgramming.content_17072009_k, Description = BlogPostsProgramming.content_17072009_d, DateCreated = new DateTime(2009, 7, 17), PostID = 91, Title = "Smart Cards Hurt - 3", BloggerUrl = "http://justmycode.blogspot.com/2009/07/smart-cards-hurt-3.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15072009_b, RestOfContent = BlogPostsProgramming.content_15072009_r, Keywords = BlogPostsProgramming.content_15072009_k, Description = BlogPostsProgramming.content_15072009_d, DateCreated = new DateTime(2009, 7, 15), PostID = 92, Title = "Unit Testing - First Attempts", BloggerUrl = "http://justmycode.blogspot.com/2009/07/unit-testing-first-attempts.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10072009_b, RestOfContent = BlogPostsProgramming.content_10072009_r, Keywords = BlogPostsProgramming.content_10072009_k, Description = BlogPostsProgramming.content_10072009_d, DateCreated = new DateTime(2009, 7, 10), PostID = 93, Title = "Smart Cards Hurt - 2", BloggerUrl = "http://justmycode.blogspot.com/2009/07/smart-cards-hurt-2.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07072009_b, RestOfContent = BlogPostsProgramming.content_07072009_r, Keywords = BlogPostsProgramming.content_07072009_k, Description = BlogPostsProgramming.content_07072009_d, DateCreated = new DateTime(2009, 7, 7), PostID = 94, Title = "Smart Cards Hurt - 1", BloggerUrl = "http://justmycode.blogspot.com/2009/07/smart-cards-hurt-1.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_27062009_b, RestOfContent = BlogPostsProgramming.content_27062009_r, Keywords = BlogPostsProgramming.content_27062009_k, Description = BlogPostsProgramming.content_27062009_d, DateCreated = new DateTime(2009, 6, 27), PostID = 95, Title = "Embedded Technology Workshop", BloggerUrl = "http://justmycode.blogspot.com/2009/06/embedded-technology-workshop.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_23062009_b, RestOfContent = BlogPostsProgramming.content_23062009_r, Keywords = BlogPostsProgramming.content_23062009_k, Description = BlogPostsProgramming.content_23062009_d, DateCreated = new DateTime(2009, 6, 23), PostID = 96, Title = "VSS => TFS converter application update", BloggerUrl = "http://justmycode.blogspot.com/2009/06/vss-tfs-converter-application-update.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_16062009_b, RestOfContent = BlogPostsProgramming.content_16062009_r, Keywords = BlogPostsProgramming.content_16062009_k, Description = BlogPostsProgramming.content_16062009_d, DateCreated = new DateTime(2009, 6, 16), PostID = 97, Title = "Using the Process class", BloggerUrl = "http://justmycode.blogspot.com/2009/06/using-process-class.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09062009_b, RestOfContent = BlogPostsProgramming.content_09062009_r, Keywords = BlogPostsProgramming.content_09062009_k, Description = BlogPostsProgramming.content_09062009_d, DateCreated = new DateTime(2009, 6, 9), PostID = 98, Title = "Small Things Refreshed Today", BloggerUrl = "http://justmycode.blogspot.com/2009/06/small-things-refreshed-today.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25052009_b, RestOfContent = BlogPostsProgramming.content_25052009_r, Keywords = BlogPostsProgramming.content_25052009_k, Description = BlogPostsProgramming.content_25052009_d, DateCreated = new DateTime(2009, 5, 25), PostID = 99, Title = "VSS => TFS Migration", BloggerUrl = "http://justmycode.blogspot.com/2009/05/vss-tfs-migration.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15052009_b, RestOfContent = BlogPostsProgramming.content_15052009_r, Keywords = BlogPostsProgramming.content_15052009_k, Description = BlogPostsProgramming.content_15052009_d, DateCreated = new DateTime(2009, 5, 15), PostID = 100, Title = "TFS Disaster Resolved", BloggerUrl = "http://justmycode.blogspot.com/2009/05/tfs-disaster-resolved.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14052009_b, RestOfContent = BlogPostsProgramming.content_14052009_r, Keywords = BlogPostsProgramming.content_14052009_k, Description = BlogPostsProgramming.content_14052009_d, DateCreated = new DateTime(2009, 5, 14), PostID = 101, Title = "TFS/IIS Disaster Update", BloggerUrl = "http://justmycode.blogspot.com/2009/05/tfsiis-disaster-update.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10052009_b, RestOfContent = BlogPostsProgramming.content_10052009_r, Keywords = BlogPostsProgramming.content_10052009_k, Description = BlogPostsProgramming.content_10052009_d, DateCreated = new DateTime(2009, 5, 10), PostID = 102, Title = "Small Thing Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2009/05/small-thing-learned-today.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_23042009_b, RestOfContent = BlogPostsProgramming.content_23042009_r, Keywords = BlogPostsProgramming.content_23042009_k, Description = BlogPostsProgramming.content_23042009_d, DateCreated = new DateTime(2009, 4, 23), PostID = 103, Title = "IIS Disaster Update", BloggerUrl = "http://justmycode.blogspot.com/2009/04/iis-disaster-update_23.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_21042009_b, RestOfContent = BlogPostsProgramming.content_21042009_r, Keywords = BlogPostsProgramming.content_21042009_k, Description = BlogPostsProgramming.content_21042009_d, DateCreated = new DateTime(2009, 4, 21), PostID = 104, Title = "IIS Disaster Update", BloggerUrl = "http://justmycode.blogspot.com/2009/04/iis-disaster-update.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_17042009_b, RestOfContent = BlogPostsProgramming.content_17042009_r, Keywords = BlogPostsProgramming.content_17042009_k, Description = BlogPostsProgramming.content_17042009_d, DateCreated = new DateTime(2009, 4, 17), PostID = 105, Title = "TFS Disaster Update", BloggerUrl = "http://justmycode.blogspot.com/2009/04/tfs-disaster-update_17.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15042009_b, RestOfContent = BlogPostsProgramming.content_15042009_r, Keywords = BlogPostsProgramming.content_15042009_k, Description = BlogPostsProgramming.content_15042009_d, DateCreated = new DateTime(2009, 4, 15), PostID = 106, Title = "TFS Disaster Update", BloggerUrl = "http://justmycode.blogspot.com/2009/04/tfs-disaster-update_14.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14042009_b, RestOfContent = BlogPostsProgramming.content_14042009_r, Keywords = BlogPostsProgramming.content_14042009_k, Description = BlogPostsProgramming.content_14042009_d, DateCreated = new DateTime(2009, 4, 14), PostID = 107, Title = "Copy Constructor Update", BloggerUrl = "http://justmycode.blogspot.com/2009/04/copy-constructor-update.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10042009_b, RestOfContent = BlogPostsProgramming.content_10042009_r, Keywords = BlogPostsProgramming.content_10042009_k, Description = BlogPostsProgramming.content_10042009_d, DateCreated = new DateTime(2009, 4, 10), PostID = 108, Title = "TFS Disaster Update", BloggerUrl = "http://justmycode.blogspot.com/2009/04/tfs-disaster-update.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_08042009_b, RestOfContent = BlogPostsProgramming.content_08042009_r, Keywords = BlogPostsProgramming.content_08042009_k, Description = BlogPostsProgramming.content_08042009_d, DateCreated = new DateTime(2009, 4, 8), PostID = 109, Title = "TFS Disaster", BloggerUrl = "http://justmycode.blogspot.com/2009/04/tfs-disaster.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07042009_b, RestOfContent = BlogPostsProgramming.content_07042009_r, Keywords = BlogPostsProgramming.content_07042009_k, Description = BlogPostsProgramming.content_07042009_d, DateCreated = new DateTime(2009, 4, 7), PostID = 110, Title = "Full process of scanning the document and extracting data", BloggerUrl = "http://justmycode.blogspot.com/2009/04/now-full-process-of-scanning-document.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_01042009_b, RestOfContent = BlogPostsProgramming.content_01042009_r, Keywords = BlogPostsProgramming.content_01042009_k, Description = BlogPostsProgramming.content_01042009_d, DateCreated = new DateTime(2009, 4, 1), PostID = 111, Title = "Calling an unmanaged C++ dll from C# managed code", BloggerUrl = "http://justmycode.blogspot.com/2009/04/calling-unmanaged-c-dll-from-c-managed.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_22032009_b, RestOfContent = BlogPostsProgramming.content_22032009_r, Keywords = BlogPostsProgramming.content_22032009_k, Description = BlogPostsProgramming.content_22032009_d, DateCreated = new DateTime(2009, 3, 22), PostID = 112, Title = "Copy Constructor", BloggerUrl = "http://justmycode.blogspot.com/2009/03/copy-constructor.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_19032009_b, RestOfContent = BlogPostsProgramming.content_19032009_r, Keywords = BlogPostsProgramming.content_19032009_k, Description = BlogPostsProgramming.content_19032009_d, DateCreated = new DateTime(2009, 3, 19), PostID = 113, Title = "DllImport Adventures", BloggerUrl = "http://justmycode.blogspot.com/2009/03/dllimport-adventures.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15032009_b, RestOfContent = BlogPostsProgramming.content_15032009_r, Keywords = BlogPostsProgramming.content_15032009_k, Description = BlogPostsProgramming.content_15032009_d, DateCreated = new DateTime(2009, 3, 15), PostID = 114, Title = "Image file handle adventures", BloggerUrl = "http://justmycode.blogspot.com/2009/03/image-file-handle-adventures.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14032009_b, RestOfContent = BlogPostsProgramming.content_14032009_r, Keywords = BlogPostsProgramming.content_14032009_k, Description = BlogPostsProgramming.content_14032009_d, DateCreated = new DateTime(2009, 3, 14), PostID = 115, Title = "Moving Ahead of Technology", BloggerUrl = "http://justmycode.blogspot.com/2009/03/moving-ahead-of-technology.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06032009_b, RestOfContent = BlogPostsProgramming.content_06032009_r, Keywords = BlogPostsProgramming.content_06032009_k, Description = BlogPostsProgramming.content_06032009_d, DateCreated = new DateTime(2009, 3, 6), PostID = 116, Title = "A Twisted Code Snippet", BloggerUrl = "http://justmycode.blogspot.com/2009/03/twisted-code-snippet.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02032009_b, RestOfContent = BlogPostsProgramming.content_02032009_r, Keywords = BlogPostsProgramming.content_02032009_k, Description = BlogPostsProgramming.content_02032009_d, DateCreated = new DateTime(2009, 3, 2), PostID = 117, Title = "C++ Runtime Libraries Adventures", BloggerUrl = "http://justmycode.blogspot.com/2009/03/c-runtime-libraries-adventures.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_23022009_b, RestOfContent = BlogPostsProgramming.content_23022009_r, Keywords = BlogPostsProgramming.content_23022009_k, Description = BlogPostsProgramming.content_23022009_d, DateCreated = new DateTime(2009, 2, 23), PostID = 118, Title = "Bootstrapper: scrap the bootstrapper", BloggerUrl = "http://justmycode.blogspot.com/2009/02/bootstrapper-scrap-bootstrapper.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_22022009_b, RestOfContent = BlogPostsProgramming.content_22022009_r, Keywords = BlogPostsProgramming.content_22022009_k, Description = BlogPostsProgramming.content_22022009_d, DateCreated = new DateTime(2009, 2, 22), PostID = 119, Title = "Bootstrapper adventures", BloggerUrl = "http://justmycode.blogspot.com/2009/02/bootstrapper-adventures.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_18022009_b, RestOfContent = BlogPostsProgramming.content_18022009_r, Keywords = BlogPostsProgramming.content_18022009_k, Description = BlogPostsProgramming.content_18022009_d, DateCreated = new DateTime(2009, 2, 18), PostID = 120, Title = "Mysterious validation function", BloggerUrl = "http://justmycode.blogspot.com/2009/02/mysterious-validation-function.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_16022009_b, RestOfContent = BlogPostsProgramming.content_16022009_r, Keywords = BlogPostsProgramming.content_16022009_k, Description = BlogPostsProgramming.content_16022009_d, DateCreated = new DateTime(2009, 2, 16), PostID = 121, Title = "A small functionality change", BloggerUrl = "http://justmycode.blogspot.com/2009/02/small-functionality-change.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12022009_b, RestOfContent = BlogPostsProgramming.content_12022009_r, Keywords = BlogPostsProgramming.content_12022009_k, Description = BlogPostsProgramming.content_12022009_d, DateCreated = new DateTime(2009, 2, 12), PostID = 122, Title = "Asynchronous calls to a WebService", BloggerUrl = "http://justmycode.blogspot.com/2009/02/asynchronous-calls-to-webservice.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11022009_b, RestOfContent = BlogPostsProgramming.content_11022009_r, Keywords = BlogPostsProgramming.content_11022009_k, Description = BlogPostsProgramming.content_11022009_d, DateCreated = new DateTime(2009, 2, 11), PostID = 123, Title = "Top-level exception handling", BloggerUrl = "http://justmycode.blogspot.com/2009/02/top-level-exception-handling.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10022009_b, RestOfContent = BlogPostsProgramming.content_10022009_r, Keywords = BlogPostsProgramming.content_10022009_k, Description = BlogPostsProgramming.content_10022009_d, DateCreated = new DateTime(2009, 2, 10), PostID = 124, Title = "Scanner Update", BloggerUrl = "http://justmycode.blogspot.com/2009/02/scanner-update.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09022009_b, RestOfContent = BlogPostsProgramming.content_09022009_r, Keywords = BlogPostsProgramming.content_09022009_k, Description = BlogPostsProgramming.content_09022009_d, DateCreated = new DateTime(2009, 2, 9), PostID = 125, Title = "Finding a scanner", BloggerUrl = "http://justmycode.blogspot.com/2009/02/finding-scanner.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05022009_b, RestOfContent = BlogPostsProgramming.content_05022009_r, Keywords = BlogPostsProgramming.content_05022009_k, Description = BlogPostsProgramming.content_05022009_d, DateCreated = new DateTime(2009, 2, 5), PostID = 126, Title = "Wrote a Windows Service", BloggerUrl = "http://justmycode.blogspot.com/2009/02/wrote-windows-service.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_04022009_b, RestOfContent = BlogPostsProgramming.content_04022009_r, Keywords = BlogPostsProgramming.content_26012009_k, Description = BlogPostsProgramming.content_26012009_d, DateCreated = new DateTime(2009, 2, 4), PostID = 127, Title = "Team Foundation Server 2008 Adventures", BloggerUrl = "http://justmycode.blogspot.com/2009/02/team-foundation-server-2008-adventures.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26012009_b, RestOfContent = BlogPostsProgramming.content_26012009_r, Keywords = BlogPostsProgramming.content_26012009_k, Description = BlogPostsProgramming.content_26012009_d, DateCreated = new DateTime(2009, 1, 26), PostID = 128, Title = "Another one!", BloggerUrl = "http://justmycode.blogspot.com/2009/01/another-one.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_20012009_b, RestOfContent = BlogPostsProgramming.content_20012009_r, Keywords = BlogPostsProgramming.content_20012009_k, Description = BlogPostsProgramming.content_20012009_d, DateCreated = new DateTime(2009, 1, 20), PostID = 129, Title = "Changed appearance", BloggerUrl = "http://justmycode.blogspot.com/2009/01/changed-appearance.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_16122008_b, RestOfContent = BlogPostsProgramming.content_16122008_r, Keywords = BlogPostsProgramming.content_16122008_k, Description = BlogPostsProgramming.content_16122008_d, DateCreated = new DateTime(2008, 12, 16), PostID = 130, Title = "My Visual Studio Error Puzzle", BloggerUrl = "http://justmycode.blogspot.com/2008/12/my-visual-studio-error-puzzle.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15122008_b, RestOfContent = BlogPostsProgramming.content_15122008_r, Keywords = BlogPostsProgramming.content_15122008_k, Description = BlogPostsProgramming.content_15122008_d, DateCreated = new DateTime(2008, 12, 15), PostID = 131, Title = "I'm a scanning developer", BloggerUrl = "http://justmycode.blogspot.com/2008/12/i-spent-couple-of-days-investigating.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10122008_b, RestOfContent = BlogPostsProgramming.content_10122008_r, Keywords = BlogPostsProgramming.content_10122008_k, Description = BlogPostsProgramming.content_10122008_d, DateCreated = new DateTime(2008, 12, 10), PostID = 132, Title = "I'm a stylish developer", BloggerUrl = "http://justmycode.blogspot.com/2008/12/r.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_13112008_b, RestOfContent = BlogPostsProgramming.content_13112008_r, Keywords = BlogPostsProgramming.content_13112008_k, Description = BlogPostsProgramming.content_13112008_d, DateCreated = new DateTime(2008, 11, 13), PostID = 133, Title = "Small Thing Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2008/11/small-thing-learned-today_13.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05112008_b, RestOfContent = BlogPostsProgramming.content_05112008_r, Keywords = BlogPostsProgramming.content_05112008_k, Description = BlogPostsProgramming.content_05112008_d, DateCreated = new DateTime(2008, 11, 5), PostID = 134, Title = "Small Thing Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2008/11/small-thing-learned-today.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_28102008_b, RestOfContent = BlogPostsProgramming.content_28102008_r, Keywords = BlogPostsProgramming.content_28102008_k, Description = BlogPostsProgramming.content_28102008_d, DateCreated = new DateTime(2008, 10, 28), PostID = 135, Title = "Offer Accepted", BloggerUrl = "http://justmycode.blogspot.com/2008/10/offer-accepted.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25102008_b, RestOfContent = BlogPostsProgramming.content_25102008_r, Keywords = BlogPostsProgramming.content_25102008_k, Description = BlogPostsProgramming.content_25102008_d, DateCreated = new DateTime(2008, 10, 25), PostID = 136, Title = "A Quick One Before I Forget", BloggerUrl = "http://justmycode.blogspot.com/2008/10/quick-one-before-i-forget.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_23102008_b, RestOfContent = BlogPostsProgramming.content_23102008_r, Keywords = BlogPostsProgramming.content_23102008_k, Description = BlogPostsProgramming.content_23102008_d, DateCreated = new DateTime(2008, 10, 23), PostID = 137, Title = "Small Thing Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2008/10/small-thing-learned-today_23.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_20102008_b, RestOfContent = BlogPostsProgramming.content_20102008_r, Keywords = BlogPostsProgramming.content_20102008_k, Description = BlogPostsProgramming.content_20102008_d, DateCreated = new DateTime(2008, 10, 20), PostID = 138, Title = "Small Thing Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2008/10/small-thing-learned-today_20.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_15102008_b, RestOfContent = BlogPostsProgramming.content_15102008_r, Keywords = BlogPostsProgramming.content_15102008_k, Description = BlogPostsProgramming.content_15102008_d, DateCreated = new DateTime(2008, 10, 15), PostID = 139, Title = "Small Thing Learned Today", BloggerUrl = "http://justmycode.blogspot.com/2008/10/small-thing-learned-today.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14102008_b, RestOfContent = BlogPostsProgramming.content_14102008_r, Keywords = BlogPostsProgramming.content_14102008_k, Description = BlogPostsProgramming.content_14102008_d, DateCreated = new DateTime(2008, 10, 14), PostID = 140, Title = "Very Busy This Week", BloggerUrl = "http://justmycode.blogspot.com/2008/10/very-busy-this-week.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09102008_b, RestOfContent = BlogPostsProgramming.content_09102008_r, Keywords = BlogPostsProgramming.content_09102008_k, Description = BlogPostsProgramming.content_09102008_d, DateCreated = new DateTime(2008, 10, 9), PostID = 141, Title = "Stack Overflow!", BloggerUrl = "http://justmycode.blogspot.com/2008/10/stack-overflow.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07102008_b, RestOfContent = BlogPostsProgramming.content_07102008_r, Keywords = BlogPostsProgramming.content_07102008_k, Description = BlogPostsProgramming.content_07102008_d, DateCreated = new DateTime(2008, 10, 7), PostID = 142, Title = "Browsing The Job Listings", BloggerUrl = "http://justmycode.blogspot.com/2008/10/browsing-job-listings.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06102008_b, RestOfContent = BlogPostsProgramming.content_06102008_r, Keywords = BlogPostsProgramming.content_06102008_k, Description = BlogPostsProgramming.content_06102008_d, DateCreated = new DateTime(2008, 10, 6), PostID = 143, Title = "Snippets", BloggerUrl = "http://justmycode.blogspot.com/2008/10/snippets.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05102008_b, RestOfContent = BlogPostsProgramming.content_05102008_r, Keywords = BlogPostsProgramming.content_05102008_k, Description = BlogPostsProgramming.content_05102008_d, DateCreated = new DateTime(2008, 10, 5), PostID = 144, Title = "Interview Question Of The Day", BloggerUrl = "http://justmycode.blogspot.com/2008/10/interview-question-of-day.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_04102008_b, RestOfContent = BlogPostsProgramming.content_04102008_r, Keywords = BlogPostsProgramming.content_04102008_k, Description = BlogPostsProgramming.content_04102008_d, DateCreated = new DateTime(2008, 10, 4), PostID = 145, Title = "A Well-known Interview Tip", BloggerUrl = "http://justmycode.blogspot.com/2008/10/well-known-interview-tip.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02102008_b, RestOfContent = BlogPostsProgramming.content_02102008_r, Keywords = BlogPostsProgramming.content_02102008_k, Description = BlogPostsProgramming.content_02102008_d, DateCreated = new DateTime(2008, 10, 2), PostID = 146, Title = "Exciting Day At Work", BloggerUrl = "http://justmycode.blogspot.com/2008/10/exciting-day-at-work.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_01102008_b, RestOfContent = BlogPostsProgramming.content_01102008_r, Keywords = BlogPostsProgramming.content_01102008_k, Description = BlogPostsProgramming.content_01102008_d, DateCreated = new DateTime(2008, 10, 1), PostID = 147, Title = "Now Reading", BloggerUrl = "http://justmycode.blogspot.com/2008/10/now-reading.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_30092008_b, RestOfContent = BlogPostsProgramming.content_30092008_r, Keywords = BlogPostsProgramming.content_30092008_k, Description = BlogPostsProgramming.content_30092008_d, DateCreated = new DateTime(2008, 9, 30), PostID = 148, Title = "My Favourite Anonymous Delegate", BloggerUrl = "http://justmycode.blogspot.com/2008/09/my-favourite-anonymous-delegate.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_29092008_b, RestOfContent = BlogPostsProgramming.content_29092008_r, Keywords = BlogPostsProgramming.content_29092008_k, Description = BlogPostsProgramming.content_29092008_d, DateCreated = new DateTime(2008, 9, 29), PostID = 149, Title = "Good Deed For The Day", BloggerUrl = "http://justmycode.blogspot.com/2008/09/good-deed-for-day.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_02122012_b, RestOfContent = BlogPostsProgramming.content_02122012_r, Keywords = BlogPostsProgramming.content_02122012_k, Description = BlogPostsProgramming.content_02122012_d, DateCreated = new DateTime(2012, 12, 2), PostID = 150, Title = "SEO Basics: Linking My Content to Google+ Using rel='author'", BloggerUrl = "http://justmycode.blogspot.com/2012/12/seo-basics-linking-my-content-to-google.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_28112012_b, RestOfContent = BlogPostsProgramming.content_28112012_r, Keywords = BlogPostsProgramming.content_28112012_k, Description = BlogPostsProgramming.content_28112012_d, DateCreated = new DateTime(2012, 11, 28), PostID = 151, Title = "MVC and SEO basics: inject title, keywords and description", BloggerUrl = "http://justmycode.blogspot.com/2012/11/mvc-and-seo-basics-inject-title.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26112012_b, RestOfContent = BlogPostsProgramming.content_26112012_r, Keywords = BlogPostsProgramming.content_26112012_k, Description = BlogPostsProgramming.content_26112012_d, DateCreated = new DateTime(2012, 11, 26), PostID = 152, Title = "WebGrid: AJAX Updates, Server Sorting", BloggerUrl = "http://justmycode.blogspot.com/2012/11/webgrid-ajax-updates-server-sorting.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25112012_b, RestOfContent = BlogPostsProgramming.content_25112012_r, Keywords = BlogPostsProgramming.content_25112012_k, Description = BlogPostsProgramming.content_25112012_d, DateCreated = new DateTime(2012, 11, 25), PostID = 153, Title = "WebGrid: Stronly Typed with Server Paging", BloggerUrl = "http://justmycode.blogspot.com/2012/11/webgrid-stronly-typed-with-server-paging.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_13112012_b, RestOfContent = BlogPostsProgramming.content_13112012_r, Keywords = BlogPostsProgramming.content_13112012_k, Description = BlogPostsProgramming.content_13112012_d, DateCreated = new DateTime(2012, 11, 13), PostID = 154, Title = "Starting with WebGrid", BloggerUrl = "http://justmycode.blogspot.com/2012/11/starting-with-webgrid.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_10122012_b, RestOfContent = BlogPostsProgramming.content_10122012_r, Keywords = BlogPostsProgramming.content_10122012_k, Description = BlogPostsProgramming.content_10122012_d, DateCreated = new DateTime(2012, 12, 10), PostID = 155, Title = "SEO Basics: Friendly URLs", BloggerUrl = "http://justmycode.blogspot.com/2012/12/seo-basics-friendly-urls.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_20122012_b, RestOfContent = BlogPostsProgramming.content_20122012_r, Keywords = BlogPostsProgramming.content_20122012_k, Description = BlogPostsProgramming.content_20122012_d, DateCreated = new DateTime(2012, 12, 20), PostID = 156, Title = "Implementing a Tree View - Small Case Study", BloggerUrl = "http://justmycode.blogspot.com.au/2012/12/implementing-tree-view-small-case-study.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05022013_b, RestOfContent = BlogPostsProgramming.content_05022013_r, Keywords = BlogPostsProgramming.content_05022013_k, Description = BlogPostsProgramming.content_05022013_d, DateCreated = new DateTime(2013, 02, 05), PostID = 157, Title = "Use of PostgreSQL Indexes", BloggerUrl = "http://justmycode.blogspot.com.au/2013/02/use-of-postgresql-indexes.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12022013_b, RestOfContent = BlogPostsProgramming.content_12022013_r, Keywords = BlogPostsProgramming.content_12022013_k, Description = BlogPostsProgramming.content_12022013_d, DateCreated = new DateTime(2013, 02, 12), PostID = 158, Title = "Photobox – CSS3 JQuery Image Gallery", BloggerUrl = "http://justmycode.blogspot.com.au/2013/02/photobox-css3-jquery-image-gallery.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_27112011_b, RestOfContent = BlogPostsBiology.content_27112011_r, Keywords = BlogPostsBiology.content_27112011_k, Description = BlogPostsBiology.content_27112011_d, DateCreated = new DateTime(2011, 11, 27), PostID = 159, Title = "Models in Biology", BloggerUrl = "http://southernblot.blogspot.com/2011/11/models-in-biology.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_07122011_b, RestOfContent = BlogPostsBiology.content_07122011_r, Keywords = BlogPostsBiology.content_07122011_k, Description = BlogPostsBiology.content_07122011_d, DateCreated = new DateTime(2011, 12, 7), PostID = 160, Title = "Starting with Cytoscape", BloggerUrl = "http://southernblot.blogspot.com/2011/12/starting-with-cytoscape.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_25122011_b, RestOfContent = BlogPostsBiology.content_25122011_r, Keywords = BlogPostsBiology.content_25122011_k, Description = BlogPostsBiology.content_25122011_d, DateCreated = new DateTime(2011, 12, 25), PostID = 161, Title = "Network Topology", BloggerUrl = "http://southernblot.blogspot.com/2011/12/network-topology.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_25022012_b, RestOfContent = BlogPostsBiology.content_25022012_r, Keywords = BlogPostsBiology.content_25022012_k, Description = BlogPostsBiology.content_25022012_d, DateCreated = new DateTime(2012, 2, 25), PostID = 162, Title = "Adding Expression Data to the Network", BloggerUrl = "http://southernblot.blogspot.com/2011/12/adding-expression-data-to-network.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_09012012_b, RestOfContent = BlogPostsBiology.content_09012012_r, Keywords = BlogPostsBiology.content_09012012_k, Description = BlogPostsBiology.content_09012012_d, DateCreated = new DateTime(2012, 1, 9), PostID = 163, Title = "Validating Active Modules with BiNGO", BloggerUrl = "http://southernblot.blogspot.com/2012/01/validating-active-modules-with-bingo.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_23022012_b, RestOfContent = BlogPostsBiology.content_23022012_r, Keywords = BlogPostsBiology.content_23022012_k, Description = BlogPostsBiology.content_23022012_d, DateCreated = new DateTime(2012, 2, 23), PostID = 164, Title = "Building a model for the mouse response to Trypanosoma Congolense using jActiveModules and BiNGO", BloggerUrl = "http://southernblot.blogspot.com/2012/02/building-model-for-mouse-response-to.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_27112012_b, RestOfContent = BlogPostsBiology.content_27112012_r, Keywords = BlogPostsBiology.content_27112012_k, Description = BlogPostsBiology.content_27112012_d, DateCreated = new DateTime(2012, 11, 27), PostID = 165, Title = "COPASI and CellDesigner: Comparison", BloggerUrl = "http://southernblot.blogspot.com/2012/11/copasi-and-celldesigner-comparison.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_29102012_b, RestOfContent = BlogPostsBiology.content_29102012_r, Keywords = BlogPostsBiology.content_29102012_k, Description = BlogPostsBiology.content_29102012_d, DateCreated = new DateTime(2012, 10, 29), PostID = 166, Title = "Calculation of Phase Space Models with COPASI", BloggerUrl = "http://southernblot.blogspot.com/2012/10/calculation-of-phase-space-models-with.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_15052012_b, RestOfContent = BlogPostsBiology.content_15052012_r, Keywords = BlogPostsBiology.content_15052012_k, Description = BlogPostsBiology.content_15052012_d, DateCreated = new DateTime(2012, 5, 15), PostID = 167, Title = "Estimating Michaelis-Menten Parameters", BloggerUrl = "http://southernblot.blogspot.com/2012/05/estimating-michaelis-menten-parameters.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_20122012_b, RestOfContent = BlogPostsBiology.content_20122012_r, Keywords = BlogPostsBiology.content_20122012_k, Description = BlogPostsBiology.content_20122012_d, DateCreated = new DateTime(2012, 12, 20), PostID = 168, Title = "Stoichiometry matrix", BloggerUrl = "http://southernblot.blogspot.com/2012/12/stoichiometry-matrix.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_01082012_b, RestOfContent = BlogPostsBiology.content_01082012_r, Keywords = BlogPostsBiology.content_01082012_k, Description = BlogPostsBiology.content_01082012_d, DateCreated = new DateTime(2011, 8, 1), PostID = 169, Title = "A Tutorial on Probability and Exponential Distribution", BloggerUrl = "http://southernblot.blogspot.com/2012/08/a-tutorial-on-probability-and.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_04082012_b, RestOfContent = BlogPostsBiology.content_04082012_r, Keywords = BlogPostsBiology.content_04082012_k, Description = BlogPostsBiology.content_04082012_d, DateCreated = new DateTime(2011, 11, 27), PostID = 170, Title = "Statistical Inference", BloggerUrl = "http://southernblot.blogspot.com/2012/08/statistical-inference.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_13092012_b, RestOfContent = BlogPostsBiology.content_13092012_r, Keywords = BlogPostsBiology.content_13092012_k, Description = BlogPostsBiology.content_13092012_d, DateCreated = new DateTime(2012, 9, 13), PostID = 171, Title = "Markov Chains Monte Carlo Bayesian Inference", BloggerUrl = "http://southernblot.blogspot.com/2012/09/markov-chains-monte-carlo-bayesian.html" },
new Post { BlogID = 2, BriefContent = BlogPostsProgramming.content_06042013_b, RestOfContent = BlogPostsProgramming.content_06042013_r, Keywords = BlogPostsProgramming.content_06042013_k, Description = BlogPostsProgramming.content_06042013_d, DateCreated = new DateTime(2013, 04, 06), PostID = 178, Title = "Project ROSALIND: Rabbits and Recurrence Relations", BloggerUrl = "http://southernblot.blogspot.com.au/2013/04/project-rosalind-rabbits-and-recurrence.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_30042013_b, RestOfContent = BlogPostsBiology.content_30042013_r, Keywords = BlogPostsBiology.content_30042013_k, Description = BlogPostsBiology.content_30042013_d, DateCreated = new DateTime(2013, 04, 30), PostID = 180, Title = "Project ROSALIND: Finding a Protein Motif" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_27022013_b, RestOfContent = BlogPostsProgramming.content_27022013_r, Keywords = BlogPostsProgramming.content_27022013_k, Description = BlogPostsProgramming.content_27022013_d, DateCreated = new DateTime(2013, 02, 27), PostID = 172, Title = "On PostgreSQL Inverse mode and database audit table triggers", BloggerUrl = "http://justmycode.blogspot.com.au/2013/02/on-postgresql-inverse-mode-and-database.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11032013_b, RestOfContent = BlogPostsProgramming.content_11032013_r, Keywords = BlogPostsProgramming.content_11032013_k, Description = BlogPostsProgramming.content_11032013_d, DateCreated = new DateTime(2013, 03, 11), PostID = 173, Title = "Fixing PostgreSQL index bloating with scheduled REINDEX via pgAgent", BloggerUrl = "http://justmycode.blogspot.com.au/2013/03/fixing-postgresql-index-bloating-with.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_21032013_b, RestOfContent = BlogPostsProgramming.content_21032013_r, Keywords = BlogPostsProgramming.content_21032013_k, Description = BlogPostsProgramming.content_21032013_d, DateCreated = new DateTime(2013, 03, 21), PostID = 174, Title = "Improving a PostgreSQL report performance: Part 1 - RETURN QUERY EXECUTE", BloggerUrl = "http://justmycode.blogspot.com.au/2013/03/improving-postgresql-report-performance.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25032013_b, RestOfContent = BlogPostsProgramming.content_25032013_r, Keywords = BlogPostsProgramming.content_25032013_k, Description = BlogPostsProgramming.content_25032013_d, DateCreated = new DateTime(2013, 03, 25), PostID = 175, Title = "Implementing a Simple Logging Engine with MVC 4", BloggerUrl = "http://justmycode.blogspot.com.au/2013/03/implementing-simple-logging-engine-with.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_28032013_b, RestOfContent = BlogPostsProgramming.content_28032013_r, Keywords = BlogPostsProgramming.content_28032013_k, Description = BlogPostsProgramming.content_28032013_d, DateCreated = new DateTime(2013, 03, 28), PostID = 176, Title = "Improving a PostgreSQL report performance: Part 2 - Temporary Table", BloggerUrl = "http://justmycode.blogspot.com.au/2013/03/improving-postgresql-report-performance_27.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_06042013_b, RestOfContent = BlogPostsProgramming.content_06042013_r, Keywords = BlogPostsProgramming.content_06042013_k, Description = BlogPostsProgramming.content_06042013_d, DateCreated = new DateTime(2013, 04, 06), PostID = 177, Title = "Project ROSALIND: Rabbits and Recurrence Relations", BloggerUrl = "http://justmycode.blogspot.com.au/2013/04/project-rosalind-rabbits-and-recurrence.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_07042013_b, RestOfContent = BlogPostsProgramming.content_07042013_r, Keywords = BlogPostsProgramming.content_07042013_k, Description = BlogPostsProgramming.content_07042013_d, DateCreated = new DateTime(2013, 04, 07), PostID = 179, Title = "Google as my automated testing tool", BloggerUrl = "http://justmycode.blogspot.com.au/2013/04/google-as-my-automated-testing-tool.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14052013_b, RestOfContent = BlogPostsProgramming.content_14052013_r, Keywords = BlogPostsProgramming.content_14052013_k, Description = BlogPostsProgramming.content_14052013_d, DateCreated = new DateTime(2013, 05, 14), PostID = 181, Title = "Customising Windows Installation", BloggerUrl = "http://justmycode.blogspot.com.au/2013/05/customising-windows-installation.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_14052013_b, RestOfContent = BlogPostsBiology.content_14052013_r, Keywords = BlogPostsBiology.content_14052013_k, Description = BlogPostsBiology.content_14052013_d, DateCreated = new DateTime(2013, 05, 14), PostID = 182, Title = "Metabolic Control Analysis and Enzyme Kinetics", BloggerUrl = "http://southernblot.blogspot.com.au/2013/05/metabolic-control-analysis-and-enzyme.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_01062013_b, RestOfContent = BlogPostsBiology.content_01062013_r, Keywords = BlogPostsBiology.content_01062013_k, Description = BlogPostsBiology.content_01062013_d, DateCreated = new DateTime(2013, 06, 01), PostID = 183, Title = "Some string manipulations for future use.", BloggerUrl = "http://southernblot.blogspot.com.au/2013/06/some-string-manipulations-for-future-use.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_10062013_b, RestOfContent = BlogPostsBiology.content_10062013_r, Keywords = BlogPostsBiology.content_10062013_k, Description = BlogPostsBiology.content_10062013_d, DateCreated = new DateTime(2013, 06, 10), PostID = 184, Title = "Project ROSALIND: Finding a shortest superstring", BloggerUrl = "http://southernblot.blogspot.com.au/2013/06/project-rosalind-finding-shortest.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_25062013_b, RestOfContent = BlogPostsProgramming.content_25062013_r, Keywords = BlogPostsProgramming.content_25062013_k, Description = BlogPostsProgramming.content_25062013_d, DateCreated = new DateTime(2013, 06, 25), PostID = 185, Title = "Optimising Windows Updates Installation", BloggerUrl = "http://justmycode.blogspot.com.au/2013/06/optimising-windows-updates-installation.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_29062013_b, RestOfContent = BlogPostsProgramming.content_29062013_r, Keywords = BlogPostsProgramming.content_29062013_k, Description = BlogPostsProgramming.content_29062013_d, DateCreated = new DateTime(2013, 06, 29), PostID = 186, Title = "Final Hurdles While Installing Windows Updates", BloggerUrl = "http://justmycode.blogspot.com.au/2013/06/final-hurdles-while-installing-windows.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_09072013_b, RestOfContent = BlogPostsProgramming.content_09072013_r, Keywords = BlogPostsProgramming.content_09072013_k, Description = BlogPostsProgramming.content_09072013_d, DateCreated = new DateTime(2013, 07, 09), PostID = 187, Title = "In SQL Query, Only Return Every n-th Record", BloggerUrl = "http://justmycode.blogspot.com.au/2013/07/in-sql-query-only-return-every-n-th.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_14072013_b, RestOfContent = BlogPostsProgramming.content_14072013_r, Keywords = BlogPostsProgramming.content_14072013_k, Description = BlogPostsProgramming.content_14072013_d, DateCreated = new DateTime(2013, 07, 14), PostID = 188, Title = "A Little Strangeness in the Way A Script is Run by Registry", BloggerUrl = "http://justmycode.blogspot.com.au/2013/07/a-little-strangeness-in-way-script-is.html" },
new Post { BlogID = 2, BriefContent = BlogPostsBiology.content_13072013_b, RestOfContent = BlogPostsBiology.content_13072013_r, Keywords = BlogPostsBiology.content_13072013_k, Description = BlogPostsBiology.content_13072013_d, DateCreated = new DateTime(2013, 07, 13), PostID = 189, Title = "Stochastic and deterministic modelling.", BloggerUrl = "http://southernblot.blogspot.com.au/2013/07/stochastic-and-deterministic-modelling.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_12082013_b, RestOfContent = BlogPostsProgramming.content_12082013_r, Keywords = BlogPostsProgramming.content_12082013_k, Description = BlogPostsProgramming.content_12082013_d, DateCreated = new DateTime(2013, 08, 12), PostID = 190, Title = "Using Active Setup to Update Anything in HKEY_CURRENT_USER", BloggerUrl = "http://justmycode.blogspot.dk/2013/08/using-active-setup-to-update-anything.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26122013_b, RestOfContent = BlogPostsProgramming.content_26122013_r, Keywords = BlogPostsProgramming.content_26122013_k, Description = BlogPostsProgramming.content_26122013_d, DateCreated = new DateTime(2013, 12, 26), PostID = 191, Title = "Minimal Change Problem", BloggerUrl = "http://justmycode.blogspot.dk/2013/12/minimal-change-problem.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_11032014_b, RestOfContent = BlogPostsProgramming.content_11032014_r, Keywords = BlogPostsProgramming.content_11032014_k, Description = BlogPostsProgramming.content_11032014_d, DateCreated = new DateTime(2014, 03, 11), PostID = 192, Title = "Manhattan Tourist problem", BloggerUrl = "http://justmycode.blogspot.dk/2014/03/manhattan-tourist-problem.html" },
new Post { BlogID = 2, BriefContent = BlogPostsProgramming.content_11032014_b, RestOfContent = BlogPostsProgramming.content_11032014_r, Keywords = BlogPostsProgramming.content_11032014_k, Description = BlogPostsProgramming.content_11032014_d, DateCreated = new DateTime(2014, 03, 11), PostID = 193, Title = "Manhattan Tourist problem", BloggerUrl = "http://southernblot.blogspot.dk/2014/03/manhattan-tourist-problem.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_13032014_b, RestOfContent = BlogPostsProgramming.content_13032014_r, Keywords = BlogPostsProgramming.content_13032014_k, Description = BlogPostsProgramming.content_13032014_d, DateCreated = new DateTime(2014, 03, 13), PostID = 194, Title = "Global alignment problem", BloggerUrl = "http://justmycode.blogspot.dk/2014/03/global-alignment-problem.html" },
new Post { BlogID = 2, BriefContent = BlogPostsProgramming.content_13032014_b, RestOfContent = BlogPostsProgramming.content_13032014_r, Keywords = BlogPostsProgramming.content_13032014_k, Description = BlogPostsProgramming.content_13032014_d, DateCreated = new DateTime(2014, 03, 13), PostID = 195, Title = "Global alignment problem", BloggerUrl = "http://southernblot.blogspot.dk/2014/03/global-alignment-problem.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_26032014_b, RestOfContent = BlogPostsProgramming.content_26032014_r, Keywords = BlogPostsProgramming.content_26032014_k, Description = BlogPostsProgramming.content_26032014_d, DateCreated = new DateTime(2014, 03, 26), PostID = 196, Title = "Adding Areas to the Existing ASP.NET MVC Project" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_05122014_b, RestOfContent = BlogPostsProgramming.content_05122014_r, Keywords = BlogPostsProgramming.content_05122014_k, Description = BlogPostsProgramming.content_05122014_d, DateCreated = new DateTime(2014, 12, 05), PostID = 197, Title = "My First Mobile Application.", BloggerUrl = "http://justmycode.blogspot.dk/2014/11/my-first-mobile-application.html" },
new Post { BlogID = 1, BriefContent = BlogPostsProgramming.content_08122014_b, RestOfContent = BlogPostsProgramming.content_08122014_r, Keywords = BlogPostsProgramming.content_08122014_k, Description = BlogPostsProgramming.content_08122014_d, DateCreated = new DateTime(2014, 12, 08), PostID = 198, Title = "My First Mobile Application - With More Functionality", BloggerUrl = "http://justmycode.blogspot.dk/2014/12/my-first-mobile-application-with-more.html" },
};
posts.ForEach(p => context.Posts.Add(p));
context.SaveChanges();
context.PostLabels.Add(new PostLabel { PostLabelID = 1, PostID = 173, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 2, PostID = 173, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 3, PostID = 173, LabelID = 4 });
context.PostLabels.Add(new PostLabel { PostLabelID = 4, PostID = 172, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 5, PostID = 172, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 6, PostID = 172, LabelID = 4 });
context.PostLabels.Add(new PostLabel { PostLabelID = 7, PostID = 158, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 8, PostID = 158, LabelID = 5 });
context.PostLabels.Add(new PostLabel { PostLabelID = 9, PostID = 158, LabelID = 6 });
context.PostLabels.Add(new PostLabel { PostLabelID = 10, PostID = 157, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 11, PostID = 157, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 12, PostID = 157, LabelID = 4 });
context.PostLabels.Add(new PostLabel { PostLabelID = 13, PostID = 156, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 14, PostID = 156, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 15, PostID = 156, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 16, PostID = 1, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 17, PostID = 1, LabelID = 9 });
context.PostLabels.Add(new PostLabel { PostLabelID = 18, PostID = 2, LabelID = 6 });
context.PostLabels.Add(new PostLabel { PostLabelID = 19, PostID = 2, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 20, PostID = 2, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 21, PostID = 3, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 22, PostID = 3, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 23, PostID = 4, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 24, PostID = 4, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 25, PostID = 4, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 26, PostID = 5, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 27, PostID = 5, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 28, PostID = 6, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 29, PostID = 6, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 30, PostID = 6, LabelID = 10 });
context.PostLabels.Add(new PostLabel { PostLabelID = 31, PostID = 7, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 32, PostID = 7, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 33, PostID = 7, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 34, PostID = 7, LabelID = 6 });
context.PostLabels.Add(new PostLabel { PostLabelID = 35, PostID = 8, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 36, PostID = 8, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 37, PostID = 9, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 38, PostID = 9, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 39, PostID = 9, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 40, PostID = 10, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 41, PostID = 10, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 42, PostID = 159, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 43, PostID = 159, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 44, PostID = 160, LabelID = 20 });
context.PostLabels.Add(new PostLabel { PostLabelID = 45, PostID = 161, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 46, PostID = 161, LabelID = 15 });
context.PostLabels.Add(new PostLabel { PostLabelID = 47, PostID = 161, LabelID = 20 });
context.PostLabels.Add(new PostLabel { PostLabelID = 48, PostID = 162, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 49, PostID = 162, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 50, PostID = 162, LabelID = 15 });
context.PostLabels.Add(new PostLabel { PostLabelID = 51, PostID = 162, LabelID = 20 });
context.PostLabels.Add(new PostLabel { PostLabelID = 52, PostID = 163, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 53, PostID = 163, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 54, PostID = 163, LabelID = 19 });
context.PostLabels.Add(new PostLabel { PostLabelID = 55, PostID = 163, LabelID = 20 });
context.PostLabels.Add(new PostLabel { PostLabelID = 56, PostID = 164, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 57, PostID = 164, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 58, PostID = 164, LabelID = 19 });
context.PostLabels.Add(new PostLabel { PostLabelID = 59, PostID = 164, LabelID = 20 });
context.PostLabels.Add(new PostLabel { PostLabelID = 60, PostID = 164, LabelID = 15 });
context.PostLabels.Add(new PostLabel { PostLabelID = 61, PostID = 165, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 62, PostID = 165, LabelID = 14 });
context.PostLabels.Add(new PostLabel { PostLabelID = 63, PostID = 165, LabelID = 13 });
context.PostLabels.Add(new PostLabel { PostLabelID = 64, PostID = 165, LabelID = 15 });
context.PostLabels.Add(new PostLabel { PostLabelID = 65, PostID = 166, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 66, PostID = 166, LabelID = 13 });
context.PostLabels.Add(new PostLabel { PostLabelID = 67, PostID = 166, LabelID = 16 });
context.PostLabels.Add(new PostLabel { PostLabelID = 68, PostID = 167, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 69, PostID = 167, LabelID = 18 });
context.PostLabels.Add(new PostLabel { PostLabelID = 70, PostID = 168, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 71, PostID = 168, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 72, PostID = 168, LabelID = 13 });
context.PostLabels.Add(new PostLabel { PostLabelID = 73, PostID = 169, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 74, PostID = 169, LabelID = 17 });
context.PostLabels.Add(new PostLabel { PostLabelID = 75, PostID = 170, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 76, PostID = 170, LabelID = 17 });
context.PostLabels.Add(new PostLabel { PostLabelID = 77, PostID = 171, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 78, PostID = 171, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 79, PostID = 11, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 80, PostID = 11, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 81, PostID = 11, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 82, PostID = 12, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 83, PostID = 12, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 84, PostID = 12, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 85, PostID = 13, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 86, PostID = 13, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 87, PostID = 13, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 88, PostID = 14, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 89, PostID = 14, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 90, PostID = 14, LabelID = 22 });
context.PostLabels.Add(new PostLabel { PostLabelID = 91, PostID = 15, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 92, PostID = 15, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 93, PostID = 15, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 94, PostID = 16, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 95, PostID = 16, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 96, PostID = 16, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 97, PostID = 17, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 98, PostID = 17, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 99, PostID = 17, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 100, PostID = 18, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 101, PostID = 18, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 102, PostID = 18, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 103, PostID = 18, LabelID = 23 });
context.PostLabels.Add(new PostLabel { PostLabelID = 104, PostID = 19, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 105, PostID = 19, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 106, PostID = 19, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 107, PostID = 19, LabelID = 23 });
context.PostLabels.Add(new PostLabel { PostLabelID = 108, PostID = 20, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 109, PostID = 20, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 110, PostID = 20, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 111, PostID = 21, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 112, PostID = 21, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 113, PostID = 21, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 114, PostID = 22, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 115, PostID = 22, LabelID = 24 });
context.PostLabels.Add(new PostLabel { PostLabelID = 116, PostID = 23, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 117, PostID = 23, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 118, PostID = 23, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 119, PostID = 24, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 120, PostID = 24, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 121, PostID = 24, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 122, PostID = 24, LabelID = 26 });
context.PostLabels.Add(new PostLabel { PostLabelID = 123, PostID = 25, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 124, PostID = 25, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 125, PostID = 25, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 126, PostID = 25, LabelID = 26 });
context.PostLabels.Add(new PostLabel { PostLabelID = 127, PostID = 26, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 128, PostID = 26, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 129, PostID = 26, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 130, PostID = 26, LabelID = 26 });
context.PostLabels.Add(new PostLabel { PostLabelID = 131, PostID = 27, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 132, PostID = 27, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 133, PostID = 27, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 134, PostID = 28, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 135, PostID = 28, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 136, PostID = 28, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 137, PostID = 29, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 138, PostID = 29, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 139, PostID = 29, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 140, PostID = 30, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 141, PostID = 30, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 142, PostID = 30, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 143, PostID = 31, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 144, PostID = 31, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 145, PostID = 31, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 146, PostID = 32, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 147, PostID = 32, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 148, PostID = 32, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 149, PostID = 33, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 150, PostID = 33, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 151, PostID = 33, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 152, PostID = 34, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 153, PostID = 34, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 154, PostID = 34, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 155, PostID = 35, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 156, PostID = 35, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 157, PostID = 35, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 158, PostID = 36, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 159, PostID = 36, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 160, PostID = 36, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 161, PostID = 37, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 162, PostID = 37, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 163, PostID = 37, LabelID = 25 });
context.PostLabels.Add(new PostLabel { PostLabelID = 164, PostID = 38, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 165, PostID = 38, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 166, PostID = 39, LabelID = 28 });
context.PostLabels.Add(new PostLabel { PostLabelID = 167, PostID = 40, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 168, PostID = 40, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 169, PostID = 41, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 170, PostID = 41, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 171, PostID = 42, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 172, PostID = 42, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 173, PostID = 43, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 174, PostID = 43, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 175, PostID = 44, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 176, PostID = 44, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 177, PostID = 45, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 178, PostID = 45, LabelID = 27 });
context.PostLabels.Add(new PostLabel { PostLabelID = 179, PostID = 46, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 180, PostID = 46, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 181, PostID = 47, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 182, PostID = 47, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 183, PostID = 47, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 184, PostID = 48, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 185, PostID = 48, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 186, PostID = 48, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 187, PostID = 49, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 188, PostID = 49, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 189, PostID = 49, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 190, PostID = 49, LabelID = 5 });
context.PostLabels.Add(new PostLabel { PostLabelID = 191, PostID = 50, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 192, PostID = 50, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 193, PostID = 50, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 194, PostID = 51, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 195, PostID = 51, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 196, PostID = 51, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 197, PostID = 52, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 198, PostID = 52, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 199, PostID = 53, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 200, PostID = 53, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 201, PostID = 53, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 202, PostID = 54, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 203, PostID = 54, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 204, PostID = 54, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 205, PostID = 55, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 206, PostID = 55, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 207, PostID = 55, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 208, PostID = 56, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 209, PostID = 56, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 210, PostID = 56, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 211, PostID = 57, LabelID = 10 });
context.PostLabels.Add(new PostLabel { PostLabelID = 212, PostID = 58, LabelID = 30 });
context.PostLabels.Add(new PostLabel { PostLabelID = 213, PostID = 59, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 214, PostID = 59, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 215, PostID = 59, LabelID = 31 });
context.PostLabels.Add(new PostLabel { PostLabelID = 216, PostID = 60, LabelID = 32 });
context.PostLabels.Add(new PostLabel { PostLabelID = 217, PostID = 61, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 218, PostID = 61, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 219, PostID = 61, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 220, PostID = 61, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 221, PostID = 61, LabelID = 33 });
context.PostLabels.Add(new PostLabel { PostLabelID = 222, PostID = 62, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 223, PostID = 62, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 224, PostID = 62, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 225, PostID = 62, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 226, PostID = 62, LabelID = 33 });
context.PostLabels.Add(new PostLabel { PostLabelID = 227, PostID = 63, LabelID = 28 });
context.PostLabels.Add(new PostLabel { PostLabelID = 228, PostID = 63, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 229, PostID = 63, LabelID = 35 });
context.PostLabels.Add(new PostLabel { PostLabelID = 230, PostID = 64, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 231, PostID = 64, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 232, PostID = 64, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 233, PostID = 64, LabelID = 35 });
context.PostLabels.Add(new PostLabel { PostLabelID = 234, PostID = 65, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 235, PostID = 65, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 236, PostID = 65, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 237, PostID = 65, LabelID = 33 });
context.PostLabels.Add(new PostLabel { PostLabelID = 238, PostID = 66, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 239, PostID = 66, LabelID = 31 });
context.PostLabels.Add(new PostLabel { PostLabelID = 240, PostID = 66, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 241, PostID = 67, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 242, PostID = 67, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 243, PostID = 67, LabelID = 33 });
context.PostLabels.Add(new PostLabel { PostLabelID = 244, PostID = 68, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 245, PostID = 68, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 246, PostID = 68, LabelID = 21 });
context.PostLabels.Add(new PostLabel { PostLabelID = 247, PostID = 69, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 248, PostID = 70, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 249, PostID = 70, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 250, PostID = 70, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 251, PostID = 71, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 252, PostID = 71, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 253, PostID = 72, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 254, PostID = 72, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 255, PostID = 73, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 256, PostID = 73, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 257, PostID = 73, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 258, PostID = 73, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 259, PostID = 74, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 260, PostID = 74, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 261, PostID = 74, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 262, PostID = 75, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 263, PostID = 75, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 264, PostID = 76, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 265, PostID = 76, LabelID = 36 });
context.PostLabels.Add(new PostLabel { PostLabelID = 266, PostID = 77, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 267, PostID = 77, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 268, PostID = 77, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 269, PostID = 78, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 270, PostID = 78, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 271, PostID = 78, LabelID = 23 });
context.PostLabels.Add(new PostLabel { PostLabelID = 272, PostID = 78, LabelID = 37 });
context.PostLabels.Add(new PostLabel { PostLabelID = 273, PostID = 79, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 274, PostID = 79, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 275, PostID = 79, LabelID = 23 });
context.PostLabels.Add(new PostLabel { PostLabelID = 276, PostID = 79, LabelID = 37 });
context.PostLabels.Add(new PostLabel { PostLabelID = 277, PostID = 80, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 278, PostID = 80, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 279, PostID = 80, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 280, PostID = 80, LabelID = 37 });
context.PostLabels.Add(new PostLabel { PostLabelID = 281, PostID = 81, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 282, PostID = 81, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 283, PostID = 81, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 284, PostID = 82, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 285, PostID = 82, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 286, PostID = 82, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 287, PostID = 83, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 288, PostID = 83, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 289, PostID = 83, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 290, PostID = 83, LabelID = 23 });
context.PostLabels.Add(new PostLabel { PostLabelID = 291, PostID = 84, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 292, PostID = 84, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 293, PostID = 84, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 294, PostID = 85, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 295, PostID = 85, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 296, PostID = 85, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 297, PostID = 86, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 298, PostID = 86, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 299, PostID = 86, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 300, PostID = 87, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 301, PostID = 87, LabelID = 38 });
context.PostLabels.Add(new PostLabel { PostLabelID = 302, PostID = 88, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 303, PostID = 88, LabelID = 38 });
context.PostLabels.Add(new PostLabel { PostLabelID = 304, PostID = 89, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 305, PostID = 89, LabelID = 39 });
context.PostLabels.Add(new PostLabel { PostLabelID = 306, PostID = 90, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 307, PostID = 90, LabelID = 39 });
context.PostLabels.Add(new PostLabel { PostLabelID = 308, PostID = 91, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 309, PostID = 91, LabelID = 39 });
context.PostLabels.Add(new PostLabel { PostLabelID = 310, PostID = 92, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 311, PostID = 92, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 312, PostID = 92, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 313, PostID = 92, LabelID = 23 });
context.PostLabels.Add(new PostLabel { PostLabelID = 314, PostID = 93, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 315, PostID = 93, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 316, PostID = 93, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 317, PostID = 93, LabelID = 39 });
context.PostLabels.Add(new PostLabel { PostLabelID = 318, PostID = 94, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 319, PostID = 94, LabelID = 39 });
context.PostLabels.Add(new PostLabel { PostLabelID = 320, PostID = 94, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 321, PostID = 94, LabelID = 40 });
context.PostLabels.Add(new PostLabel { PostLabelID = 322, PostID = 95, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 323, PostID = 95, LabelID = 41 });
context.PostLabels.Add(new PostLabel { PostLabelID = 324, PostID = 96, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 325, PostID = 96, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 326, PostID = 96, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 327, PostID = 97, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 328, PostID = 97, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 329, PostID = 97, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 330, PostID = 98, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 331, PostID = 98, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 332, PostID = 98, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 333, PostID = 98, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 334, PostID = 99, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 335, PostID = 99, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 336, PostID = 100, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 337, PostID = 100, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 338, PostID = 101, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 339, PostID = 101, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 340, PostID = 102, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 341, PostID = 102, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 342, PostID = 103, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 343, PostID = 103, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 344, PostID = 104, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 345, PostID = 104, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 346, PostID = 105, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 347, PostID = 105, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 348, PostID = 106, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 349, PostID = 106, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 350, PostID = 107, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 351, PostID = 107, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 352, PostID = 107, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 353, PostID = 108, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 354, PostID = 108, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 355, PostID = 109, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 356, PostID = 109, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 357, PostID = 110, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 358, PostID = 110, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 359, PostID = 110, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 360, PostID = 111, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 361, PostID = 111, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 362, PostID = 111, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 363, PostID = 111, LabelID = 26 });
context.PostLabels.Add(new PostLabel { PostLabelID = 364, PostID = 111, LabelID = 40 });
context.PostLabels.Add(new PostLabel { PostLabelID = 365, PostID = 112, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 366, PostID = 112, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 367, PostID = 113, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 368, PostID = 113, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 369, PostID = 113, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 370, PostID = 114, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 371, PostID = 114, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 372, PostID = 114, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 373, PostID = 115, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 374, PostID = 116, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 375, PostID = 116, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 376, PostID = 116, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 377, PostID = 117, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 378, PostID = 118, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 379, PostID = 118, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 380, PostID = 118, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 381, PostID = 119, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 382, PostID = 120, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 383, PostID = 120, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 384, PostID = 120, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 385, PostID = 121, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 386, PostID = 121, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 387, PostID = 121, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 388, PostID = 122, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 389, PostID = 122, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 390, PostID = 122, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 391, PostID = 123, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 392, PostID = 123, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 393, PostID = 123, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 394, PostID = 124, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 395, PostID = 124, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 396, PostID = 124, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 397, PostID = 125, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 398, PostID = 125, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 399, PostID = 125, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 400, PostID = 126, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 401, PostID = 126, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 402, PostID = 126, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 403, PostID = 127, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 404, PostID = 127, LabelID = 29 });
context.PostLabels.Add(new PostLabel { PostLabelID = 405, PostID = 128, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 406, PostID = 129, LabelID = 28 });
context.PostLabels.Add(new PostLabel { PostLabelID = 407, PostID = 130, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 408, PostID = 130, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 409, PostID = 130, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 410, PostID = 131, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 411, PostID = 131, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 412, PostID = 132, LabelID = 28 });
context.PostLabels.Add(new PostLabel { PostLabelID = 413, PostID = 133, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 414, PostID = 133, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 415, PostID = 134, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 416, PostID = 134, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 417, PostID = 135, LabelID = 42 });
context.PostLabels.Add(new PostLabel { PostLabelID = 418, PostID = 136, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 419, PostID = 137, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 420, PostID = 137, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 421, PostID = 137, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 422, PostID = 138, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 423, PostID = 138, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 424, PostID = 139, LabelID = 34 });
context.PostLabels.Add(new PostLabel { PostLabelID = 425, PostID = 140, LabelID = 42 });
context.PostLabels.Add(new PostLabel { PostLabelID = 426, PostID = 141, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 427, PostID = 142, LabelID = 42 });
context.PostLabels.Add(new PostLabel { PostLabelID = 428, PostID = 143, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 429, PostID = 143, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 430, PostID = 144, LabelID = 42 });
context.PostLabels.Add(new PostLabel { PostLabelID = 431, PostID = 145, LabelID = 42 });
context.PostLabels.Add(new PostLabel { PostLabelID = 432, PostID = 146, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 433, PostID = 147, LabelID = 43 });
context.PostLabels.Add(new PostLabel { PostLabelID = 434, PostID = 148, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 435, PostID = 149, LabelID = 28 });
context.PostLabels.Add(new PostLabel { PostLabelID = 436, PostID = 150, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 437, PostID = 150, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 438, PostID = 150, LabelID = 8 });
context.PostLabels.Add(new PostLabel { PostLabelID = 439, PostID = 151, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 440, PostID = 151, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 441, PostID = 151, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 442, PostID = 151, LabelID = 8 });
context.PostLabels.Add(new PostLabel { PostLabelID = 443, PostID = 152, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 444, PostID = 152, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 445, PostID = 152, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 446, PostID = 153, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 447, PostID = 153, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 448, PostID = 153, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 449, PostID = 154, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 450, PostID = 154, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 451, PostID = 154, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 452, PostID = 155, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 453, PostID = 155, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 454, PostID = 155, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 455, PostID = 155, LabelID = 8 });
context.PostLabels.Add(new PostLabel { PostLabelID = 456, PostID = 174, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 457, PostID = 174, LabelID = 4 });
context.PostLabels.Add(new PostLabel { PostLabelID = 458, PostID = 175, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 459, PostID = 175, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 460, PostID = 175, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 461, PostID = 176, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 462, PostID = 176, LabelID = 4 });
context.PostLabels.Add(new PostLabel { PostLabelID = 463, PostID = 177, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 464, PostID = 177, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 465, PostID = 178, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 466, PostID = 178, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 467, PostID = 178, LabelID = 44 });
context.PostLabels.Add(new PostLabel { PostLabelID = 468, PostID = 179, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 469, PostID = 180, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 470, PostID = 180, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 471, PostID = 180, LabelID = 44 });
context.PostLabels.Add(new PostLabel { PostLabelID = 472, PostID = 181, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 473, PostID = 181, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 474, PostID = 181, LabelID = 45 });
context.PostLabels.Add(new PostLabel { PostLabelID = 475, PostID = 182, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 476, PostID = 182, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 477, PostID = 182, LabelID = 18 });
context.PostLabels.Add(new PostLabel { PostLabelID = 478, PostID = 183, LabelID = 44 });
context.PostLabels.Add(new PostLabel { PostLabelID = 479, PostID = 183, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 480, PostID = 184, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 481, PostID = 184, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 482, PostID = 184, LabelID = 44 });
context.PostLabels.Add(new PostLabel { PostLabelID = 483, PostID = 185, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 484, PostID = 185, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 485, PostID = 185, LabelID = 45 });
context.PostLabels.Add(new PostLabel { PostLabelID = 486, PostID = 186, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 487, PostID = 186, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 488, PostID = 186, LabelID = 45 });
context.PostLabels.Add(new PostLabel { PostLabelID = 489, PostID = 187, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 490, PostID = 187, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 491, PostID = 187, LabelID = 31 });
context.PostLabels.Add(new PostLabel { PostLabelID = 492, PostID = 188, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 493, PostID = 188, LabelID = 2 });
context.PostLabels.Add(new PostLabel { PostLabelID = 494, PostID = 189, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 495, PostID = 189, LabelID = 13 });
context.PostLabels.Add(new PostLabel { PostLabelID = 496, PostID = 189, LabelID = 14 });
context.PostLabels.Add(new PostLabel { PostLabelID = 497, PostID = 190, LabelID = 11 });
context.PostLabels.Add(new PostLabel { PostLabelID = 498, PostID = 190, LabelID = 13 });
context.PostLabels.Add(new PostLabel { PostLabelID = 499, PostID = 190, LabelID = 14 });
context.PostLabels.Add(new PostLabel { PostLabelID = 500, PostID = 191, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 501, PostID = 191, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 502, PostID = 191, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 503, PostID = 191, LabelID = 46 });
context.PostLabels.Add(new PostLabel { PostLabelID = 504, PostID = 192, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 505, PostID = 192, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 506, PostID = 192, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 507, PostID = 193, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 508, PostID = 193, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 509, PostID = 193, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 510, PostID = 194, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 511, PostID = 194, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 512, PostID = 194, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 513, PostID = 195, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 514, PostID = 195, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 515, PostID = 195, LabelID = 12 });
context.PostLabels.Add(new PostLabel { PostLabelID = 516, PostID = 196, LabelID = 1 });
context.PostLabels.Add(new PostLabel { PostLabelID = 517, PostID = 196, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 518, PostID = 196, LabelID = 7 });
context.PostLabels.Add(new PostLabel { PostLabelID = 519, PostID = 197, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 520, PostID = 197, LabelID = 47 });
context.PostLabels.Add(new PostLabel { PostLabelID = 521, PostID = 198, LabelID = 3 });
context.PostLabels.Add(new PostLabel { PostLabelID = 522, PostID = 198, LabelID = 47 });
context.SaveChanges();
}
public List<Post> GetPostPageForLabel(int pageNo, int pageSize, int blogId, string label)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
Label lbl = db.Labels.Single(l => l.Name == label);
List<int> postIds = db.PostLabels
.Where(pl => pl.LabelID == lbl.LabelID)
.Select(p => p.PostID).ToList();
return GetPostsByBlogID(blogId)
.Where(p => postIds.Contains(p.PostID))
.OrderByDescending(p => p.DateCreated)
.Skip(pageNo * pageSize)
.Take(pageSize).ToList();
}
}
public List<Label> GetLabelsByBlogId(int blogId)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
List<Post> posts = GetPostsByBlogID(blogId);
List<int> postIds = db.Posts.Where(p => p.BlogID == blogId).Select(p => p.PostID).ToList();
List<int> postLabelIds = db.PostLabels.Where(p => postIds.Contains(p.PostID)).Select(p => p.LabelID).Distinct().ToList();
return db.Labels.Where(p => postLabelIds.Contains(p.LabelID)).Include(p => p.PostLabels).ToList();
}
}
public ActionResult Edit(int id)
{
RecipesEntities db = new RecipesEntities();
Recipe recipe = db.Recipes.Include(r => r.SubCategory).Single(r => r.RecipeID == id);
recipe.Category = db.Categories.Single(r => r.CategoryID == recipe.SubCategory.CategoryID);
var allIngredients = db.Ingredients.ToList();
var categories = db.Categories.ToList();
var subCategories = db.SubCategories.Where(sc => sc.CategoryID == recipe.SubCategory.CategoryID).ToList();
foreach (RecipeIngredient ri in recipe.RecipeIngredients)
{
ri.AllIngredients = allIngredients;
}
return View(new RecipeViewModel(recipe, categories, subCategories, recipe.Category.CategoryID, recipe.SubCategoryID));
/*
Recipe recipe = repository.GetRecipeByIdWithSubCategory(id);
recipe.Category = repository.GetCategoryById(recipe.SubCategory.CategoryID);
var categories = repository.GetAllCategories();
var subCategories = repository.GetSubCategoriesByCategoryId(recipe.SubCategory.CategoryID);
List<Ingredient> allIngredients = repository.GetAllIngredients();
List<Ingredient> clone =
new List<Ingredient>(allIngredients.Count);
allIngredients.ForEach((item) => clone.Add(new Ingredient(item)));
foreach (RecipeIngredient ri in recipe.RecipeIngredients)
{
//ri.Ingredient = repository.GetIngredientById(ri.IngredientID);
ri.AllIngredients = clone;
}
return View(new RecipeViewModel(recipe, categories, subCategories, recipe.Category.CategoryID, recipe.SubCategoryID));
*/
}
public Blogger GetFirstBlogger()
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return db.Bloggers.FirstOrDefault();
}
}
public List<Blog> GetBlogsByBloggerId(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return db.Blogs.Where(b => b.BloggerID == id).ToList();
}
}
public Blogger GetBloggerByID(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return db.Bloggers.Single(b => b.BloggerID == id);
}
}
public static void PopulateBlogs(RecipesEntities context)
{
var blogs = new List<Blog> {
new Blog { BlogID = 1, BloggerID = 1, Title = "Programming Blog" },
new Blog { BlogID = 2, BloggerID = 1, Title = "Digital Biology Blog" },
};
blogs.ForEach(b => context.Blogs.Add(b));
context.SaveChanges();
var labels = new List<Label> {
new Label { LabelID = 1, Name = "CSharp", Description = "C# programming language" },
new Label { LabelID = 2, Name = "myWork", Description = "Things I do at work" },
new Label { LabelID = 3, Name = "programming", Description = "Same as software development" },
new Label { LabelID = 4, Name = "PostgreSQL", Description = "PostgreSQL database management system" },
new Label { LabelID = 5, Name = "CSS", Description = "Cascading Style Sheets" },
new Label { LabelID = 6, Name = "jQuery", Description = "jQuery" },
new Label { LabelID = 7, Name = "MVC", Description = "ASP.NET MVC" },
new Label { LabelID = 8, Name = "SEO", Description = "Search Engine Optimisation" },
new Label { LabelID = 9, Name = "Windows7", Description = "Windows 7"},
new Label { LabelID = 10, Name = "VisualStudio", Description = "Visual Studio"},
new Label { LabelID = 11, Name = "assignments", Description = "Uni of Manchester assignments"},
new Label { LabelID = 12, Name = "Bioinformatics", Description = "Bioinformatics"},
new Label { LabelID = 13, Name = "modelling", Description = "Modelling of biological processes"},
new Label { LabelID = 14, Name = "compSysBio", Description = "Computing Systems Biology"},
new Label { LabelID = 15, Name = "network", Description = "Biological networks"},
new Label { LabelID = 16, Name = "COPASI", Description = "COPASI"},
new Label { LabelID = 17, Name = "statistics", Description = "statistics"},
new Label { LabelID = 18, Name = "EnzymeKinetics", Description = "Enzyme Kinetics"},
new Label { LabelID = 19, Name = "BiNGO", Description = "BiNGO - a Cytoscape plugin"},
new Label { LabelID = 20, Name = "Cytoscape", Description = "Cytoscape"},
new Label { LabelID = 21, Name = "WPF", Description = "Windows Presentation Foundation"},
new Label { LabelID = 22, Name = "scripting", Description = "Writing Scripts"},
new Label { LabelID = 23, Name = "UnitTesting", Description = "Unit testing"},
new Label { LabelID = 24, Name = "VMWare", Description = "Unit testing"},
new Label { LabelID = 25, Name = "QML", Description = "Qt Modelling Language"},
new Label { LabelID = 26, Name = "CPP", Description = "C++"},
new Label { LabelID = 27, Name = "Alfresco", Description = "Alfresco CMS"},
new Label { LabelID = 28, Name = "useless", Description = "useless"},
new Label { LabelID = 29, Name = "TFS", Description = "Team Foundation Server"},
new Label { LabelID = 30, Name = "SVN", Description = "Subversion"},
new Label { LabelID = 31, Name = "SQL", Description = "Structured Query Language"},
new Label { LabelID = 32, Name = "GitHub", Description = "GitHub"},
new Label { LabelID = 33, Name = "MVVM", Description = "Model-View-View-Model"},
new Label { LabelID = 34, Name = "smallthings", Description = "Small things learned"},
new Label { LabelID = 35, Name = "XML", Description = "XML"},
new Label { LabelID = 36, Name = "EventLog", Description = "Event Log"},
new Label { LabelID = 37, Name = "CompactFramework", Description = "Compact Framework"},
new Label { LabelID = 38, Name = "webOS", Description = "webOS"},
new Label { LabelID = 39, Name = "SmartCards", Description = "Smart Cards"},
new Label { LabelID = 40, Name = "dll", Description = "Dynamic link library"},
new Label { LabelID = 41, Name = "embedded", Description = "embedded"},
new Label { LabelID = 42, Name = "jobSearch", Description = "Searching for a job"},
new Label { LabelID = 43, Name = "reading", Description = "books and articles"},
new Label { LabelID = 44, Name = "ROSALIND", Description = "Project ROSALIND"},
new Label { LabelID = 45, Name = "PowerShell", Description = "PowerShell Scripting"},
new Label { LabelID = 46, Name = "algorithms", Description = "Everything related to algorithms"},
new Label { LabelID = 47, Name = "Mobile", Description = "Mobile application development"}
};
labels.ForEach(b => context.Labels.Add(b));
context.SaveChanges();
}
public List<Post> GetPostsByBlogID(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
List<Post> posts;
using (RecipesEntities db = new RecipesEntities())
{
posts = db.Posts.Where(p => p.BlogID == id).Include(p => p.PostLabels).ToList();
foreach (Post post in posts)
{
foreach (PostLabel pl in post.PostLabels)
{
pl.Label.Name = db.Labels.Single(p => p.LabelID == pl.LabelID).Name;
}
}
return posts;
}
}
public Post GetPostByID(int id)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
Post post = db.Posts.Single(p => p.PostID == id);
post.PostLabels = db.PostLabels.Where(p => p.PostID == post.PostID).ToList();
foreach (var postLabel in post.PostLabels)
{
postLabel.Label = db.Labels.Single(l => l.LabelID == postLabel.LabelID);
}
return post;
}
}
public List<PostLabel> GetAllPostLabels()
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return db.PostLabels.ToList();
}
}
public List<Post> GetPostPage(int pageNo, int pageSize, int blogId)
{
methodName = MethodBase.GetCurrentMethod().Name;
using (RecipesEntities db = new RecipesEntities())
{
return GetPostsByBlogID(blogId)
.OrderByDescending(p => p.DateCreated)
.Skip(pageNo * pageSize)
.Take(pageSize).ToList();
}
}
private static void SaveLogEntry(LogEntry entry)
{
using (RecipesEntities context = new RecipesEntities())
{
context.LogEntries.Add(entry);
context.SaveChanges();
}
}
