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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (1)

_QWERTY 10 on at

Like (0)

Report

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

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.
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

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

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.
Verified answer

Mohana Yadav 59,137 Super User 2024 Season 2 on at

Like (0)

Report

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

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..