Multiple update query in Razor Pages .ASP.NET

I'm trying to develop a tiny front-end for a sqlite DB using Razor Pages (NOT MVC!).

Looks like it supports SQL in a different way, not like I used to in the past.

For example, I need to re-assign value to the field Pl_Pos (position of the record in the list). Now I do this like that:

        for (int i = PlnPos + 1; i<= PlModelIndexModel.PlnModelTotal; i++)
        {
            PlnModel PlnModelRedo = await _context.Plane_Models.FirstOrDefaultAsync(m => m.Pl_Model_Pos == i);
            PlnModelRedo.Pl_Model_Pos = i - 1;
            _context.Attach(PlnModelRedo).State = EntityState.Modified;
            await _context.SaveChangesAsync();
        }

Is there any other way to do it more efficient and do something like:

Update Pl_Models set Pl._Models.Pl_Pos = Pl_Models set Pl._Models.Pl_Pos - 1 where Pl_Models set Pl._Models.Pl_Pos > PlnPos

I stuck a bit...

Thanks in advance!