SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

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!

shades_smile

 

 

Video

VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2) from Jeff Jones on Vimeo.

  • Emt

    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.

      • Emt

        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.

  • Emt

    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

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲