{"id":2885,"date":"2017-11-23T10:31:41","date_gmt":"2017-11-23T10:31:41","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=2885"},"modified":"2017-11-28T03:48:16","modified_gmt":"2017-11-28T03:48:16","slug":"virtual-entity-new-way-of-integration-part-2","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=2885","title":{"rendered":"Virtual Entity \u2013 New way of integration Part 2"},"content":{"rendered":"

This is our second article regarding virtual entity, if you have not checked our earlier article, we will suggest you to check that first here<\/a>.
\nIn this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want to show into virtual entity, so let\u2019s get started!!
\nNavigate to Visual Studio and create ASP.NET Web Application project (File ->New -> select ASP.NET Web Application project under Web template<\/strong>)
\nNext select Empty template and make sure to select Web API under Add folders:
\n\"webapi1\"<\/a><\/p>\n

After that the first thing you need to do is to install NuGet package to get ODATA libraries, so you need to run following command under Package Manager Console (Tools->NuGet Package Manager -> Package Manager Console<\/strong>)<\/p>\n

\r\nInstall-Package Microsoft.AspNet.OData\r\n<\/pre>\n
And once it is installed, let\u2019s add our Employee class which will hold all properties for Employees under Models folder. We can properties based on our requirement but make sure there is should on provide which should match primary id property in Virtual Entity, so we need to define at least one GUID property which should act as a Key like following:
\n\"webapi2\"<\/a><\/p>\n
Now as we are not using Entity Framework, we need to define our data source class which will hold inline database for our Web APi, so let\u2019s add a new Employeedb class, we can create a new folder under our Web Api project, let\u2019s name it DB and add this class there. We need to add following code under this class:<\/p>\n
\r\nusing ODataWebAPI.Models;\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\n\r\nnamespace ODataWebAPI.DB\r\n{\r\n    public class Employeedb\r\n    {\r\n            private static Employeedb instance = null;\r\n            public static Employeedb Instance\r\n            {\r\n                get\r\n                {\r\n                    if (instance == null)\r\n                    {\r\n                        instance = new Employeedb();\r\n                    }\r\n                    return instance;\r\n                }\r\n            }\r\n            public List<Employee> Employees { get; set; }\r\n\r\n            private Employeedb()\r\n            {\r\n                this.Reset();\r\n                this.Initialize();\r\n            }\r\n            public void Reset()\r\n            {\r\n                this.Employees = new List<Employee>();\r\n\r\n            }\r\n            public void Initialize()\r\n            {\r\n                this.Employees.AddRange(new List<Employee>\r\n            {\r\n                new Employee()\r\n                {\r\n                    Empid = Guid.NewGuid(),\r\n                    EName = "Arnav",\r\n                    Department="Dynamics 365\/CRM"\r\n\r\n                },\r\n                new Employee()\r\n                {\r\n                    Empid = Guid.NewGuid(),\r\n                    EName = "Diksha",\r\n                    Department="Dynamics 365\/CRM"\r\n\r\n                },\r\n                new Employee()\r\n                {\r\n                    Empid = Guid.NewGuid(),\r\n                    EName = "Anil",\r\n                    Department = "Dynamics 365 Operation"\r\n                },\r\n                new Employee()\r\n                {\r\n                    Empid = Guid.NewGuid(),\r\n                    EName = "Sunil",\r\n                    Department = "Dynamics 365 Operation"\r\n                }\r\n            });\r\n            }\r\n        }\r\n    }\r\n<\/pre>\n
Now let\u2019s add controller for our Web Api, we are going to implement just one method Get in our controller, to add controller follow Right Click on Controller->Add->Controller<\/strong>.
\n\"webapi3\"<\/a><\/p>\n
Under add controller dialog select our employee class and click on Add.
\nDelete all existing code and just add following code:<\/p>\n
\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Data;\r\nusing System.Linq;\r\nusing System.Net;\r\nusing System.Net.Http;\r\nusing System.Web.Http;\r\nusing System.Web.Http.ModelBinding;\r\nusing System.Web.Http.OData;\r\nusing System.Web.Http.OData.Query;\r\nusing System.Web.Http.OData.Routing;\r\nusing ODataWebAPI.Models;\r\nusing Microsoft.Data.OData;\r\nusing ODataWebAPI.DB;\r\n\r\nnamespace ODataWebAPI.Controllers\r\n{\r\n    \/*\r\n    The WebApiConfig class may require additional changes to add a route for this controller. Merge these statements into the Register method of the WebApiConfig class as applicable. Note that OData URLs are case sensitive.\r\n\r\n    using System.Web.Http.OData.Builder;\r\n    using System.Web.Http.OData.Extensions;\r\n    using ODataWebAPI.Models;\r\n    ODataConventionModelBuilder builder = new ODataConventionModelBuilder();\r\n    builder.EntitySet<Employee>("Employees");\r\n    config.Routes.MapODataServiceRoute("odata", "odata", builder.GetEdmModel());\r\n    *\/\r\n    public class EmployeesController : ODataController\r\n    {\r\n        public IHttpActionResult Get()\r\n        {\r\n            return Ok(Employeedb.Instance.Employees.AsQueryable());\r\n        }\r\n    }\r\n}\r\n<\/pre>\n
Now finally we need to set routing for our Web Api, so let\u2019s add following code under our WebApiConfig.cs file.<\/p>\n
\r\nusing System;\r\nusing Microsoft.OData.Edm;\r\nusing System.Web.Http;\r\nusing System.Web.OData.Batch;\r\nusing System.Web.OData.Builder;\r\nusing System.Web.OData.Extensions;\r\nusing ODataWebAPI.Models;\r\n\r\nnamespace ODataWebAPI\r\n{\r\n    public static class WebApiConfig\r\n    {\r\n        public static void Register(HttpConfiguration config)\r\n        {\r\n            config.MapODataServiceRoute("odata", null, GetEdmModel());\r\n            config.Count().Filter().OrderBy().Expand().Select().MaxTop(null);\r\n            \/\/config.MapODataServiceRoute("odata", null, GetEdmModel(), new DefaultODataBatchHandler(GlobalConfiguration.DefaultServer));\r\n            config.EnsureInitialized();\r\n        }\r\n        private static IEdmModel GetEdmModel()\r\n        {\r\n            ODataConventionModelBuilder builder = new ODataConventionModelBuilder();\r\n            builder.Namespace = "Demos";\r\n            builder.ContainerName = "DefaultContainer";\r\n            builder.EntitySet<Employee>("Employees");\r\n\r\n            var edmModel = builder.GetEdmModel();\r\n            return edmModel;\r\n        }\r\n    }\r\n}\r\n<\/pre>\n
Now we are ready to build our project and deploy it to Azure, if you don\u2019t have Azure subscription, you can setup a quick Azure trial from here<\/a>
\nRight click on our project and select Publish under popup menu. We need to select Microsoft Azure App Service, click on Publish button, if you are new to Azure, you can access rich Azure resource here to get started<\/a>. If you are deploying to Azure for the first time it will ask you for signin use your windows Azure credentials. Once logged in, you can select your subscription, Resource Group, AppServicePlan and finally click on Create.
\n\"webapi4\"<\/a><\/p>\n
And once deployment is over make sure to browse below URL to get metadata and see if you are able to get it correctly.<\/p>\n
\r\nYourAzureURL\/$metadata\r\n<\/pre>\n
You should be able to see metadata like below:
\n\"virtual6\"<\/a>
\nKeep not of highlighted information. After that we can try to browse below URL to see if we are getting employees information correctly.<\/p>\n
\r\nYourAzureURL\/Employees\r\n<\/pre>\n
After that we can create Virtual Entity data source by navigating to Settings->Administration-> Virtual Entity Data sources<\/strong> and selecting OData V4 Data Provider<\/strong>.
\n\"virtual7\"<\/a>
\nAnd now we can create Employee Virtual Entity, using our virtual entity data source, like below:
\n\"virtual8\"<\/a><\/p>\n
Make sure to add External Name to every field based on our Web Api field. Finally we can add our field to view and after publish we should be able to see our Virtual Entity records like below:
\n\"virtual9\"<\/a><\/p>\n
You can access complete code for this OData Web Api from GitHub Here<\/a>.<\/p>\n
Reference Post: http:\/\/www.odata.org\/blog\/how-to-use-web-api-odata-to-build-an-odata-v4-service-without-entity-framework\/<\/p>\n
Stay Tuned for more Dynamics 365 Updates !!<\/p>\n","protected":false},"excerpt":{"rendered":"
This is our second article regarding virtual entity, if you have not checked our earlier article, we will suggest you to check that first here. In this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[491,21,402,492],"tags":[495,494,496,488,487,493],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2885"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2885"}],"version-history":[{"count":7,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2885\/revisions"}],"predecessor-version":[{"id":2910,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2885\/revisions\/2910"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}