System.Data.SQLite
Check-in [e9c47a0ef5]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix syntax issue with LINQ UPDATE statement generation. Reported by Den Pakizh via the mailing list.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e9c47a0ef5038384612dc648706b78b82275b85a
User & Date: mistachkin 2014-09-22 20:06:39
Context
2014-09-22
20:09
In SQLiteDataReader.VerifyType method, remove duplicate 'if' statement for the DbType.SByte value and move the remaining 'if' to the Int64 affinity. Fix for [c5cc2fb334]. check-in: 24b429ba4d user: mistachkin tags: trunk
20:06
Fix syntax issue with LINQ UPDATE statement generation. Reported by Den Pakizh via the mailing list. check-in: e9c47a0ef5 user: mistachkin tags: trunk
2014-09-17
02:10
Update downloads page with the modified source archive. check-in: 6a4f9d5919 user: mistachkin tags: trunk
Changes
Hide Diffs Unified Diffs Show Whitespace Changes Patch

Changes to System.Data.SQLite.Linq/SQL Generation/DmlSqlGenerator.cs.

76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
        commandText.Append(" = 0");
      }
      commandText.AppendLine();

      // where c1 = ..., c2 = ...
      commandText.Append("WHERE ");
      tree.Predicate.Accept(translator);
      commandText.AppendLine();

      // generate returning sql
      GenerateReturningSql(commandText, tree, translator, tree.Returning);

      parameters = translator.Parameters;
      return commandText.ToString();
    }







|







76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
        commandText.Append(" = 0");
      }
      commandText.AppendLine();

      // where c1 = ..., c2 = ...
      commandText.Append("WHERE ");
      tree.Predicate.Accept(translator);
      commandText.AppendLine(";");

      // generate returning sql
      GenerateReturningSql(commandText, tree, translator, tree.Returning);

      parameters = translator.Parameters;
      return commandText.ToString();
    }