public bool writeToDB()
{
Console.WriteLine("\n\nWriting to database...");
if (this.convertArrayToString())
{
using (var db = new SnailContext())
{
db.Snails.Add(this);
db.SaveChanges();
Console.WriteLine("The result was written successfully!");
return(true);
}
}
else
{
Console.WriteLine("Array is empty!");
return(false);
}
}
public static List <SnailMatrix> readFromDB()
{
Console.WriteLine("Reading from database...");
using (var db = new SnailContext())
{
var prevSnails = db.Snails.OrderByDescending(c => c.Id).ToList();
int counter = 0;
if (prevSnails.Any(o => o.Id != null))
{
foreach (var elem in prevSnails)
{
if (counter++ >= 5)
{
break;
}
Console.WriteLine("result #" + elem.Id + ": " + elem.snailedArrayString);
}
}
else
{
SnailMatrix[] sm = new SnailMatrix[3];
for (int i = 0; i < sm.Length; i++)
{
sm[i] = new SnailMatrix();
sm[i].snailedArrayString = "test string for first load";
}
db.Snails.AddRange(sm);
db.SaveChanges();
Console.WriteLine("Database is empty!");
}
Console.WriteLine();
return(prevSnails);
}
//return false;//for future
}