Esempio n. 1
0
        /// <summary>
        /// 是否存在记录
        /// </summary>
        /// <param name="context">上下文</param>
        /// <returns></returns>
        public bool Exists(QueryDescriptor <T> context)
        {
            Sql s = Sql.Builder.Append("SELECT TOP 1 1 AS result FROM [" + MetaData.TableInfo.TableName + "] ")
                    .Append(PocoHelper.GetConditions(context));
            ExecuteContext <T> ctx = new ExecuteContext <T>(s);
            var result             = _repository.Exists(ctx);

            return(result);
        }
Esempio n. 2
0
        /// <summary>
        /// 删除记录
        /// </summary>
        /// <param name="predicate">过滤条件</param>
        /// <returns></returns>
        public bool Delete(Expression <Func <T, bool> > predicate)
        {
            QueryDescriptor <T> q = QueryDescriptorBuilder.Build <T>();

            q.Where(predicate);
            Sql s = Sql.Builder.Append("DELETE [" + MetaData.TableInfo.TableName + "] ")
                    .Append(PocoHelper.GetConditions(q.QueryText, q.Parameters));
            ExecuteContext <T> ctx = new ExecuteContext <T>(s);
            var result             = _repository.DeleteByQuery(ctx);

            return(result);
        }