主題大綱

• Interacting with Data in .NET Using Multiple Data Models

  Interacting with Data in .NET Using Multiple Data Models

  Content Type
  Exercise

  Duration
  10m

  Level
  Introductory

  Try out the multi-model architecture of InterSystems IRIS® data platform, which lets you write code using the data models that best fit each task in your application. Multi-model access in InterSystems IRIS is possible due to an underlying data structure called globals, which allow you to interact with your data directly. These provide flexible data access while avoiding data duplication.

  In a .NET application, you can connect to InterSystems IRIS with the Native SDK and use globals to interact with your data. Another option is to connect with ADO.NET and use industry-standard SQL to access your data. In this case, data is modeled as a relational table. You can also use XEP and Entity Framework to treat the same data as objects, without the need for additional object-relational mapping software.

  The same capabilities exist whether you are programming in InterSystems ObjectScript or using one of the external language APIs. If you are more familiar with a different language, try this exercise in Python, Java, or ObjectScript.

  Watch the video and try the exercise below!
• 全部縮合展開全部
  Start the Exercise

  Start the Exercise

  In the tasks below, you will create a set of airport data as objects, retrieve the data via SQL, and then natively access custom data structures to store route information.

  Note:

  You can follow along with these instructions on your own server instead of using the Learning Lab. To do so, first download the code sample from GitHub and compile it on your InterSystems server. You should use your own InterSystems Terminal and IDE.

  • Launch Your Lab

    Use the online lab provided to complete this exercise.

    
    

  • You must be logged in to launch an InterSystems IRIS instance.

    • Log in with your existing account.
    • Don't have an InterSystems account? Create a new account.
  • Open VS Code to view .NET sample code
    

    1. Open the link to your lab in the launcher above.
    2. On the desktop of the lab, open Visual Studio Code.
    3. View the .NET sample project by opening the VS Code Explorer, then expanding quickstarts-multimodel-dotnet > src.
  • Use objects and SQL side-by-side

    1. Inspect the code in MultimodelQS.cs.
       • The populateAirports() method populates five objects and saves them to the database.
       • The getAirports() method runs an SQL query and returns all airports, printing them to the screen.
    2. Open a Linux terminal in VS Code using Terminal > New Terminal.
    3. Navigate to the folder containing MultimodelQS.cs:

       cd quickstarts-multimodel-dotnet/src

    4. Run MultimodelQS.cs, which executes the populateAirports() and getAirports() methods:

       dotnet run MultimodelQS.cs

    5. Inspect the output to verify that airport data was created and written to the console.

    It is possible to accomplish these two tasks using only objects or SQL to populate and access the data. However, using the multi-model capabilities of InterSystems IRIS, you can choose the best data model according to the task—optimizing both developer time and application performance.

  • Create a custom data structure with globals

    In your work with airport data, a new question has come up: you need to get information about routes between the airports stored in your database. Fortunately, with InterSystems IRIS you can use globals to natively store data in a custom data structure, modifying the structure to fit your specific data. This allows you to handle the route information easily, even though it was not part of the initial schema design.

    1. In VS Code, return to MultimodelQS.cs and locate the storeAirfare() and checkAirfare() methods.
       • The storeAirfare() method has been created to store route information to InterSystems IRIS.
       • The data structure used in this method does not use objects or an SQL table. Instead, it uses the global variable ^airport.
       • Similarly, check_airfare() accesses the ^airport global to return a particular route, if it exists.
    2. Uncomment lines 53-54 in MultimodelQS.cs and save the file.
    3. Run the code again:

       dotnet run MultimodelQS.cs

    4. When prompted, enter values to see if there are routes from BOS to AUS. You should find there are two routes available.
    5. Run it again and try BOS to LAX, which should return no available routes.

    You have now connected a sample .NET application to InterSystems IRIS and explored the various APIs available to interact with data in different ways.

• What's Next?

  What's Next?
  • Get started developing using .NET and InterSystems IRIS (exercise, 5m).
  • Explore multiple data models with globals (exercise, 10m).
  • Learn how to build a server-side application (learning path, 5h 30m).

  • Share Your Feedback!