Can I use an update stored procedure to save a view with breeze?

Question

I have a view that has one field that is editable.

My thought was to create an update query and map it to that view, but breeze is throwing an error when I call SaveChanges.

** Error **

TypeError: Cannot read property 'map' of undefined
at i._prepareSaveResult (breeze.min.js:formatted:5066)
at Object.it.AbstractDataServiceAdapter.i.saveChanges.n.ajax.success (breeze.min.js:formatted:4755)
at n (breeze.min.js:formatted:4818)
at angular.js:9408
at processQueue (angular.js:13248)
at angular.js:13264
at Scope.$get.Scope.$eval (angular.js:14466)
at Scope.$get.Scope.$digest (angular.js:14282)
at Scope.$get.Scope.$apply (angular.js:14571)
at done (angular.js:9698)

EDIT

My view is mapped to an entity

public partial class Shop
{
    public Shop()
    {
        this.Notes = new HashSet<SoNote>();
    }

    public int SoId { get; set; }
    public int DetailId { get; set; }
    //[other properties removed for brevity]
    public string ShopTech { get; set; }

    public virtual OrderEdit OrderEdit { get; set; }
    public virtual ICollection<SoNote> Notes { get; set; }
}

}

SoId and DetailId are my key and I want the user to be able to update ShopTech.

This is using model first.

Answer 1

I'm not sure this error is the actual root cause. How is your view defined and what kind of database are you using? There are restriction on the database as far as updating a view is concerned. In most cases views are read-only and a SQL update statement against it will fail. Certain types of views are editable. For the other cases, EntityFramework 6 allows you to define insert/update/delete stored procedures. Have you defined an update stored procedure? As long as EF is able to update your entity, Breeze should be just fine with that.

Here's more info on using stored procs with code first. https://msdn.microsoft.com/en-us/data/dn468673.aspx