title: Error Data is Null in Asp.net core using stored procedure
body: <p>Hi I am trying to get data from my stored procedures</p>
  <p>Here's my Controller
  <a href="https://i.stack.imgur.com/nSUWY.png" rel="nofollow noreferrer">DashboardController</a></p>
  <p>Here's my ViewModel <a href="https://i.stack.imgur.com/fst4G.png" rel="nofollow noreferrer">DashboardViewModel</a></p>
  <p>Here's my Javascript <a href="https://i.stack.imgur.com/cm7fw.png" rel="nofollow noreferrer">AJAXPhoto1</a> <a href="https://i.stack.imgur.com/wgf6B.png" rel="nofollow noreferrer">AJAXPhoto2</a></p>
  <p>Here's my table <a href="https://i.stack.imgur.com/zEXLM.png" rel="nofollow noreferrer">table</a></p>
  <p>getting an error of <strong>SqlNullValueException: Data is Null. This method or property cannot be called on Null values</strong></p>
  <p>Note: my stored procedure is displaying values when executed from sql only not in the asp.net core</p>
  <p>im still new to asp.net core and first time using stored procedure without entity framework. Any help is appreciated. Thank you!</p>