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