Check out the below 10 minute video for how get started using “spcrud.js” to easily connect Angular JS applications to SharePoint List data. I created this library as a wrapper for AngularJS $http GET and POST. We can streamline the repetitive SharePoint plumbing of JSON headers, HTTP VERBs, and URL syntax. Now you can easily call “spcrud.read()” or “spcrud.update()” instead of formatting each HTTP request.
Check out this quick 7 minute video for how I configure my local PowerShell console with both Microsoft and community cmdlets. Remotely manage Office 365 sites with Global Administrator rights or even simple Power User. Options exist for all access levels.
Please leave a comment if you found this helpful. Enjoy!
One common challenge is data access.
With C# I have years of experience with [System.Data] and can perform CRUD against SQL relational databases in my sleep. Open connection, query, data adapter, fill DataTable, and voila! Muscle memory. Second nature. Tried and true methods. However, in the new client side JS world I had no clue where to begin.
ASP.Net (ASPX) web forms
ASCX user controls
SharePoint web parts
WCF 5.6 data services
I set out to code an example with a few goals:
Create simple SQL schema (two tables – parent/child – one to many)
Execute CRUD operations in JS against SQL tables
Leverage JS plugins and NuGet “Install-Package” to load third party components
Little code as possible
The whole thing took less than 30 minutes and I edited video down to just 15. I was impressed by how straightforward and easy the process was. Breeze# in ASP.Net MVC for the back end WebAPI controller was nearly identical to the Breeze example code. Add one C# method per entity (SQL table) and Breeze does the rest. The JS front end took a little more time to understand but was also easy to apply. Connect Entity Manager to the Breeze URL and you’re ready for CRUD queries. Amazing! Given how easy Breeze is I would be hard pressed to use OData or manually created WebAPI controllers with C# code to query a database. If you can use Breeze, then use it! You’ll save lots of effort.
Please leave a comment if you found this helpful. Thank you!