1 write to sql
System.Data.Linq (1)
SqlClient\Query\QueryConverter.cs (1)
82this.sql = sql;
106 references to sql
System.Data.Linq (106)
SqlClient\Query\QueryConverter.cs (106)
351return this.sql.ValueFromObject(invokeResult, invoke.Type, true, this.dominatingExpression); 360return sql.MethodCall(invoke.Type, typeof(Delegate).GetMethod("DynamicInvoke"), expr, new SqlExpression[] {sca}, this.dominatingExpression); 406SqlSubSelect ms = sql.SubSelect(SqlNodeType.Multiset, select, exp.Type); 422return new SqlSelect(sql.SubSelect(SqlNodeType.Multiset, pselect, selector.Body.Type), alias, this.dominatingExpression); 434sql.Unary( 436sql.Value(typeof(int?), this.typeProvider.From(typeof(int)), 1, false, this.dominatingExpression) 439sql.Unary(SqlNodeType.OuterJoinedValue, inner.Selection) 443inner.Selection = sql.Unary(SqlNodeType.OuterJoinedValue, inner.Selection); 501SqlExpression condition = sql.Binary(SqlNodeType.EQ, outerKey, innerKey); 530SqlExpression pred = sql.Binary(SqlNodeType.EQ, outerKey, innerKey); 533SqlSubSelect subquery = sql.SubSelect(SqlNodeType.Multiset, select); 551sql.Unary(SqlNodeType.OuterJoinedValue, 552sql.Value(typeof(int?), this.typeProvider.From(typeof(int)), 1, false, this.dominatingExpression) 555sql.Unary(SqlNodeType.OuterJoinedValue, aliasRef) 562SqlExpression litNull = sql.TypedLiteralNull(typeof(string), this.dominatingExpression); 584select.Where = sql.AndAccumulate(select.Where, 585sql.Unary(SqlNodeType.IsNotNull, aref, this.dominatingExpression) 620result = sql.Unary(SqlNodeType.IsNotNull, new SqlUnary(SqlNodeType.Treat, ofType, typeProvider.From(ofType), expr, this.dominatingExpression), this.dominatingExpression); 644SqlSubSelect ms = sql.SubSelect(SqlNodeType.Multiset, select); 654return sql.CLRLENGTH(exp); 657return sql.DATALENGTH(exp); 670b.Type, sql.TypeProvider.From(b.Type), 688return sql.MethodCall(c.Type, c.Method, null, new SqlExpression[] { exp }, dominatingExpression); 700return sql.FunctionCall(typeof(DateTime), "CONVERT", new SqlExpression[2] { datetime2, expr }, expr.SourceExpression); 708return sql.TypedLiteralNull(type, expr.SourceExpression); 713type, sql.TypeProvider.From(type), 722return sql.UnaryConvert(type, typeProvider.From(type), expr, expr.SourceExpression); 800return sql.TypedLiteralNull(type, this.dominatingExpression); 805return sql.ValueFromObject(cons.Value, type, true, this.dominatingExpression); 818return sql.SearchedCase(whens.ToArray(), @else, this.dominatingExpression); 845SqlNew tb = sql.New(mt, qn.Constructor, args, PropertyOrFieldOf(qn.Members), null, this.dominatingExpression); 887SqlNew tb = sql.New(mt, qn.Constructor, args, PropertyOrFieldOf(qn.Members), members, this.dominatingExpression); 1072SqlColumn rowNumber = new SqlColumn("ROW_NUMBER", sql.RowNumber(new List<SqlOrderExpression>(), this.dominatingExpression)); 1081final.Where = sql.Between( 1083sql.Add(skipExp, 1), 1084sql.Binary(SqlNodeType.Add, (SqlExpression)SqlDuplicator.Copy(skipExp), takeExp), 1089final.Where = sql.Binary(SqlNodeType.GT, rowNumberRef, skipExp); 1131eqsel.Where = sql.Binary(SqlNodeType.EQ2V, aref, dupRef); 1132SqlSubSelect ss = sql.SubSelect(SqlNodeType.Exists, eqsel); 1135final.Where = sql.Unary(SqlNodeType.Not, ss, this.dominatingExpression); 1163SqlTableValuedFunctionCall functionCall = sql.TableValuedFunctionCall(function.ResultRowTypes[0].InheritanceRoot, mce.Method.ReturnType, function.MappedName, sqlParams, mce); 1270return sql.MethodCall(u.Type, u.Method, null, new SqlExpression[] { exp }, dominatingExpression); 1277result = sql.Unary(SqlNodeType.Negate, exp, this.dominatingExpression); 1281result = sql.Unary(SqlNodeType.Not, exp, this.dominatingExpression); 1284result = sql.Unary(SqlNodeType.BitNot, exp, this.dominatingExpression); 1288result = sql.Unary(SqlNodeType.Treat, exp, this.dominatingExpression); 1301return sql.MethodCall(b.Type, b.Method, null, new SqlExpression[] { left, right }, dominatingExpression); 1309result = sql.Binary(SqlNodeType.Add, left, right, b.Type); 1313result = sql.Binary(SqlNodeType.Sub, left, right, b.Type); 1317result = sql.Binary(SqlNodeType.Mul, left, right, b.Type); 1320result = sql.Binary(SqlNodeType.Div, left, right, b.Type); 1323result = sql.Binary(SqlNodeType.Mod, left, right, b.Type); 1327result = sql.Binary(SqlNodeType.And, left, right, b.Type); 1330result = sql.Binary(SqlNodeType.BitAnd, left, right, b.Type); 1334result = sql.Binary(SqlNodeType.And, left, right, b.Type); 1338result = sql.Binary(SqlNodeType.Or, left, right, b.Type); 1341result = sql.Binary(SqlNodeType.BitOr, left, right, b.Type); 1345result = sql.Binary(SqlNodeType.Or, left, right, b.Type); 1348result = sql.Binary(SqlNodeType.LT, left, right, b.Type); 1351result = sql.Binary(SqlNodeType.LE, left, right, b.Type); 1354result = sql.Binary(SqlNodeType.GT, left, right, b.Type); 1357result = sql.Binary(SqlNodeType.GE, left, right, b.Type); 1360result = sql.Binary(SqlNodeType.EQ, left, right, b.Type); 1363result = sql.Binary(SqlNodeType.NE, left, right, b.Type); 1366result = sql.Binary(SqlNodeType.BitXor, left, right, b.Type); 1380return sql.Binary(SqlNodeType.Coalesce, left, right, resultType); 1384whens.Add(new SqlWhen(sql.Unary(SqlNodeType.IsNull, left, left.SourceExpression), right)); 1386return sql.SearchedCase(whens.ToArray(), (SqlExpression)dup.Duplicate(left), this.dominatingExpression); 1440SqlExpression any = this.GenerateQuantifier(alias2, sql.Binary(SqlNodeType.EQ2V, aref1, aref2), true); 1464SqlExpression any = this.GenerateQuantifier(alias2, sql.Binary(SqlNodeType.EQ2V, aref1, aref2), true); 1467result.Where = sql.Unary(SqlNodeType.Not, any); 1577selElem.Where = sql.Binary(SqlNodeType.EQ2V, keyExpr, keyDup); 1580SqlSubSelect ss = sql.SubSelect(SqlNodeType.Multiset, selElem); 1598this.map[resultSelector.Parameters[0]] = sql.Member(kgAliasRef, elementType.GetProperty("Key")); 1737return sql.SubSelect(SqlNodeType.ScalarSubSelect, sel); 1788List<SqlExpression> list = values.OfType<object>().Select(v => sql.ValueFromObject(v, elemType, true, this.dominatingExpression)).ToList(); 1800return sql.ValueFromObject(false, this.dominatingExpression); 1803return sql.In(expr, list, this.dominatingExpression); 1806SqlExpression pred = sql.Binary(SqlNodeType.EQ, expr, list[0]); 1808pred = sql.Binary(SqlNodeType.Or, pred, sql.Binary(SqlNodeType.EQ, (SqlExpression)SqlDuplicator.Copy(expr), list[i])); 1834SqlSubSelect exists = sql.SubSelect(SqlNodeType.Exists, sel); 1839SqlSubSelect ss = sql.SubSelect(SqlNodeType.Exists, sel); 1840sel.Where = sql.Unary(SqlNodeType.Not2V, cond, this.dominatingExpression); 1841return sql.Unary(SqlNodeType.Not, ss, this.dominatingExpression); 1871return sql.Member(VisitExpression(ma.Expression), ma.Member); 1944return sql.MethodCall(mc.Method, obj, args, dominatingExpression); 2008return sql.FunctionCall(mc.Method.ReturnType, sqlType, function.MappedName, sqlParams, mc); 2378select.Top = this.sql.ValueFromObject(1, false, this.dominatingExpression); 2384SqlSubSelect elem = sql.SubSelect(subType, select, sequence.Type); 2412SqlExpression sqlExprItem = sql.ValueFromObject(conItem.Value, true, source); 2415bindings.Add(new SqlMemberAssign(mm.Member, sql.Member(sqlExprItem, mm.Member))); 2420sqlItem = sql.New(itemMetaType, cons, null, null, bindings, item); 2422SqlTable tab = sql.Table(metaTable, metaTable.RowType, this.dominatingExpression); 2434sin.OutputKey = new SqlColumn(id.Type, sql.Default(id), id.Name, id, null, this.dominatingExpression); 2452pred = sql.Binary( 2454sql.Member(tableAliasRef, id.Member), 2460pred = sql.Binary(SqlNodeType.EQ2V, tableAliasRef, itemExpression); 2472ProviderType sqlType = sql.Default(id); 2473exp = sql.ConvertTo(id.Type, sqlType, exp); 2519return new SqlVariable(id.Type, sql.Default(id), "@id", this.dominatingExpression); 2522ProviderType sqlType = sql.Default(id); 2600sql.Member(ss.Selection, mmi.Member), 2619select.Where = sql.AndAccumulate( 2620sql.Binary(SqlNodeType.GT, this.GetRowCountExpression(), sql.ValueFromObject(0, false, this.dominatingExpression)),