5 writes to sb
System.Data.Linq (5)
SqlClient\Query\SqlFormatter.cs (5)
62this.sb = new StringBuilder(); 533this.sb = new StringBuilder(); 540this.sb = savesb; 765this.sb = new StringBuilder(); 772this.sb = savesb;
246 references to sb
System.Data.Linq (246)
SqlClient\Query\SqlFormatter.cs (246)
69return this.sb.ToString(); 106this.sb.Append("("); 108this.sb.Append(")"); 117sb.Append("NOP()"); 126this.sb.Append(GetOperator(uo.NodeType)); 127this.sb.Append(" "); 132this.sb.Append(GetOperator(uo.NodeType)); 143this.sb.Append(GetOperator(uo.NodeType)); 144this.sb.Append("("); 146this.sb.Append("*"); 150this.sb.Append(")"); 156sb.Append(" "); 157sb.Append(GetOperator(uo.NodeType)); 161this.sb.Append("CONVERT("); 166this.sb.Append(uo.SqlType.ToQueryString(options)); 167this.sb.Append(","); 169this.sb.Append(")"); 183sb.Append("ROW_NUMBER() OVER (ORDER BY "); 188if (i > 0) sb.Append(", "); 193sb.Append(" DESC"); 197sb.Append(")"); 210sb.Append("COALESCE("); 212sb.Append(","); 214sb.Append(")"); 218sb.Append(" "); 219sb.Append(GetOperator(bo.NodeType)); 220sb.Append(" "); 229sb.Append(" BETWEEN "); 231sb.Append(" AND "); 238sb.Append(" IN ("); 241sb.Append(", "); 245sb.Append(")"); 251sb.Append(" LIKE "); 254sb.Append(" ESCAPE "); 266sb.Append(fc.Name); 269sb.Append("("); 272sb.Append(", "); 275sb.Append(")"); 285sb.Append("CAST("); 287sb.Append(" AS "); 292sb.Append(c.SqlType.ToQueryString(options)); 293sb.Append(")"); 298sb.Append("TREAT("); 300sb.Append(" AS "); 302sb.Append(")"); 310sb.Append("COLUMN("); 326sb.Append(aliasName); 327sb.Append("."); 328sb.Append(c.Name); 330sb.Append(")"); 336sb.Append("DTYPE("); 340sb.Append(")"); 347sb.Append("DISCO("); 351sb.Append(")"); 360sb.Append("SIMPLE("); 362sb.Append(")"); 370sb.Append("SHARED("); 372sb.Append(")"); 380sb.Append("SHAREDREF("); 382sb.Append(")"); 405sb.Append("."); 422sb.Append(SqlIdentifier.QuoteCompoundIdentifier(s)); 427sb.Append(SqlIdentifier.QuoteCompoundIdentifier(s)); 429sb.Append(SqlIdentifier.QuoteCompoundIdentifier("@" + s)); 433sb.Append(p.Name); 452sb.Append("client-parameter("); 460sb.Append(value); 461sb.Append(")"); 470sb.Append("SCALAR"); 472sb.Append("("); 476sb.Append(")"); 487sb.Append("ELEMENT("); 491sb.Append(")"); 502sb.Append("MULTISET("); 506sb.Append(")"); 514sb.Append("EXISTS("); 518sb.Append(")"); 532StringBuilder savesb = this.sb; 537args[i] = this.sb.ToString(); 538this.sb.Length = 0; 542sb.Append(string.Format(CultureInfo.InvariantCulture, suq.QueryText, args)); 544sb.Append(suq.QueryText); 550sb.Append(suc.Name); 555sb.Append("EXEC @RETURN_VALUE = "); 557sb.Append(" "); 564if (i > 0) sb.Append(", "); 566sb.Append(" = "); 569sb.Append(" OUTPUT"); 573if (pc > 0) sb.Append(", "); 575sb.Append(" = "); 577sb.Append(" OUTPUT"); 602sb.Append("("); 608sb.Append(")"); 612sb.Append(" AS "); 619sb.Append("AREF("); 621sb.Append(")"); 640sb.Append("("); 646sb.Append("UNION"); 648sb.Append(" ALL"); 653sb.Append(")"); 660sb.Append("ES("); 663sb.Append(", "); 666sb.Append(")"); 678sb.Append(", "); 691sb.Append(" AS "); 702sb.Append("new "); 703sb.Append(sox.ClrType.Name); 704sb.Append("{ "); 709if (i > 0) sb.Append(", "); 710sb.Append(sox.ArgMembers[i].Name); 711sb.Append(" = "); 717if (i > 0) sb.Append(", "); 720sb.Append(ma.Member.Name); 721sb.Append(" = "); 725sb.Append(" }"); 733sb.Append("new []{"); 735if (i > 0) sb.Append(", "); 738sb.Append("}"); 744sb.Append("."); 745sb.Append(m.Member.Name); 750if (sb.Length > 0) { 751sb.AppendLine(); 754sb.Append(" "); 764StringBuilder savesb = this.sb; 771from = this.sb.ToString(); 775sb.Append("SELECT "); 778sb.Append("DISTINCT "); 782sb.Append("TOP "); 784sb.Append("("); 788sb.Append(")"); 790sb.Append(" "); 792sb.Append(" PERCENT "); 801sb.Append("NULL AS [EMPTY]"); 806sb.Append("FROM "); 807sb.Append(from); 811sb.Append("WHERE "); 816sb.Append("GROUP BY "); 820sb.Append(", "); 825sb.Append("HAVING "); 831sb.Append("ORDER BY "); 835sb.Append(", "); 838sb.Append(" DESC"); 861sb.Append(", "); 871sb.Append("("); 873sb.Append(")"); 885sb.Append("CROSS APPLY "); 888sb.Append("CROSS JOIN "); 891sb.Append("INNER JOIN "); 894sb.Append("LEFT OUTER JOIN "); 897sb.Append("OUTER APPLY "); 910sb.Append(" ON "); 913sb.Append(" ON 1=1 "); 951sb.Append("client("); 953if (i > 0) sb.Append(", "); 956sb.Append("; "); 958sb.Append(")"); 966sb.Append("big-join("); 968sb.Append(", "); 970sb.Append(")"); 975sb.Append("DELETE FROM "); 979sb.Append(" WHERE "); 989sb.Append("DECLARE @output TABLE("); 991sb.Append(" "); 992sb.Append(si.OutputKey.SqlType.ToQueryString()); 993sb.Append(")"); 996sb.Append("DECLARE @id "); 997sb.Append(si.OutputKey.SqlType.ToQueryString()); 1002sb.Append("INSERT INTO "); 1007sb.Append("("); 1009if (i > 0) sb.Append(", "); 1012sb.Append(")"); 1017sb.Append("OUTPUT INSERTED."); 1019sb.Append(" INTO @output"); 1023sb.Append(" DEFAULT VALUES"); 1028sb.Append("VALUES ("); 1033if (i > 0) sb.Append(", "); 1037sb.Append(")"); 1043sb.Append("SELECT @id = "); 1044sb.Append(si.OutputKey.Name); 1045sb.Append(" FROM @output"); 1048sb.Append("SELECT "); 1050sb.Append(" FROM @output"); 1058sb.Append("UPDATE "); 1062sb.Append("SET "); 1065if (i > 0) sb.Append(", "); 1068sb.Append(" = "); 1073sb.Append("WHERE "); 1081sb.Append("SET "); 1083sb.Append(" = "); 1091sb.Append("(CASE "); 1096sb.Append("WHEN "); 1098sb.Append(" THEN "); 1103sb.Append("ELSE "); 1108sb.Append(" END)"); 1116sb.Append("(CASE"); 1119sb.Append(" "); 1126sb.Append("ELSE "); 1130sb.Append("WHEN "); 1132sb.Append(" THEN "); 1138sb.Append(" END)"); 1149sb.Append("(CASE"); 1152sb.Append(" "); 1159sb.Append("ELSE "); 1163sb.Append("WHEN "); 1165sb.Append(" THEN "); 1171sb.Append(" END)"); 1182sb.Append("(CASE"); 1185sb.Append(" "); 1192sb.Append("ELSE "); 1196sb.Append("WHEN "); 1198sb.Append(" THEN "); 1204sb.Append(" END)"); 1210sb.Append(v.Name); 1231sb.Append(type.ToQueryString()); 1237sb.Append("NULL"); 1247sb.Append("'"); 1248sb.Append(this.EscapeSingleQuotes(value.ToString())); 1249sb.Append("'"); 1252sb.Append(this.GetBoolValue((bool)value)); 1265sb.Append(value); 1269sb.Append("'"); 1270sb.Append(value); 1271sb.Append("'"); 1277sb.Append("typeof("); 1278sb.Append(valueType.Name); 1279sb.Append(")"); 1289sb.Append("value("); 1290sb.Append(value.ToString()); 1291sb.Append(")"); 1362sb.Append("LINK("); 1364sb.Append(")"); 1366sb.Append("LINK("); 1368if (i > 0) sb.Append(", "); 1371sb.Append(")"); 1385sb.Append(mc.Method.DeclaringType); 1389sb.Append("."); 1390sb.Append(mc.Method.Name); 1391sb.Append("("); 1393if (i > 0) sb.Append(", "); 1396sb.Append(")"); 1402sb.Append("opt("); 1404sb.Append(", "); 1406sb.Append(")"); 1424sb.Append("Group("); 1426sb.Append(", "); 1428sb.Append(")");