title: API call JSON File and create Database
body: <p>I am wondering how to create a database based off a JSON file. The file I'm working with is:</p>
  
  <p><a href="https://data.cityofnewyork.us/api/views/5b3a-rs48/rows.json?accessType=DOWNLOAD" rel="nofollow">JSON file</a></p>
  
  <p>What I am using is Visual Studio 2015 and MSSQL 2012. A few of the included options I'm using are Entity Framework with MVC and WEB API template. I want to use LINQ, but am lost on how to accomplish that. What I do know is how to make a SQL connection and create a database and tables, and store info. using SQLcommands function.</p>
  
  <p>Questions:</p>
  
  <p>I want to know how to make an API call using jquery (from data.gov) to get the JSON file and create a database schema with the necessary tables from that JSON file provided above. Then use LINQ to create database. OR</p>
  
  <p>If I make the JSON file as a resource to my project and create the database schema and tables, how would I parse that data in correctly using LINQ? </p>
  
  <p>Is there a way to see what kind of tables and columns the JSON file has visually, like a cool software or something?</p>
  
  <p>From there, I will be able to re-populate the same JSON file into a better database design in 3rd normal form (if it's not in that already).</p>
  
  <p>Conclusion:</p>
  
  <p>As mentioned before, I'm using Entity Framework with MVC capabilities that I will custom code specifically for that data with basic CRUD functions.
  If I'm unclear or this question is not relevant please comment.</p>