VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2)
Our next step in this series is cloud hosting. Each of the local source components has a Microsoft cloud destination equivalent. Here is the mapping:
- SQL Express > SQL Azure
- WebAPI > Azure Web App
- Angular SPA > Office 365 SharePoint Content Editor
In the video below I walk through all of these steps to migrate the local “todo” CRUD application created earlier to be fully hosted in Microsoft’s cloud. From there, we have a fully operational business application running on Office 365 with all custom code hosted in Azure.
Enjoy! 
Video
VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2) from Jeff Jones on Vimeo.
Hi Jeff,
I get the error “t.EntityAspect is undefined” – So Delete is not working.
( I am using Windows 10 and Chrome Browser)
This
is the only problem remaining. Everything else works like a charm,
after deploying to SharePoint online (front-end) and SQL Azure
(Database) .
I am going to be addicted to your blog now.
Thanks
Glad you found it helpful. Check out the Breeze JS filter docs at http://breeze.github.io/doc-js/lap-query-filter.html
Example:
query = query.where(“IsArchived”, “==”, false);
That should allow filtering to a single record by sending the primary key.
Hi jeff, Thanks for the reply. I had actually that one working last night, and I also added Index to the ID column, so it is great. Only question outstanding is the Delete not working which I have asked on your other video, but copied here:
I get the error “t.EntityAspect is undefined” – So Delete is not working.
( I am using Windows 10 and Chrome Browser)
Thanks again.
Hi Jeff,
I really need your guidance in the following:
I am able to successfully create an API and deployed to Azure which gets entities from a view in a Azure SQL database. I was able to test in Fiddler as you described with the key. The main issue is that I have more than 250,000 records in the View, so is there a way I can get just one record with the given primary Key value? I was looking at Breeze online site. Is that the way? That will only filter on client side? correct? I just want one record from the 250,000 + records, given the value of the key.
Thanks