static void Main(string[] args)
{
Context db = new Context();
Console.WriteLine(db.Database.CanConnect());
NewContext db2 = new NewContext();
Messurement current = new Messurement();
Stopwatch watch = new Stopwatch();
watch.Start();
List <User> users2 = db.Users.Include("Contents.Entries").Include("Contents").Include("Contents").ToList();
List <User> user3 = db2.Users.ToList();
db2.Users.RemoveRange(user3.Take(2));
db2.SaveChanges();
db.Users.RemoveRange(db.Users.Skip(40));
db.SaveChanges();
List <User> users = db.Users.Include(x => x.Contents).ThenInclude(x => x.Entries).Include(x => x.Settings).ToList(); //db.Users.Include(x => x.Contents).Include(x => x.Settings).ToList();
List <Content> contents = db.Contents.Include(x => x.User).ToList();
watch.Stop();
current.TimeRead = watch.Elapsed;
current.EntryCount = users.Count + contents.Count;
Console.WriteLine((users.Count + contents.Count) + " Werte in " + watch.ElapsedMilliseconds + " ms gelesen");
watch.Restart();
User us = new User()
{
Name = "Morris Janatzek",
Username = "",
Type = User.UserType.Manager,
Test = 2
};
db.Users.Add(us);
User us3 = new User()
{
Name = "Morris Janatzek",
Username = ""
};
db2.Users.Add(us3);
db2.SaveChanges();
db.SaveChanges();
db.Users.Remove(db.Users.FirstOrDefault());
db.SaveChanges();
Content c = new Content()
{
Text = "Test",
UserId = us.Id
};
db.Contents.Add(c);
db.ContentEntries.Add(new ContentEntry()
{
Text = "das ist in set",
ContentId = c.Id
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test"
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test 2"
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test 3"
});
db.SaveChanges();
watch.Stop();
current.TimeWrite = watch.Elapsed;
Console.WriteLine("Werte in " + watch.ElapsedMilliseconds + " ms geschrieben");
db.Messurements.Add(current);
db.SaveChanges();
db.Generics.Add(new GenericTest <int>()
{
Value = 1
});
db.Generics.Add(new GenericTest <int>()
{
Value = 2
});
db.SaveChanges();
Console.WriteLine(db.Generics.Count());
while (true)
{
string result = Console.ReadLine();
if (result != "q")
{
db.Users.Add(new User()
{
Username = "******",
Name = "Test User"
});
db.SaveChanges();
continue;
}
break;
}
Context db3 = new Context();
Context db4 = new Context();
List <User> users3 = db3.Users.ToList();
db4.Users.Add(new User()
{
Name = "Morris Janatzek",
Username = "******"
});
db4.SaveChanges();
users3 = db3.Users.ToList();
Console.WriteLine(db.Users.Count());
db.Users.Add(new User()
{
Name = "Test",
Username = "******"
});
db.SaveChanges();
Console.WriteLine(db.Users.Count());
Console.ReadKey();
}
public static void Main(string[] args)
{
Context db = new Context();
Messurement current = new Messurement();
Stopwatch watch = new Stopwatch();
watch.Start();
List <User> users = db.Users.ToList(); //db.Users.Include(x => x.Contents).Include(x => x.Settings).ToList();
List <Content> contents = db.Contents.Include(x => x.User).ToList();
watch.Stop();
current.TimeRead = watch.Elapsed;
current.EntryCount = users.Count + contents.Count;
Console.WriteLine((users.Count + contents.Count) + " Werte in " + watch.ElapsedMilliseconds + " ms gelesen");
watch.Restart();
User us = new User()
{
Name = "Morris Janatzek",
Username = "******"
};
db.Users.Add(us);
//db.Users.Remove(db.Users.FirstOrDefault());
db.SaveChanges();
db.Contents.Add(new Content()
{
Text = "Test",
UserId = us.Id
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test"
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test 2"
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test 3"
});
db.SaveChanges();
watch.Stop();
current.TimeWrite = watch.Elapsed;
Console.WriteLine("Werte in " + watch.ElapsedMilliseconds + " ms geschrieben");
db.Messurements.Add(current);
db.SaveChanges();
while (true)
{
string result = Console.ReadLine();
if (result != "q")
{
db.Users.Add(new User()
{
Username = "******",
Name = "Test User"
});
db.SaveChanges();
continue;
}
break;
}
}
