Can you skip codeunits and insert directly to database directly from external application?

(0) Share

Report

Posted on by Community Member

Hey, I've only recently started developing on Microsoft dynamics NAV and someone suggested to me to write a C# application that writes directly into the database rather than consuming web services exposed in NAV. I have a feeling there could be something terribly wrong with doing that for a database being used by Microsoft Dynamics NAV but don't know what. Could that really work?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mohana Yadav 61,184 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

it depends upon your requirement.

if you are importing to an intermediate table and later process the data then it is fine.

codeunits and table triggers will execute some code to calculate and validate..

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You may write a C# code to directly write on the database. As Mohana said, if your requirement is not about checking validations or calculations, then you can though it is not recommended.

Hope it helps.

Was this reply helpful? Yes No
_QWERTY 10 on at

Like (0)

Report
Copy link

Link copied!

Besides table triggers, you need to be aware, that your Server Instance don't know that you have been updating the data. If the data you have changed has already been Cached in your Server Instance, it won't be updated before you force it to update. So your users might get outdated data from your Server Instance Cache.

Was this reply helpful? Yes No