title: HTTP Error 500.30 - ANCM In-Process Start Failure - 'Microsoft.Data.SqlClient.TdsParser' threw an exception
body: <p>After upgrading to .net core 3.1(3.1.12 sdk) everything works fine on localhost(hosting model outofprocess and inprocess) but when publishing to azure i have issues with the inprocess hosting model, it does not run at all and i get the error below.
  After some further investigation and updating every package(including entity framework) to 3.1.12 compatibility, switching every project from Any CPU to x64, solving any compatibility issues with all packages, the code still breaks, but i found out where, and i still can't determine why this happens.
  <a href="https://i.stack.imgur.com/Nt8Dq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nt8Dq.png" alt="error running dotnet Project.dll from azure scm" /></a></p>
  <p>Also the error comes from this part of code(ADDED TRY CATCH TO SEE IF THE APP WORKS WITHOUT IT, AND IT DOES BUT WE NEED THIS PART, AND I'M PRETTY SURE OTHER STUFF WILL BREAK FURTHERMORE):
  <a href="https://i.stack.imgur.com/o9a57.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o9a57.png" alt="code breaks" /></a></p>
  <p><a href="https://i.stack.imgur.com/3Y9x6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3Y9x6.png" alt="DB CONTEXT" /></a></p>
  <p><a href="https://i.stack.imgur.com/vH9Gb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vH9Gb.png" alt="PACKAGES" /></a></p>