Hello everyone,
I want to ask that how can I use ado.net framework of C# in business central? For consuming business central data to another data source?
There is nothing specific for Business Central around this. Except you of course need to know where to find the data you want to query for.
Hopefully this can be of help when it comes to the use of ADO in general:
learn.microsoft.com/.../retrieving-and-modifying-data
If you have specific around what data is stored in specific tables or where you find specific data you can circle back with them, But I will recommend you have someone involved in your project that knows the data model of Business Central. Business Central do have a specific way of handling some data - especially around what Business Central call flow field. If you have several companies in your Business Central database these will be stored in separate tables prefixed with the company name. That can also be nice to know.
I am using onprem. How can I do that?
Are you running Business Central on-prem or Business Central Online.
If you are running Online you will not have access to the SQL server and have to use an API approach.
If you run BC on prem you can access the SQL database through ADO.net but you should be careful about updating and inserting data because you can not run any business logic through ado.net. But for reading data it works fine.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156