private static void SetupDatabase() {
var d = new Dashing.Engine.Dialects.SqlServerDialect();
var dtw = new DropTableWriter(d);
var ctw = new CreateTableWriter(d);
var dropTables = dashingConfig.Maps.Select(dtw.DropTableIfExists);
var createTables = dashingConfig.Maps.Select(ctw.CreateTable);
var sqls = dropTables.Concat(createTables).ToArray();
using (var setupSession = dashingConfig.BeginSession()) {
foreach (var sql in sqls) {
setupSession.Dapper.Execute(sql);
}
var r = new Random();
var users = new List<User>();
for (var i = 0; i < 100; i++) {
var user = new User();
users.Add(user);
setupSession.Insert(user);
}
var blogs = new List<Blog>();
for (var i = 0; i < 100; i++) {
var blog = new Blog();
blogs.Add(blog);
setupSession.Insert(blog);
}
var posts = new List<Post>();
for (var i = 0; i <= 500; i++) {
var userId = r.Next(100);
var blogId = r.Next(100);
var post = new Post { Author = users[userId], Blog = blogs[blogId], Title = Guid.NewGuid().ToString("N") };
setupSession.Insert(post);
posts.Add(post);
}
for (var i = 0; i < 5000; i++) {
var comment = new Comment { Post = posts[r.Next(500)], User = users[r.Next(100)] };
setupSession.Insert(comment);
}
var tags = new List<Tag>();
for (var i = 0; i < 100; i++) {
var tag = new Tag { Content = "Tag" + i };
tags.Add(tag);
setupSession.Insert(tag);
}
for (var i = 0; i < 5000; i++) {
var postTag = new PostTag { Post = posts[r.Next(500)], Tag = tags[r.Next(100)] };
setupSession.Insert(postTag);
}
setupSession.Complete();
}
}
private static void SetupDatabase()
{
var d = new Dashing.Engine.Dialects.SqlServerDialect();
var dtw = new DropTableWriter(d);
var ctw = new CreateTableWriter(d);
var dropTables = dashingConfig.Maps.Select(dtw.DropTableIfExists);
var createTables = dashingConfig.Maps.Select(ctw.CreateTable);
var sqls = dropTables.Concat(createTables).ToArray();
using (var setupSession = dashingConfig.BeginSession()) {
foreach (var sql in sqls)
{
setupSession.Dapper.Execute(sql);
}
var r = new Random();
var users = new List <User>();
for (var i = 0; i < 100; i++)
{
var user = new User();
users.Add(user);
setupSession.Insert(user);
}
var blogs = new List <Blog>();
for (var i = 0; i < 100; i++)
{
var blog = new Blog();
blogs.Add(blog);
setupSession.Insert(blog);
}
var posts = new List <Post>();
for (var i = 0; i <= 500; i++)
{
var userId = r.Next(100);
var blogId = r.Next(100);
var post = new Post {
Author = users[userId], Blog = blogs[blogId], Title = Guid.NewGuid().ToString("N")
};
setupSession.Insert(post);
posts.Add(post);
}
for (var i = 0; i < 5000; i++)
{
var comment = new Comment {
Post = posts[r.Next(500)], User = users[r.Next(100)]
};
setupSession.Insert(comment);
}
var tags = new List <Tag>();
for (var i = 0; i < 100; i++)
{
var tag = new Tag {
Content = "Tag" + i
};
tags.Add(tag);
setupSession.Insert(tag);
}
for (var i = 0; i < 5000; i++)
{
var postTag = new PostTag {
Post = posts[r.Next(500)], Tag = tags[r.Next(100)]
};
setupSession.Insert(postTag);
}
setupSession.Complete();
}
}
