Cannot build Visual Studio database solution if using OPENJSON

• wittr

  Old Hand

  Points: 392

  More actions

  November 1, 2017 at 9:43 am

  #324306

  Greetings, all.
  I am working with a database project in Visual Studio.Enterprise 2015 & SQL Server 2016. I constructed some procedures & functions using the new JSON functionality. They work in SQL Server (with compatibility level 130.) However, if I add those code components to my Visual Studio project & try to build the solution, it fails, generating all kinds of syntax errors. Looking online, the only thing I can find is that there may be an as-yet-not-completely-fixed issue with OPENJSON in Visual Studio.
  Has anyone here encountered this issue? Do you have a solution, workaround, etc.?
  Thanks,
  Randy

• Thom A

  SSC Guru

  Points: 99133

  More actions

  November 1, 2017 at 10:00 am

  #1966216

  Duplicate of https://www.sqlservercentral.com/Forums/1905612/Unable-to-build-Visual-Studio-database-solution-when-using-OPENJSON

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk