/// <summary> /// 根据条件删除 /// </summary> /// <param name="keys">键值集合</param> public virtual bool Delete(PropertyParamGroup paramGroup) { List <SqlParameter> pars = paramGroup.GetParams(); string sql = string.Format("DELETE FROM [{0}] WHERE {1}", EntitySet.GetType().Name, paramGroup.ToString()); SqlParameter[] paras = pars == null ? null : pars.ToArray(); return(Entities.Database.ExecuteSqlCommand(sql, paras) > 0); }
/// <summary> /// 根据属性键值对查询对象集合 /// </summary> /// <param name="paramGroup">属性键值对</param> /// <returns></returns> public virtual List <TEntity> Get(PropertyParamGroup paramGroup) { List <SqlParameter> paras = paramGroup.GetParams(); SqlParameter[] pars = paras == null ? new SqlParameter[0] : paras.ToArray(); string sql = string.Format("SELECT * FROM [{0}] WHERE {1}", EntitySet.GetType().Name, paramGroup.ToString()); return(Entities.Database.SqlQuery <TEntity>(sql, pars).ToList()); }