public override void InitializeDatabase(WcfTest3Entities context)
{
context.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction
, string.Format("ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE", context.Database.Connection.Database));
base.InitializeDatabase(context);
}
protected override void Seed(WcfTest3Entities context)
{
base.Seed(context);
// Create a role.
if (!context.Roles.Any(r => r.Name == "Mod"))
{
var store = new RoleStore <IdentityRole>(context);
var manager = new RoleManager <IdentityRole>(store);
var role = new IdentityRole {
Name = "Mod"
};
manager.Create(role);
context.SaveChanges();
}
// Create a user.
if (!context.Users.Any(u => u.UserName == "default"))
{
var store = new UserStore <IdentityUser>(context);
var manager = new UserManager <IdentityUser>(store);
var user = new IdentityUser {
UserName = "******"
};
manager.Create(user, "123456");
manager.AddToRole(user.Id, "Mod");
context.SaveChanges();
}
var categories = new List <Category>
{
new Category {
Name = "Shipment", Description = "Posts about shipment issues"
},
new Category {
Name = "Internal", Description = "Internal mod issues"
},
new Category {
Name = "Stock", Description = "Posts about stock statuses"
},
new Category {
Name = "Transfer", Description = "Posts about transfer statuses"
}
};
categories.ForEach(c => context.Categories.Add(c));
context.SaveChanges();
var posts = new List <Post>
{
new Post {
SentBy = "User1", Body = "Post content", SentAt = DateTime.Now, Subject = "A subject on the board"
},
new Post {
SentBy = "User2", Body = "An another post content", SentAt = DateTime.Now, Subject = "An another subject on the board"
},
new Post {
SentBy = "User3", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
},
new Post {
SentBy = "User4", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
},
new Post {
SentBy = "User5", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
},
new Post {
SentBy = "User6", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
},
new Post {
SentBy = "User7", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
},
new Post {
SentBy = "User8", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
},
new Post {
SentBy = "User9", Body = "Another one", SentAt = DateTime.Now, Subject = "Another one subject on the board"
}
};
var random = new Random();
posts.ForEach(p =>
{
var randomId = random.Next(1, 4);
var category = context.Categories.Single(c => c.Id == randomId);
p.Category = category;
p.CategoryId = category.Id;
context.Posts.Add(p);
});
context.SaveChanges();
var comments = new List <Comment>
{
new Comment {
SentBy = "User", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User2", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User3", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User4", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User5", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User6", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User7", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User8", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User9", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User10", Body = "Just a comment", SentAt = DateTime.Now
},
new Comment {
SentBy = "User11", Body = "Just a comment", SentAt = DateTime.Now
}
};
comments.ForEach(c =>
{
var randomId = random.Next(1, 9);
var post = context.Posts.Single(p => p.Id == randomId);
c.Post = post;
c.PostId = post.Id;
context.Comments.Add(c);
});
context.SaveChanges();
}