web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Using ADO.net in Busin...
Small and medium business | Business Central, N...
Suggested Answer

Using ADO.net in Business Central

(0) ShareShare
ReportReport
Posted on by Muhammad Anas Naeemi 390

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?

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator 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.

  • Muhammad Anas Naeemi Profile Picture
    Muhammad Anas Naeemi 390 on at
    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 1,105 Moderator 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans