static void Main(string[] args)
{
int numberOfRabbits = 1000;
Random rand = new Random();
Stopwatch sw = new Stopwatch();
//stopwatch
//one read
//Console.WriteLine($"Time taken for one read {sw.Elapsed}");
//sw.Stop();
//sw.Reset();
//1000 seperate reads
//Console.WriteLine($"Time taken for 1000 reads {sw.Elapsed}");
//sw.Stop();
using (var db = new RabbitDbEntities())
{
sw.Start();
foreach (Rabbit rabbit in db.Rabbits.ToList())
{
Console.WriteLine(rabbit.RabbitID);
}
}
var OneTime = sw.Elapsed.ToString();
sw.Stop();
sw.Reset();
for (int i = 1; i <= numberOfRabbits; i++)
{
sw.Start();
using (var db = new RabbitDbEntities())
{
Console.WriteLine(db.Rabbits.Find(i).RabbitID);
}
}
var ThousandTimes = sw.Elapsed.ToString();
sw.Stop();
Console.WriteLine($"Time taken for 1 read {OneTime}");
Console.WriteLine($"Time taken for 1000 reads {ThousandTimes}");
Console.ReadLine();
//report times to console DONE
//report times to CSV
File.WriteAllText("RabbitOutput.CSV", "//log of new rabbit");
File.AppendAllText("RabbitOutput.CSV", $"\n1,Billy,12");
File.AppendAllText("RabbitOutput.CSV", $"\n2,Fluffy,13");
Process.Start("RabbitOutput.CSV");
//report times to Word
//do that in wpf
}
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();
}
}
}
static void Main(string[] args)
{
//stopwatch
var s = new Stopwatch();
s.Start();
int numberOfRabbitsToCreate = 1003;
//one read
//using (var db = new RabbitDbEntities())
//{
// rabbits = db.Rabbits.ToList();
//}
rabbits = new List <Rabbit>();
for (int i = 0; i < numberOfRabbitsToCreate; i++)
{
using (var db = new RabbitDbEntities())
{
//AddBunnies();
db.Rabbits.ToList();
var rabbit = (Rabbit)db.Rabbits.Find(i + 1);
rabbits.Add(rabbit);
}
}
PrintRabbits();
s.Stop();
Console.WriteLine(s.Elapsed + " seconds");
//Console.WriteLine(s.ElapsedMilliseconds + " milliseconds");
//report times to console
//report times to CSV
File.WriteAllText("RabbitOutPut.csv", "Id,Name,Age");
File.AppendAllText("RabbitOutPut.csv", "\n1,Billy,12"); //or do Environment.Newline
File.AppendAllText("RabbitOutPut.csv", "\n2,Fluffy,13");
Process.Start("RabbitOutput.csv");
//report times to Word
//sprint 2: move everything to WPF
}
static void Main(string[] args)
{
int numberOfRabbitsToCreate = 1000;
// stopwatch
// one read
using (var db = new RabbitDbEntities()) { }
// 1000 reads
for (int i = 0; i < numberOfRabbitsToCreate; i++)
{
using (var db = new RabbitDbEntities())
{
}
}
// report times to console
// report times to CSV
File.WriteAllText("RabbitOutput.csv", "ID,Name,Age");
File.AppendAllText("RabbitOutput.csv", "\n1,Billy,12"); // Environment.NewLine
File.AppendAllText("RabbitOutput.csv", "\n2,Fluffy,13");
Process.Start("RabbitOutput.csv");
// report times to Word
// Sprint 2 : move everything to WPF!!!
}
static void Main(string[] args)
{
int noOfRabbitsToCreate = 1000;
Stopwatch stopwatch = new Stopwatch();
String firstTimeElapsed, secondTimeElapsed;
//for (int i = 1; i <= noOfRabbitsToCreate; i++)
//{
// using (var db = new RabbitDbEntities())
// {
// var rabbit = new Rabbit();
// db.Rabbits.Add(rabbit);
// db.SaveChanges();
// }
//}
//using (var db = new RabbitDbEntities())
//{
// for (int i = 1; i <= noOfRabbitsToCreate; i++)
// {
// var rabbit = new Rabbit();
// db.Rabbits.Add(rabbit);
// db.SaveChanges();
// }
//}
stopwatch.Start();
using (var db = new RabbitDbEntities())
{
for (int i = 1; i <= noOfRabbitsToCreate; i++)
{
Console.WriteLine(db.Rabbits.Find(i).RabbitID);
}
}
firstTimeElapsed = stopwatch.Elapsed.ToString();
stopwatch.Stop();
stopwatch.Reset();
stopwatch.Start();
using (var db = new RabbitDbEntities())
{
foreach (var rabbit in db.Rabbits.ToList())
{
Console.WriteLine(rabbit.RabbitID);
}
}
firstTimeElapsed = stopwatch.Elapsed.ToString();
stopwatch.Stop();
stopwatch.Reset();
stopwatch.Start();
for (int i = 1; i <= noOfRabbitsToCreate; i++)
{
using (var db = new RabbitDbEntities())
{
Console.WriteLine(db.Rabbits.Find(i).RabbitID);
}
}
secondTimeElapsed = stopwatch.Elapsed.ToString();
stopwatch.Stop();
stopwatch.Reset();
File.WriteAllText("rabbits.csv", "ID,Name,Age");
File.AppendAllText("rabbits.csv", "\n1, Billy, 12");
File.AppendAllText("rabbits.csv", "\n2, Bob, 9");
Process.Start("rabbits.csv");
//Console.WriteLine($"1 read time elapsed = {firstTimeElapsed}");
//Console.WriteLine($"1000 read time elapsed = {secondTimeElapsed}");
Console.ReadLine();
}
