Entity Framework Core - Knowledge Base (KB)
18 results in tag: odata
OData over a "View" of unioned data in Entity Framework
I'm developing an OData service which exposes a model created with Entity Framework 6. These entities are read only and are quite large to load. (Several gigabytes)...To accomplish this I'm using Microsoft.OData.EntityFrameworkProvider, (I'm not currentl...
asked by Kent
With OData and Entity Framework, can I load navigation properties without writing getter methods for each relation?
Assume we have two entities, ...Parent... and ...Child..., and ...Child... is a navigation property of ...Parent... (1:1 for the sake of this example). A particular parent's child can be fetched using this request: ...http://example.com/Parent(1)/Child...
asked by hingst
OData with EF Core / ASP.NET Core - Good or Bad?
I've read a lot about OData with EF Core / ASP.NET Core. It seems to me that everybody has an opinion on this and It's gotten a bit confusing, so at the risk of sounding dumb, I have a few questions:...Please note: ...! I'm NOT talking about the classic A...
asked by PaxForce
AutoMapper don't work with entity EF Core
I'm trying to get view from entity with fields that I specify at expandProperties with .ProjectTo(). Using .Net Core 2 + Ef Core + AutoMapper...There is entities:...public class LessonCatalog { public string Name { get; set; } public int? ImageId ...
asked by Дмитрий КраÑнов
.NET Core 2.1 and EF Framework 2.1
I'm trying to replace a web service that provides information to a mobile app via ODATA 4. The current application is using EF6 and works without error....I have subsequently built a NEW .NET Core 2.1.1, using EF 2.1 and Core Odata 7.0.1. Everything seems...
asked by Stewart Basterash
Aggregation with GROUP BY using AspNet Core OData and Entity Framework Core
Simple OData aggregation fails on Entity Framework Core (SQL Sever) and Asp.Net Core:...odata/file?$apply=groupby((FileType)) ...Due to inability to translate used GroupBy LINQ expression warning is issued:...Microsoft.EntityFrameworkCore.Query: Warning: ...
asked by xmichaelx
How to return indented json content from an OData controller in asp core web api?
I can retrieve intended json result from normal WebApi using following way.... services.AddMvc() .SetCompatibilityVersion(CompatibilityVersion.Version_2_1) .AddJsonOptions(x=> { x.SerializerSettings.Formatting = Ne...
asked by XPD
OData throws The query specified in the URI is not valid
The client is 3rd party, so I don't have access to that source. However, I have a well explained PDF with some sample of requests the client uses. In example, .../Customers?$filter=ID+eq+guid'1D225D75-A587-4AE4-BA9A-2224B2484EA5' /Customers?$filter=Code...
asked by Falcon
Can't apply $select when using ODataQueryOptions
I am trying to implement querying to Sql Server via EF Core and OData(7.1.0)....Action method looks like follows:...[HttpGet] public IEnumerable<UserInfoDto> Get(ODataQueryOptions ops) { return this.service.GetUserInfos(ops); } ...Service code:...pub...
asked by Andrew Kibalnikov
OData ASP.Net Core on GET with Id?
I'm trying to ...[EnableQuery]... on a route (User) with id as example if I do a :...GET /users/1?$expand=Character ...I'd like to get the User with Id 1 with its Character but currently it returns me null on the character :...{"character":null,"id":1,"us...
asked by Myerffoeg
is OData IQueryable async?
I'm developing an OData endpoint to return a list of items from a database....I'm returning an ...IQueryable... and letting the front end handling the querying / filtering / expanding / paging through the odata query options....Consider the following meth...
asked by bruno_cw
AspNet Core WebApi OData - Many to Many join tables
As is the recommended pattern in EF Core these days when you have a many to many join we do something like this:...Fluent API, many-to-many in Entity Framework Core...Having done that I'm faced with the issue as to how I go about exposing that in the ODat...
asked by War
$Expand does not work when i get one item
I prepare Odata API for mobile application, and i have a problem with $Expand. When i use this query everything works ok. ...Query: .../odata/forms?$expand=FormFields($expand=FormFieldRadios)&$filter=FormId eq 1...But when i use this query:....../odata/fo...
asked by Jan Mucha
Unable to map List<> navigational properties using OData, EF Core and AutoMapper
I'm currently writing an ASP .NET Core API utilizing OData for querying, and Entity Framework to talk to the database....I want to separate the domain objects from the DTOs sent to the user, so have also started to use AutoMapper to translate entity frame...
asked by Olorin
How to fix Odata with C# WebAPI .NET Core Entity Framework
I can retrieve all of the data but looks like OData is not working I'm using EFCore Entity Framework Web API. This is my reference for OData ...https://www.youtube.com/watch?v=ZCDWUBOJ5FU...Updated Model below...Return should be ...[ { "name"...
asked by Danil Ishutin
How to use AutoMapper to map OData enum string in json request dto to entity enum property
I am working on a new ASP.NET Core 3.1.1 API with Microsoft.AspNetCore.OData v 7.3.0, AutoMapper v9.0.0 and Microsoft.AspNetCore.Mvc.NewtonsoftJson v3.1.1...I am getting the following error when I make a POST to the Accounts endpoint using Postman v7.18.0...
asked by whiskytangofoxtrot
How to patch enumerables and guids with OData V4 Delta in Asp.Net.Core 3.1
I am working on a new ASP.NET Core 3.1 API using the Microsoft.AspNetCore.OData nuget v7.3.0 and Microsoft.EntityFrameworkCore v3.1.1...I am using Postman v7.21.0 to test the API....Everything seems to be working well GET and POST but with PATCH, I only s...
asked by whiskytangofoxtrot
Ef core Odata Many-to-many
I'm developing Asp .Net Core 2.2 application with ODATA. I have test application to reproduce the problem: I can't request ...linked entities with link table via ODATA... request....Request: /odata/Books?$expand=BookCategories...response error: ..."Messag...
asked by Timur Lemeshko