zzz projects Entity Framework Core EF Core
Home Articles Knowledge Base Online Examples
  • Home
  • Articles
  • Knowledge Base
  • Online Examples

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...
c# entity-framework entity-framework-6 odata
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...
c# entity-framework entity-framework-6 odata
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...
asp.net-core asp.net-core-webapi entity-framework entity-framework-core odata
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 ...
automapper c# entity-framework-core odata
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...
.net-core c# entity-framework entity-framework-core odata
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: ...
asp.net-core c# entity-framework-core linq2db odata
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...
asp.net-core asp.net-core-2.1 asp.net-core-webapi entity-framework-core odata
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...
asp.net-core c# entity-framework-core odata
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...
asp.net-core c# entity-framework-core odata
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...
asp.net-core c# entity-framework-core odata
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...
asp.net-core c# entity-framework-core odata
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...
asp.net-core entity-framework-core odata relationship
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...
.net asp.net-core entity-framework-core odata
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...
asp.net-core automapper c# entity-framework-core odata
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"...
asp.net-core-webapi c# entity-framework-core odata
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...
asp.net-core automapper entity-framework-core json.net odata
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...
asp.net-core entity-framework-core odata postman
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...
.net asp.net c# entity-framework-core odata
asked by Timur Lemeshko

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!