OData
Create and consume RESTful APIs in a simple and standard way
Latest posts
Aggregation extensions in OData ASP.NET Core
$select and $filter, as well as other OData query options, are an excellent way to receive only data that you need. However, they might not be the best option for reporting and analytical applications. If you want to get total sales to the particular customer and using only $select and $filter, you end up selecting all orders for that customer and doing aggregation client-side. This approach means sending a lot of data over the network. If you need to show sales by region, product category, you have to send almost all the data. Fortunately, OData v4.0 specification includes an aggregation extensions which allo...
OData Connected Service 0.9.0 Release
OData Connected Service 0.9.0 has been released and is now available on Visual Studio Marketplace. This release adds the following features and bug fixes:  You can get the extension from Visual Studio Marketplace
OData Connected Service v0.8.0 Release
OData Connected Service 0.8.0 has been released and is now available on the Visual Studio Marketplace. The new version adds the following features: There instances where you want to re-use same configuration settings across multiple projects. Manually supplying the same settings every time you spin up a new project is redundant. This feature enables one to load code generation values to the OData Connected Service wizard from a json file. This means that you can either type these values or you can load them from a json file. To use this feature: Create a new json file...
Move OData to .NET 5
Introduction Along with the Announcing .NET 5 preview 1, it’s time to move OData to .NET 5. This blog is intended to describe how easy to move the BookStore sample introduced in ASP.NET Core OData now Available onto .NET 5. Let's get started. Install .NET 5 .NET 5 SDK is required to build the .NET 5 application. So, Let’s follow up the instructions in Announcing .NET 5 preview 1 to install the .NET 5 SDK. Meanwhile, I also install the Visual Studio 2019 Preview to edit and compile the .NET 5 project. It's easy to download Visual Studio 2019 Preview from here. The required VS version supporting .NET 5 is...
OData Connected Service 0.7.1 Release
We are pleased to announce a new release of OData Connected Service, version 0.7.1. This version adds the following important features and bug fixes: You can get the extension from the Visual Studio Marketplace. 1. VB.NET Support You can now use OData Connected Service extension to generate OData client code for Visual Basic projects. The features supported in C# are also supported in VB.NET projects. Let’s create a simple VB.NET project to demonstrate how it works. Open Visual Studio and create a VB .NET Core Console App. When the new project is ready, right-click the project node fr...
OData Connected Service version 0.6.0 Release
OData Connected Service 0.6.0 has been released and is available in the Visual Studio Marketplace. The new version adds the following features: Custom Http Headers This feature allows you to add headers that will be sent with the request that fetches the metadata used in generating proxy files. This is actually important when using protected metadata to generate proxy files. To access the metadata endpoint, you may be required to pass authorization headers as shown below. These values are not stored within the OData Connected Service or in your computer and you are required to provide them a...
OData Connected Service version 0.5.0 Release
OData Connected Service 0.5.0 has been released and is available in the Visual Studio Marketplace. The new version has the following new features: In addition to the above features, the new version has the following improvements and fixes: Microsoft.OData.Client v7.6.3 OData Connected Service version 0.5.0 comes with Microsoft.OData.Client v7.6.3 which has great improvements: Some of the improvements are:Â Supports Mocking of the generated functions and properties The generated methods and properties can be mocked for purposes of tes...
OData Connected Service 0.4.0 Release
OData Connected Service 0.4.0 has been released and is now available on the Visual Studio Marketplace. The new version adds the following features: In this article, I would like to take you through some key new features and get you up to speed with using the OData Connected Service. OData Connected Service in Visual Studio 2019 We start by illustrating how you can use the extension in Visual Studio 2019. Open Visual Studio 2019 and create a new C# .Net Core Console project. Let’s call the project "SampleClient", and the solution "OCSTest". Once the project is open, click the Extensions menu,...
Migrating OData V3 Services to OData V4 without Disrupting Existing Clients
The migration from your existing OData V3 services to V4 can be challenging if there are some clients that cannot be easily upgraded, like the ones running on on-premises resources. The OData V3 services will need to be kept running until the old clients have been phased out, incurring maintenance overhead. OData team recently released an extension to overcome the challenge. This extension eases the transitioning by enabling OData V4 services to serve OData V3 requests. The advantage is that no changes are needed on the OData V3 clients while the OData V3 services are migrated to OData V4. In this article, I a...