Finance | Project Operations, Human Resources, ...

Architecture of Unified dev environment

(2) Share

Report

Posted on by CU10121822-0

306

Dear team,

I have go through blogs that which recommended to install Visual studio 2022 in our local system.

it's okay. but I am confused here how the database will connect with our local system and if I do any CRUD operations, then how it's impact in db.

Kindly elaborate please.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

André Arnaud de Cal... 303,706 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The architecture is based on having Visual Studio 2022, in fact, working offline. There is a Dynamics 365 F&O online environment available. When you connect to that environment, it will check if you have the correct meta data, otherwise it will download them, so you have a local copy of the source code (standard application). You can only perform development and after building the code, deploy this to the online environment.

From Visual Studio, you don't do any direct CRUD operations. That is in the online application by navigating through forms and starting (periodic) jobs.

There is an option to get JIT database access, then you can use e.g. SQL Server Management Studio to look at the database and it's content.

For cross-references, a local DB is used.

Was this reply helpful? Yes No
CU10121822-0 306 on at

Like (0)

Report
Copy link

Link copied!

Thanks ,Andre for the response.

What I understood,

1. The Visual studio 2022 is worked as offline. It means whatever development we did that was in offline only.

2. As you said "Dynamics 365 F&O online environment available". What it means?

3. As you siad "You can only perform development and after building the code, deploy this to the online environment.

So, it means only development will happened offline and deploy will be in online environment.

Kindly elaborate pls. here deploy the object means is it check -in?

pls let me know the process how will i do the code deployment after building the code.

4. As you said " From Visual Studio, you don't do any direct CRUD operations.

for example - if I like to update or insert data in Sales table. Usually, we used set based operation to perform it from Visual Studio 2022 in cloud hosted environment.

Is it not possible now in Unified dev environment? If no, then how will I achieve this?

Kindly elaborate please. thanks!

Was this reply helpful? Yes No
CU10121822-0 306 on at

Like (0)

Report
Copy link

Link copied!

Dear all,

Once available, pls reply... Thanks!

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,031 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It seems that you haven't read the documentation, because your question are answered there. You may want to start with Tutorial: Write, deploy, and debug X++ code.

Regarding your questions:

2. You have development tools on your local machine and an F&O environment running in cloud.

3. A deployment means installing the solution you've developed to the F&O environment. No, it's not a the same thing as a check-in. A check-in is used to store your source code files in a version control system.

You can deploy code from Visual Studio with Deploy Models to Online Environment, or do it automatically, typically by an Azure pipeline. Check out the documentation for details.

4. You're wrong - Visual Studio isn't where F&O runs. F&O runs on a web server. Visual Studio is used just for things like edition XML files with source code. When you want to run F&O, you connect to a web server, typically by a web browser. It's the same for CHE and UDE; the only difference is where the web server is running.

Was this reply helpful? Yes No
CU10121822-0 306 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin for the response.

Only no 4 is not understand clearly. Kindky explain pls. thanks!

Was this reply helpful? Yes No
Martin Dráb 239,031 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hmm, I'm not sure what you don't understand; it's pretty simple. Let me try it once more and then tell me which part you don't understand.

F&O is a web application, which means it runs on a web server (such as IIS) and you access it via a web browser (such as Chrome).

Visual Studio is a development environment, where you have tools like code editors.

F&O doesn't run inside F&O, therefore your statement "I like to update or insert data in Sales table. Usually, we used set based operation to perform it from Visual Studio 2022 in cloud hosted environment" is incorrect. You can write source code in Visual Studio, but it's not executed in Visual Studio - it's compiled to binaries, binaries deployed to a web server and executed there.

Was this reply helpful? Yes No