static void Main(string[] args)
{
var timer = new Stopwatch();
int numberOfRabbitsToCreate = 1000;
for (int i = 0; i < numberOfRabbitsToCreate; i++)
{
using (var db = new RabbitDbEntities())
{
var newRabbit = new Rabbit();
db.Rabbits.Add(newRabbit);
db.SaveChanges();
}
}
//timer.Stop();
//Console.WriteLine("1 read took: " + timer.ElapsedMilliseconds);
// one read
timer.Start();
using (var db = new RabbitDbEntities())
{
rabbits = db.Rabbits.ToList();
}
timer.Stop();
Console.WriteLine("1 Read took: " + timer.ElapsedMilliseconds + "Milliseconds");
timer.Restart();
// 1000 reads
for (int i = 0; i < numberOfRabbitsToCreate; i++)
{
using (var db = new RabbitDbEntities())
{
Rabbit newRabbit = db.Rabbits.Find(i + 1);
//Rabbit newRabbit = db.Rabbits.ToList()[i];
rabbits.Add(newRabbit);
}
}
timer.Stop();
Console.WriteLine("1000 reads took: " + timer.ElapsedMilliseconds);
// REPORT TIMES TO CONSOLE
// REPORT TIMES TO CSV
File.WriteAllText("Rabbits.csv", "ID,Name,Age");
File.AppendAllText("Rabbits.csv", "\n1,Billy,12");
File.AppendAllText("Rabbits.csv", "\n2,Fluffy,13");
Process.Start("Rabbits.csv");
Console.ReadKey();
// REPORT TIMES TO WORD
// SPRINT 2: move everything to WPF
}
static void AddBunnies()
{
var newRabbit = new Rabbit()
{
Age = 0,
RabbitName = $"Rabbit whatever"
};
using (var db = new RabbitDbEntities())
{
db.Rabbits.Add(newRabbit);
db.SaveChanges();
}
}
public void PopRabbitDb1(int numberOfRabbits)
{
Random rand = new Random();
using (var db = new RabbitDbEntities())
{
for (int i = 0; i < numberOfRabbits; i++)
{
Rabbit rb = new Rabbit();
rb.Age = rand.Next(21);
rb.Name = $"Jeff{i}";
db.Rabbits.Add(rb);
db.SaveChanges();
}
}
}
