public TheCategoryEntity GetById(int id)
{
string sql = "select category_id as CategoryId, category_name as CategoryName from category where Id = ?";
using (var sqliteConn = connectionProvider.GetConnection())
{
return(sqliteConn.QueryFirstOrDefault <TheCategoryEntity>(sql, new { Id = id }));
}
}
public void Create(FavoriteEntity entity)
{
string sql = "insert into favorite(host, title, category_id) values (@Host, @Title, @CategoryId);";
using (var sqliteConn = connectionProvider.GetConnection())
{
sqliteConn.Execute(sql, new { Host = entity.Host, Title = entity.Title, CategoryId = entity.CategoryId });
}
}
public void Create(CategoryEntity entity)
{
string sql = "insert into category(category_id, category_name, description) values (@CategoryId, @CategoryName, @Description);";
using (var sqliteConn = connectionProvider.GetConnection())
{
sqliteConn.Execute(sql, new { CategoryId = entity.CategoryId, CategoryName = entity.CategoryName, Description = entity.Description });
}
}