public void SaveNote(Note note)
{
using (var db = new AnkiEntities(_connectionString))
{
////db.Database.Connection.
var tempNote = db.notes.Where(n => n.id == note.Id).First();
if (tempNote == null)
{
tempNote = new note();
}
tempNote.flds = string.Join('\u001f'.ToString(), new string[] { note.Front, note.Back, note.Details });
db.SaveChanges();
}
}
public IEnumerable <Note> GetAllVerbs()
{
using (var db = new AnkiEntities(_connectionString))
{
var verbs = db.notes.Where(n => n.tags.Contains("verbos")).OrderByDescending(v => v.id).Select(v => v);
var single = verbs.First();
var result = db.notes.Where(n => n.tags.Contains("verbos"));
var count = result.Count();
count = result.Where(n => n.tags.Contains("verbos")).Count();
var list = result.Where(n => n.tags.Contains("verbos")).ToList();
return(db.notes.Where(n => n.tags.Contains("verbos")).ToList().Select(n =>
{
return MapNote(n);
}
));
}
}