public void CreateDatabaseWithTestData() { MBlogRepositoryDataContext dataContext = new MBlogRepositoryDataContext(); //Delete database if it already exists if (dataContext.DatabaseExists()) { dataContext.DeleteDatabase(); } //Create the database dataContext.CreateDatabase(); //Populate the database with some fake data dataContext.Posts.InsertAllOnSubmit( new[]{ new Post{ Title = "First Post", Content = "This is the first blog post, and it's very short", Author = "Khaja Minhajuddin", Timestamp = DateTime.Now }, new Post{ Title = "MBlog set to conquer the world", Content = "Now that, was supposed to be an April Fool's joke ;)", Author = "Khaja Minhajuddin", Timestamp = DateTime.Now }, new Post{ Title = "MBlog the latest blogging framework written using ASP.NET MVC", Content = "This has been a great year for the MBlog application, it has been getting some good reviews!", Author = "Khaja Minhajuddin", Timestamp = DateTime.Now } }); dataContext.SubmitChanges(); }
public PostRepository() { _db = new MBlogRepositoryDataContext(MBlogConfiguration.ConnectionString); }