SQLite; Is there a parameter to rewrite a single record each time

Question

Right now, I can write records one by another, as it's shown below. How do I rewrite a single record each time? For example only first one.

Code Behind:

 public static List<PersonModel> LoadPeople()
    {
        using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
        {                
            var output = cnn.Query<PersonModel>("select * from Person", new DynamicParameters());
            return output.ToList();
        }
    }

    public static void SavePerson(PersonModel person)
    {
        using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
        {
            cnn.Execute("insert into Person (FirstName, LastName) values (@FirstName, @LastName)", person);

        }
    }

    private static string LoadConnectionString(string id = "Default")
    {
        return ConfigurationManager.ConnectionStrings[id].ConnectionString;
    }

vvilin · Answer 1 · 2019-09-11T17:32:57.330

1

If you want to update the first row (id=1), you can go to the Execute SQL tab and use this:

UPDATE Person SET FirstName=Mitsubishi WHERE Id=1;

In your c# code I guess it would be:

public static void UdatePerson(PersonModel person, int id)
    {
        using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
        {
            cnn.Execute("update Person (FirstName, LastName) set (@FirstName, @LastName) where Id = @id", new {person, id});
        }
    }

Take a look at that link if you need further information: https://dapper-tutorial.net/execute

edited Sep 11 '19 at 17:32

answered Sep 11 '19 at 16:36

vvilin

185
10

How is it going to look for C#? – Msorich Sep 11 '19 at 16:44
I think you are not showing/telling us everything, if you have some c# code behind and you want to update that row from c#, then you should probably show us some of that code so we can help you – vvilin Sep 11 '19 at 17:11
I've added code behind. – Msorich Sep 11 '19 at 17:21
I have also updated my answer. – vvilin Sep 11 '19 at 17:33
At the end of the string 'id' causes a mistake, sounds like: The name 'id' doesn't exist in the current context. – Msorich Sep 11 '19 at 17:59
how do I use this method, fro example in button even? Can't use that. – Msorich Sep 12 '19 at 07:12

SQLite; Is there a parameter to rewrite a single record each time

1 Answers1