public virtual T Create(T entity) { using (connection) { string query = EntityToSqlUtil.GetInsertQuery(entity); entity.Id = connection.QueryFirst <int>(query, entity); connection.Close(); } return(entity); }
public virtual IEnumerable <T> List(BaseFilter filter) { string sql = EntityToSqlUtil.GetSelectAllQuery <T>(filter.IncludeBase64Field); IEnumerable <T> result; using (connection) { connection.Open(); result = connection.Query <T>(sql, new { filter }); connection.Close(); } return(result); }
public virtual T GetById(int id) { string query = EntityToSqlUtil.GetSelectByIdQuery <T>(); T result; using (connection) { connection.Open(); result = connection.QueryFirstOrDefault <T>(query, new { Id = id }); connection.Close(); } return(result); }
public virtual bool Delete(T entity) { string query = EntityToSqlUtil.GetDeleteQuery <T>(); int affected = 0; using (connection) { connection.Open(); affected = connection.Execute(query, entity); connection.Close(); } return(affected > 0); }