public static string LoadQuery(this Query query, Guid userId, string tag)
{
using (var db = new O2DataMart())
{
return(db.Queries.Where(q => q.UserId == userId && q.Tag == tag).Select(q => q.Text).FirstOrDefault());
}
}
public static void SaveQuery(this Query query, Guid userId, string tag, string text)
{
using (var db = new O2DataMart())
{
var qry = db.Queries.FirstOrDefault(q => q.Tag == tag && q.UserId == userId);
if (qry == null)
{
db.Queries.Add(new Models.EFModel.Query {
QueryId = Guid.NewGuid(), UserId = userId, Tag = tag, Text = text
});
}
else
{
qry.Text = text;
}
db.SaveChanges();
}
}
