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

Announcements

No record found.

News and Announcements icon
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 436

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,165 Moderator on at

    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 436 on at

    I am using onprem. How can I do that?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,165 Moderator on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,993 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,116 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans