private bool CheckInDB(byte[] blob, string path, out Result info) { info = null; using (var db = new ResultContext()) { var query = db.Results.Where(a => a.Path == path); if (query.Count() == 0) { return(false); } foreach (var result in query) { info = new Result { Label = result.Label, Confidence = result.Confidence, Path = result.Path, Blob = new ImageData { Data = blob } }; if (result.Blob.Data.Length != blob.Length) { return(false); } for (int i = 0; i < blob.Length; ++i) { if (blob[i] != result.Blob.Data[i]) { return(false); } } } return(true); } }
private void Postprocess(Result result) { counter += 1; using (var db = new ResultContext()) { Console.WriteLine("Added new entity"); db.Add(result); db.SaveChanges(); } }
public void ClearDatabase() { this.Stop(); Console.WriteLine("Clearing database"); using (var db = new ResultContext()) { foreach (var result in db.Results) { db.Remove(result); } db.SaveChanges(); } }
public string DatabaseStats() { string ret = ""; using (var db = new ResultContext()) { foreach (var classLabel in LabelClass.Labels) { int count = db.Results.Count(a => a.Label == classLabel); if (count > 0) { ret += $"{classLabel}: {count}\r\n"; } } return(ret); } }