how update sqlite.net in android xamarin

Question

I have a db with one table, in table I have fields(id,name,place,course,homework,score)

public class LoginTable
{
   [PrimaryKey, AutoIncrement, Column("_Id")]
   public int id { get; set; }

   public string name{ get; set; }
   public string place{ get; set; }
   public string course{ get; set; }

   public string homework{ get; set; }
   public string score{ get; set; }

Now I want to change values field (score) for all row in table with this term:

var data1 = data.Where(x => x.name == "a" && x.place == "b");
if (data1 != null)
{ HELP ME HERE !!!!" HOW CALL ALL ROW of Table(DB) HERE  AND CALCULATE SCORE (UPDATE FIELDS SCORE)" }

I don't know whats written in if {}! Note: I want to calculate new score with this function: score+homework=(new)score

uupload.ir/files/xog7_capture.jpg

hamid
– hamid

2017-07-27 10:20:59 +00:00
Commented Jul 27, 2017 at 10:20 — hamid
– hamid, Commented Jul 27, 2017 at 10:20

summerGhost · Accepted Answer · 2017-07-27 10:48:26Z

1

In Sqlite use,

dbContext.InsertOrReplace(data)
or
dbContext.Update(data)

Update:

var data1 = data.Where(x => x.name == "a" && x.place == "b");
foreach(var item in data1)
{
     item.score = /*your value*/
     dbContext.Update(item);
}

edited Jul 27, 2017 at 10:48

answered Jul 27, 2017 at 9:54

summerGhost

5075 silver badges15 bronze badges

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

2 Comments

hamid Over a year ago

please see uupload.ir/files/xog7_capture.jpg .i want change score when var data1 = data.Where(x => x.name == "a" && x.place == "b"); if (data1 != null){ whats write here}

summerGhost Over a year ago

Please mark as answer and upvote if you find it useful and help others to show the answer helped you.

Collectives™ on Stack Overflow

how update sqlite.net in android xamarin

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related