ADO.NET in AL

jimmyf

Hi
Is it possible to connect to an external database in Business Central AL using ADO or ADO.NET?

Thanks

nicolassaleron

Hello,

Like BlackTiger said: you can do it on-prem with .Net variables.

To be compliant with Microsoft Cloud and On-Prem deployments, you should consider:
- using an Azure Function
- or develop a Web API (for instance with ASP.Net Core https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-2.2&tabs=visual-studio) and call it with HttpClient (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/httpclient/httpclient-data-type)