Accessing SQL Analytics Endpoint via .NET API

[hhassan0705]

Hello,

I am trying to write a .NET API to access SQL Analytics Endpoint in Fabric. I know it's possible to update the endpoint via SQL Server Management Studio. Is there a capability available to read / update the endpoint via an API?

[v-sgandrathi · Accepted solution]

Hi @hhassan0705,

 I'm glad that your query was resolved. If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-sgandrathi · Accepted solution]

Hi @hhassan0705,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thanks for using Microsoft Fabric Community Forum.

[v-sgandrathi]

Hi @hhassan0705,

Thankyou @nilendraFabric for your response.

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-sgandrathi]

Hi @hhassan0705,

I wanted to follow up on our previous suggestions provided by coommunity member regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please Accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[hhassan0705]

Hi @nilendraFabric , I think I misworded my question perhaps. I meant to ask if direct writes are permitted for the SQL database within Fabric? Not the lakehouse endpoints. They are permitted via the SQL Server Management Studio for example, just not sure if I can accomplish same via a .NET API as well?

Thanks so much for all the help

[nilendraFabric · Accepted solution]

Fabric’s SQL database uses the Azure SQL Database engine, supporting all standard write operations (INSERT, UPDATE, DELETE, MERGE) through .NET’s `Microsoft.Data.SqlClient`

https://learn.microsoft.com/en-us/fabric/database/sql/feature-comparison-sql-database-fabric

[v-sgandrathi · Accepted solution]

Hi @hhassan0705,

 I'm glad that your query was resolved. If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-sgandrathi · Accepted solution]

Hi @hhassan0705,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thanks for using Microsoft Fabric Community Forum.

[nilendraFabric]

Hello @hhassan0705 

To access Microsoft Fabric’s SQL Analytics Endpoint via a .NET API, you can use the `Microsoft.Data.SqlClient` library with Entra ID (formerly Azure AD) authentication.

Direct writes via SQL are not supported for Lakehouse SQL analytics endpoints (read-only)