Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Video

WebAPI OData – 10 min video introduction (Visual Studio 2013)

I’ve been learning about OData and wanted to record a quick getting started video with how to create a new WebAPI project, add OData Controller, and send HTTP CRUD operations.  Below is an example using Adventure Works Departments with sample code, screenshots, and a 10 minute video introduction.   Please leave a comment if you found this helpful.  Thanks! 

shades_smile

Video Content

  • Create MVC 4 web application
  • SQL Express – Adventure Works Departments
  • Add “AdventureWorks.edmx
    • Wizard driven
    • F4 set namespace
  • Add “DepartmentsController.cs
    • Create from EDMX class
    • Implements ODataController
    • Replace ID with KEY
  • Edit “WebApiConfig.cs
    • Comment out default route
    • Add OData route builder
  • Test with HTTP manually
  • Test with Chrome REST Postman
  • SQL Express – see changed data

Watch Video

WebAPI OData – 10 min video introduction (Visual Studio 2013) from Jeff Jones on Vimeo.

Sample Code

[WebApiConfig.cs]

 

[DepartmentsController.cs]

Downloads

Screenshots

image
image
image
image
image

VIDEO – Tour of SSRS, PowerPivot, and PowerView

I wanted to record an introduction to the new reporting and Business Intelligence capability within SharePoint 2013.   After loading SP2013, there are a few steps to activate the backend Service Applications for BI.   The SQL 2012 install media is needed for this to install SSRS Integrated Mode and PowerPivot.

However, once those are online you can load great samples like “PowerView – Hello World Picnic” to browse real data and confirm it all works correctly.   Very cool stuff, enjoy!  

Smile

References

 

SSRS-PowerPivot-PowerView from Jeff Jones on Vimeo.

VIDEO – How to test SSRS 2012 (map of US states)

Check out the below video to learn how to test SQL Server Reporting Services.  After installing to Central Admin with the steps from http://msdn.microsoft.com/en-us/library/jj219068.aspx  I wanted to see a real report to confirm successful install.    A simple SharePoint list with US state postal abbreviations connects to RDL with Map Wizard and is a great way to show the full pipeline works correctly:

  • SSRS Service Instance (on server)
  • SSRS Service Application (on farm)
  • Authentication (C2WTS or Kerberos)
  • Site Feature (PowerView Integration)
  • Site Content Types  (Report Builder Model – SMDL, Report Builder Report – RDL, Report Data Source – RSDS)
  • Report Builder 3.0  (web deploy click once)
  • RDL web rendering engine
  • Export to PDF  web actions menu

If you find this helpful, please leave a comment and I’ll try to do more videos. 

Smile

 

How to test SSRS 2012 on SP 2013   (length 7:12) from Jeff Jones on Vimeo.

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲