private static void AddBookmark(string username, string title, string url, string tags, string notes)
{
var b = new Bookmark();
var user = SessionState.db.Users.FirstOrDefault(u => u.Username == username);
if (user == null)
{
user = new User();
user.Username = username;
SessionState.db.Users.Add(user);
}
b.User = user;
b.Title = title;
//b.Title.Split(' ').ToList().ForEach(t =>
//{
// ParseTags(t.Trim(), b);
//});
b.URL = url;
//tags
if (!string.IsNullOrEmpty(tags))
{
tags.Split(',').ToList().ForEach(t =>
{
ParseTags(t.Trim(), b);
});
}
b.Notes = notes;
SessionState.db.Bookmarks.Add(b);
SessionState.db.SaveChanges();
}
private static void ParseTags(string t, Bookmark b)
{
var tag = SessionState.db.Tags.FirstOrDefault(x => x.Name == t);
if (tag == null)
{
tag = new Tag();
tag.Name = t.ToLower();
SessionState.db.Tags.Add(tag);
}
b.Tags.Add(tag);
SessionState.db.SaveChanges();
}
private static void InsertUsers(int count)
{
Random r = new Random();
Stopwatch stopwatch = new Stopwatch();
List<Tag> tags = new List<Tag>();
for (int i = 0; i < 10000; i++)
{
tags.Add(new Tag()
{
Name = "tag" + i
});
}
stopwatch.Start();
SessionState.db.Database.BulkInsert("Tags", tags);
stopwatch.Stop();
Console.WriteLine("10k Tags Inserted for: {0}", stopwatch.Elapsed);
tags.Clear();
tags.AddRange(SessionState.db.Tags.ToList());
List<Bookmark> bookmarks = new List<Bookmark>();
List<User> users = new List<User>();
for (int i = 0; i < count; i++)
{
User user = new User();
user.Username = "******" + i;
users.Add(user);
}
stopwatch.Start();
SessionState.db.Database.BulkInsert("Users", users);
stopwatch.Stop();
Console.WriteLine("30k Users Inserted for: {0}", stopwatch.Elapsed);
users.Clear();
users.AddRange(SessionState.db.Users.ToList());
users.ForEach(user =>
{
for (int i = 0; i < 7; i++)
{
Bookmark bookmark = new Bookmark();
bookmark.Title = "title" + i;
bookmark.URL = "http://www.google.com/" + i;
bookmark.UserId = user.UserId;
bookmarks.Add(bookmark);
}
});
stopwatch.Start();
SessionState.db.Database.BulkInsert("Bookmarks", bookmarks);
stopwatch.Stop();
Console.WriteLine("210k bookmarks Inserted for: {0}", stopwatch.Elapsed);
bookmarks.Clear();
bookmarks.AddRange(SessionState.db.Bookmarks.ToList());
List<BookmarksInTags> bookmarksInTagses = new List<BookmarksInTags>();
bookmarks.ForEach(bookmark =>
{
for (int k = 0; k < 10; k++)
{
bookmarksInTagses.Add(new BookmarksInTags()
{
BookmarkId = bookmark.BookmarkId,
TagId = tags[k].TagId
});
}
});
stopwatch.Start();
SessionState.db.Database.BulkInsert("BookmarksInTags", bookmarksInTagses);
stopwatch.Stop();
Console.WriteLine("2100k bookmarksInTagses Inserted for: {0}", stopwatch.Elapsed);
}
private static void ParseTags(string t, Bookmark b)
{
var tag = SessionState.db.Tags.FirstOrDefault(x => x.Name == t);
if (tag == null)
{
tag = new Tag();
tag.Name = t.ToLower();
SessionState.db.Tags.Add(tag);
}
b.Tags.Add(tag);
SessionState.db.SaveChanges();
}
private static void AddBookmark(string username, string title, string url, string tags, string notes)
{
var b = new Bookmark();
var user = SessionState.db.Users.FirstOrDefault(u => u.Username == username);
if (user == null)
{
user = new User();
user.Username = username;
SessionState.db.Users.Add(user);
}
b.User = user;
b.Title = title;
//b.Title.Split(' ').ToList().ForEach(t =>
//{
// ParseTags(t.Trim(), b);
//});
b.URL = url;
//tags
if (!string.IsNullOrEmpty(tags))
{
tags.Split(',').ToList().ForEach(t =>
{
ParseTags(t.Trim(), b);
});
}
b.Notes = notes;
SessionState.db.Bookmarks.Add(b);
SessionState.db.SaveChanges();
}
