Anyone have experience with the JSON column support of #AzureSQL ?

I need to store an array of integers in a heavily read table as efficiently as possible. I also need to be able to query rows that contain that integer.

I'm also needing to have an #EntityFramework6 lib in another application able to query the array out of the JSON to use locally. Feels like it should "just work" but Microsoft docs aren't always straightforward about the pitfalls.

I'm gonna start experimenting later tonight.