Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Using ADO.net in Business Central

Posted on by 382

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?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Using ADO.net in Business Central

    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.

  • RE: Using ADO.net in Business Central

    I am using onprem. How can I do that?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Using ADO.net in Business Central

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans