Search icon CANCEL
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Extending Microsoft Dynamics NAV 2016 Cookbook

You're reading from  Extending Microsoft Dynamics NAV 2016 Cookbook

Product type Book
Published in Jan 2017
Publisher Packt
ISBN-13 9781786460608
Pages 458 pages
Edition 1st Edition
Languages
Author (1):
Alexander Drogin Alexander Drogin
Profile icon Alexander Drogin

Table of Contents (17) Chapters

Extending Microsoft Dynamics NAV 2016 Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
1. Writing Basic C/AL Code 2. Advanced C/AL Development 3. Reporting and Data Analysis 4. .NET Interoperability in C/AL 5. Extending C/AL with COM Components 6. SharePoint Integration 7. Control Add-ins 8. Web Services 9. Events and Extension Packages 10. PowerShell

Querying NAV OData web services with LINQ


Language Integrated Query (LINQ) is an extremely convenient interface for writing SQL queries in .NET languages. SQL-like queries are integrated in the .NET syntax, so that the developer can write application code and database queries in a unified way instead of injecting database interaction statements in text constants.

The System.Linq library allows access to different data sources, including OData service interfaces.

How to do it...

Now we will walk through receiving data from a NAV page with a LINQ query.

  1. Publish page 42 Sales Order as a web service. Refer to the Exposing and consuming OData web services recipe for a step-by-step description of OData service publishing. Assign the name SalesOrder to the new service.

  2. In Visual Studio, start a Console Application project: NAVSalesOrdersWebService.

  3. Open the Add Service Reference dialog. Run service discovery on http:// localhost:7048/DynamicsNAV90 /OData/

  4. Select the service NAV in the list of discovered...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}