How to Execute UpdateAsync with Where statement

Question

I have a table with 1 row. log => 1 | flagLog => 0

 public async void updateFlag()
    {
        var local = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "hinos.sqlite");
        SQLiteAsyncConnection con = new SQLiteAsyncConnection(local, SQLiteOpenFlags.Create | SQLiteOpenFlags.ReadWrite);

        var updateFlagLog = await con.FindAsync<logon>(u => u.log == 1);
        if (updateFlagLog != null)
        {
             await con.UpdateAsync(?????);
        // update logon set flagLog = 1 where log = 1;

        }
    }

I got the row with this comand

var updateFlagLog = await con.FindAsync<logon>(u => u.log == 1);

But i dont know how i use to update this row.

Did u try updateFlagLog.flagLog = 1 and then simply con.UpdateAsync(updateFlagLog)? — Camo
– Camo, Commented Nov 1, 2015 at 0:47
@Rinecamo thx a lot man, run!! I tryed a lot of ways, but it is very simply haha — Henrique Albuquerque
– Henrique Albuquerque, Commented Nov 1, 2015 at 1:40

Francesc Castells · Accepted Answer · 2015-11-01 00:47:57Z

1

I believe you only have to pass the object you want to update.

    var updateFlagLog = await con.FindAsync<logon>(u => u.log == 1);
    if (updateFlagLog != null)
    {
         // TODO do the changes you need to updateFlagLog

         // Update the object
         await con.UpdateAsync(updateFlagLog);
    }

answered Nov 1, 2015 at 0:47

Francesc Castells

2,85722 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Henrique Albuquerque Over a year ago

ohh man almost.. with you sugestion i got and error but i fixed with @Rinecamo sugestion.

Collectives™ on Stack Overflow

How to Execute UpdateAsync with Where statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related