Hi PB Team,
I am trying to get my head around what the benefits would be for using PB C# objects in a future .net core 2 web site being planned.  I am planning on using razor pages without using the entity framework. I am not a fan of LINQ so was planning on sticking with SQL with something like Dapper.
However it appears using Dapper it would involve writing insert/update statements for all rows whether they are changed or not. I'm assuming this is not the case with PB data/model store on posts?
Below is an example code behind page for a editable multi row form I have been testing with for proof of concept. I would be interested in how below would change with PB objects?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.Extensions.Configuration;
using RazorPagesExample.Entity;
using System.Data.SqlClient;
using Dapper;

namespace RazorPagesExample.Pages
{    
    public class multirowformModel : PageModel
    {
        public class Proddaplocal
        {
            public int? Id { get; set; }
            public string Name { get; set; }
            public string Model { get; set; }
            public int Price { get; set; }
            public string Country { get; set; }
        }

         [BindProperty]        
        public List products { get; set; }

        IConfiguration config;
        public multirowformModel(IConfiguration configuration)
        {
            if (configuration != null)
            {
                config = configuration;
            }
        }
        public void OnGet()
        {
            var connectionString = config.GetSection("ConnectionStrings").GetSection("ProductContext").Value;
            using (var con = new SqlConnection(connectionString))
            {
                try
                {
                    con.Open();
                    var query = "SELECT Id,Name,Model,Price,Country FROM Product";
                    products = con.Query(query).ToList();
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    con.Close();
                }
            }
        }
        public IActionResult OnPostUpdate()
        {
            var data = products;
            if (ModelState.IsValid)
            {
                var connectionString = config.GetSection("ConnectionStrings").GetSection("ProductContext").Value;
                var count = 0;
                using (var con = new SqlConnection(connectionString))
                {
                    try
                    {
                        con.Open();
                        foreach (var item in data)
                        {
                            if (item.Id == null)
                            {
                                var query = "INSERT INTO Product(Name, Model, Price, Country) VALUES(@Name, @Model, @Price, @Country); SELECT CAST(SCOPE_IDENTITY() as INT);";
                                count = con.Execute(query, item);
                            }
                            else
                            {
                                var query = "UPDATE Product SET Name = @Name, Model = @Model, Price = @Price, Country = @Country WHERE Id = @Id";
                                count = con.Execute(query, item);
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        con.Close();
                    }
                }
            }
            return Page();
        }
        
        public IActionResult OnPostInsert()
        {
            var data = products;
            if (ModelState.IsValid)
            {
                data.Add(new Proddaplocal { Name = "Type Name here"});
            }
            return Page();
        }
    }
}