Azure Iot Edge - System.Data.SqlClient is not supported on this platform

Question

Hi Everyone,

I have deployed an Azure Function using the Edge Hub trigger as a custom IoT Edge module. The primary objective of this function is to insert data into SQL Edge. To achieve this, I have been following the guidelines provided in the Microsoft documentation:

Store data in SQL Server using Azure IoT Edge

However, I am encountering persistent issues related to establishing a connection with the SQL database.

However, I am encountering persistent issues related to establishing a connection with the SQL database. Despite multiple attempts to resolve the problem, I have not been successful. Here are the steps I have taken so far:

Version Downgrading:

I attempted to downgrade the SQL client library version as suggested in this Microsoft Q&A thread.

https://learn.microsoft.com/en-us/answers/questions/656221/azure-iot-edge-system-data-sqlclient-is-not-suppor

Switching SQL Client Libraries:

I tried both Microsoft.Data.SqlClient and System.Data.SqlClient packages to handle the SQL connections, but neither approach resolved the issue.

Verification of Configuration:

1. I have verified that the connection strings are correctly configured.
2. Ensured that the SQL Edge instance is properly set up and accessible from the IoT Edge module.
3. Confirmed that all necessary network configurations and permissions are in place.

Despite these efforts, the Azure Function fails to establish a successful connection with SQL Edge, resulting in errors that hinder data insertion operations.

Could you please provide guidance or suggestions on how to resolve this SQL connection issue within the Azure Function deployed as an IoT Edge module? Any insights into configuration adjustments, compatibility considerations, or alternative approaches would be greatly appreciated.

Thank you for your assistance.

Best Regards,

Praveen Kumar