The right service to listen to iot-hub and send queries to Azure SQL

0
votes

I'd like to build a small solution on Azure for practice. I'd be sending data using IOT-HUB from some devices and what I need is some way to interpret this data and do appropriate query to Azure SQL.

Basically I would need a way to have my program running all the time being able to:

  • listen to events from iot-hub
  • interpret event information and save/get data to/from database
  • send a message to some device using iot-hub

Which service would be good for that? Am I able to use Entity Framework? In ideal solution I'd create a C# program to do what I need and have it running in Azure, waiting for events from iot-hub, having access to my database - is it even possible? I'm very new (rather completely new) to cloud solutions, so I'd be really grateful for any advices. Currently I feel completely lost in all these Azure services.

1
azureazure-sql-databaseazure-iot-hub
Have you check Azure Function ? - Rita Han
@RitaHan-MSFT Yes, i just recently started to use them. I think it's a pretty good solution for my needs. Thanks - Loreno

1 Answers

0
votes

There is quite some documentation on Azure IoT and how one can possible architect an IoT solution.

  1. The IoT documentation is the obvious first step to get an overview of what Azure offers. There are some nice 'Getting Started' walkthroughs also
  2. Take a look at this IoT reference architecture. Quite helpful to get an overview.

There are tons of links and interesting examples for Azure IoT. Just google around.