.net application with NAV sql database

Business Central/NAV User Forum
1

hello all,

i have nav 5 sql database attached to server i need to design .net application that can execute some sql select query

only select query (no insert or update or delete)

i need to know this application can cause any problem in the database ?

thanks

2

No, it will not cause any problems. Remember that the users of this application should technically be licensed under, I think it’s called DCO now. It’s essentially a NAV user that doesn’t use the NAV client directly.

3

Without knowing what is retrieved from the database, at what times, at what frequencies, there is no way to say whether it will cause problems. From a data point of view maybe, but select queries can definitely cause performance problems if they interfere with daily processing.

4

thank you very much matt & den ster