Example to update data using sqlite.net-pcl

SilverSurfer · August 2015

Hi,

I see the document shows an example of how to insert data using SQLite.net-pcl, but how do I update data?

The insert example seems simple, but how do I update?

        db.Insert(
            new TableAccount 
            {
                fieldKey = "TEST",
                fieldValue = "hello world!"
            }
        );

SilverSurfer · August 2015

Nevermind, I figured it out. You basically need to set the column as primary key and it will automatically know which row to update. Pretty slick!

    db.Update(
        new TableAccount 
        {
            fieldKey = "TEST",
            fieldValue = "hello world!"
        }
    );

JamesMontemagno · August 2015

Also, take a look at https://github.com/jamesmontemagno/MeetupManager as I have a great example in there of structuring it with SQLite-net PCL.

Xamarin

Quick Links

Example to update data using sqlite.net-pcl

Answers