public override List <TResult> QueryResult <TResult>(LambdaQuery.LambdaQueryBase query, NewExpression newExpression) { throw new NotSupportedException("MongoDB暂未实现此方法"); }
public override List <dynamic> QueryDynamic(LambdaQuery.LambdaQueryBase query) { throw new NotSupportedException("MongoDB暂未实现此方法"); }
/// <summary> /// 获取关联删除语句 /// </summary> /// <param name="t1"></param> /// <param name="t2"></param> /// <param name="condition"></param> /// <returns></returns> public virtual string GetRelationDeleteSql(string t1, string t2, string condition, LambdaQuery.LambdaQueryBase query) { string table = string.Format("{0} t1", KeyWordFormat(t1), KeyWordFormat(t2)); string sql = string.Format("delete t1 from {0} {1}", table, condition); return(sql); }
/// <summary> /// 获取关联更新语名 /// </summary> /// <param name="t1"></param> /// <param name="t2"></param> /// <param name="condition"></param> /// <param name="setValue"></param> /// <returns></returns> public virtual string GetRelationUpdateSql(string t1, string t2, string condition, string setValue, LambdaQuery.LambdaQueryBase query) { string table = string.Format("{0} t1", KeyWordFormat(t1), KeyWordFormat(t2)); string sql = string.Format("update t1 set {0} from {1} {2}", setValue, table, condition); return(sql); }
public override string GetRelationUpdateSql(string t1, string t2, string condition, string setValue, LambdaQuery.LambdaQueryBase query) { //update table1,table2, set a=1 where table1.id=table2.id and id>2 string table = string.Format("{0} t1,{1} t2", KeyWordFormat(t1), KeyWordFormat(t2)); var where = query.__Relations.First().Value.condition; if (query.Condition.Length > 0) { where += string.Format(" and {0}", query.Condition); } string sql = string.Format(@"UPDATE {0} SET {1} where {2}", table, setValue, where); return(sql); }
//public override List<TResult2> QueryDynamic<TModel, TResult, TResult2>(LambdaQuery<TModel> query, Expression<Func<TModel, TResult, TResult2>> resultSelector) //{ // throw new NotImplementedException(); //} public override List <TResult> QueryResult <TResult>(LambdaQuery.LambdaQueryBase query, NewExpression newExpression) { throw new NotImplementedException(); }