To complete this walkthrough, you will need:

• Microsoft Dynamics NAV 2017 with a developer license.
  
• CRONUS International Ltd. demonstration database.
  
• Visual Studio 2012 or Visual Studio 2010. You can use any edition of Visual Studio that supports adding web references. In this walkthrough, you will use Visual Studio 2012. You also have the option to use service references instead of web references, or use the web service proxy generating tools svcutil.exe and wsdl.exe, which are included in the Microsoft .NET Framework SDK.
  

1. Open the RoleTailored client and connect to the CRONUS International Ltd. company.

2. In the Search box, enter Web services, and then choose the related link.

3. In the Web Services page, on the Home tab, choose New.

4. In the Object Type column, select Page. In the Object ID column, enter 21, and in the Service Name column, enter Customer.

5. Select the check box in the Published column.

6. Choose the OK button.

1. Start Internet Explorer.

2. In the Address field, enter a URI in this format: http://<Server>:<WebServicePort>/<ServerInstance>/OData. For example:

   http://localhost:7048/DynamicsNAV/OData

   1. Server is the name of the computer that is running Microsoft Dynamics NAV Server.
      
   2. WebServicePort is the port that OData is running on. The default port is 7048.
      

   ServiceInstance is the name of the Microsoft Dynamics NAV Server instance for your solution. The default name is DynamicsNAV90.

   For example, if the Microsoft Dynamics NAV Server is running on the computer that you are working on, then you can use: http://localhost:7048/DynamicsNAV/OData/

   The browser should now show the web service that you have published, in the format of an AtomPub document.

   

1. In Visual Studio, on the File menu, point to New, and then choose Project.

2. Expand the Installed node, expand the Templates node, expand the Visual C# node, chose Windows, and then choose Console Application. Enter the name NAVCustomers for the application.

3. Choose the OK button to exit the New Project page.

4. In the Solution Explorer pane, right-click References, and then choose Add Service Reference.

5. In the Address field, enter the URI for your OData web service, such as http://localhost:7048/DynamicsNAV/OData/.

   Security Note
   In this example, we use the HTTP protocol to illustrate the use of OData web services. We recommend that you use the more secure HTTPS protocol when you consume web services.

6. Choose Go, and then, in the Services field, choose NAV, and then choose the OK button.

The project is created, and your OData web service is added as a service reference. Next, you add the code that will show a list of existing customers, add a customer and then rename the new customer.

1. Add the following using statement after the namespaces that are automatically added to your project:

   	Copy Code
   using NAVCustomers.ServiceReference1;

2. After the Main method, add the following method:

   	Copy Code
   private static void PrintCustomersCalledCust(NAV nav) { var customers = from c in nav.Customer where c.Name.StartsWith("Cust") select c; Boolean customerFound = false; foreach (Customer customer in customers) { customerFound = true; Console.WriteLine("No.: {0} Name: {1}", customer.No, customer.Name); } if (!customerFound) { Console.WriteLine("There are no customers that start with 'Cust'."); } }

   The PrintCustomersCalledCust method reads the OData web service that you created, Customer, and creates a list of customers where the customer name begins with the letters Cust. Next, you add code to the Main method that uses the web service to write to Microsoft Dynamics NAV.

3. In the Main method, add the following code to establish the connection to Microsoft Dynamics NAV through the web service:

   	Copy Code
   NAV nav = new NAV(new Uri("http://localhost:7048/DynamicsNAV/OData/Company('CRONUS%20International%20Ltd.')")); nav.Credentials = CredentialCache.DefaultNetworkCredentials;

   In the example, the name of the Microsoft Dynamics NAV company that you modify data for is CRONUS International Ltd.. You must replace this with the name of the company that you have access to. To find the correct URI, you can paste the following URI into your browser and then see the exact URI that you must use: http://localhost:7048/DynamicsNAV/OData/Company.

4. Add the following code to the method:

   Copy Code

   Console.WriteLine("Printing list of current customers:"); PrintCustomersCalledCust(nav); Console.WriteLine("Adding new customer."); Customer newCustomer = new Customer(); newCustomer.Name = "Customer Name"; nav.AddToCustomer(newCustomer); nav.SaveChanges(); Console.WriteLine("Printing list of current customers:"); PrintCustomersCalledCust(nav); newCustomer.Name += "Changed"; nav.UpdateObject(newCustomer); nav.SaveChanges(); Console.WriteLine("Printing list of current customers:"); PrintCustomersCalledCust(nav);

   In this code, a customer is created and then renamed. The code prints a list of the customers that currently exist in the Customer table when each change has been made.

5. Build and run the project.

1. Open the Microsoft Dynamics NAV Windows client or the Microsoft Dynamics NAV Web client.

2. Open the list of customers, filter for a customer with the name Customer NameChanged.

   This is the customer that the console application created and modified.