Subsonic 2.2 - Update with expresssion - how to make my solution better?

Question

Hi,

I'm learning SubSonic 2.2, and have the following query, but it feels "Wrong" writing my expression ("count + 1") as a string.

Can any experts suggest a better way that this?

            int records = new Update(Wordsfile.Schema)
            .SetExpression(Wordsfile.CountColumn).EqualTo("count + 1")
            .Where(Wordsfile.Columns.WordId).IsEqualTo(wordID)
            .And(Wordsfile.Columns.FileId).IsEqualTo(fileID)
            .Execute();

It's the line: ".SetExpression(Wordsfile.CountColumn).EqualTo("count + 1")".

I've tried: ".SetExpression(Wordsfile.CountColumn).EqualTo(Wordsfile.Columns.Count + 1)", but no joy.

Any suggestions

Thanks!

Answer 1

Try this instead:

.SetExpression(Wordsfile.CountColumn).EqualTo(Wordsfile.Columns.Count + " + 1")

Answer 2

Strings aren't so bad and in your case it's pretty simple stuff ("+1"). You could throw a trigger in there :) if you wanted...