title: How can I save Large Json Data to sql database using Entity Framework SaveChanges()?
body: <p>I am trying to save a large json data (approx 2-3 MB) text file size data using Entity Framework.</p>
  
  <pre><code>Dim data As New jsonData With { .ID = _id, .jsonData = jsonDataFromFile }
  MyContext.DataContext.JSONTempTable.Add(data)
  MyContext.SaveContext("SaveJsonData")
  </code></pre>
  
  <p>This code works perfectly fine for small json data, but if the Json is larger (file size 1.5 mb), then it won't save in database. It does not throw any error. In database, <code>jsonData</code> column is of <code>varchar(max)</code> datatype.</p>
  
  <p>How can I save large JSON in <code>varchar(max)</code> data type column?</p>
  
  <p>--Edited
  yes I do have try catch with logging but it won't go to catch block. 
  In entity framework that property is like below</p>
  
  <pre><code>Public Property jsonData As String
  </code></pre>