Replace AzureSQL db with Synapse Datawarehouse with Partitioning/Sharding technique - Possibilities?

[gowthamc]

Hi, We have SAAS applications that uses Azure SQL as datastore and connects using EntityFramework. We are exploring Synapse datawarehouse to replace AzureSql. We have below questions that need some assistance.

- Can we able to connect to datawarehouse using EntityFramework (with possibility of having schema changes applied)?

- Can we have some sort of paritioning/sharding technique that can be applied in datawarehouse for tenant specific data (using specific identifier value). Once we no longer want specific data we can truncate the data associated with partition by identifier.

Need some suggestions whether there is such possibility and pl point some documentation. Thank you

[HimanshuS-msft]

Hello @gowthamc 
Thanks for using the Fabric community.

I think your ask is better suited for Microsoft Q&A . I request you to please ask this there .

https://learn.microsoft.com/en-us/answers/questions/ask/

Thanks
HImanshu