public Task <int> InsertGlossaryItem(GlossaryItemModel item)
{
string sql = @$ "INSERT INTO glossary (term, definition)
SELECT @Term, @Definition
WHERE
NOT EXISTS (
SELECT term FROM glossary WHERE term = @Term
);";
return(_db.SaveData(sql, item));
}
public Task <int> InsertReference(ReferenceModel reference)
{
string sql = @$ "INSERT INTO reference (title, link, description, category)
SELECT @Title, @Link, @Description, @Category ;";
return(_db.SaveData(sql, reference));
}