Questions tagged [entity-framework-core]
Entity Framework (EF) Core is a lightweight, extensible, and cross-platform version of the popular Entity Framework data access technology.
45 questions
5
votes
2
answers
270
views
Sorting and filtering using dynamic parameters
I have this code which I am upgrading to .NET 8.
The intention is to sort and filter the resultset using the parameters. Right now it has a lot of if else and redundant code inside the blocks.
I would ...
- 155
3
votes
1
answer
893
views
Recursively load all navigation properties of an entity
I have a table representing a class hierarchy using the TPH model.
Some of those sub classes have navigation properties (collections and/or references).
I'm trying to preload them as I know I will ...
- 195
2
votes
0
answers
49
views
Efficient code to move a node under another while keeping all HierarchyId's as integers and sequential
I'm playing around with an app that will need to read Hierarchy trees quickly but will seldom modify them once created. I've chosen to use HierarchyIds with Entity Framework to model the hierarchy. I ...
- 21
0
votes
1
answer
625
views
Mapping Entity Database Table to Model
I am not sure of the correct way to do this.
I want to separate my Entity database model from the model I use throughout my application, as it will have fields in it that I may not want added to the ...
- 103
2
votes
0
answers
5k
views
Optimizing a EF Core "upsert" operation
I'm trying to "optimize" the command below. In other words, to make it suit my needs using best practices. I found a lot of posts regarding the "upsert" operation and there were a ...
- 819
0
votes
1
answer
91
views
EF Core code-first "many-to-many-to-many" (Books with many credits with many people)
Let's say you have a book. A book can have an author, an editor, a proof reader, or several other credits. Which credits are available should be dynamic (someone might not want to have the "proof ...
- 141
2
votes
1
answer
2k
views
.Net Core 6.0 : Entity Framework - Either Or / Neither Nor / Both in Where clause
I am building a .Net Core 6.0 application that uses Entity Framework.
I have situation where I need to apply the filter(Where clause) based on two properties (eg: Guid? skillType, string skillName). ...
- 189
1
vote
1
answer
2k
views
Is it optimal way to filter records from table using Entity Framework?
I have the SQL Products table migrated from MongoDb and I use ASP Core + MediatR. The filtering data comes from frontend ...
- 113
-1
votes
2
answers
158
views
Using default implementations to superpower flags enums with C# [closed]
I would like to share this post with the community since at first glance it is very promising. Storing flags in the database is something that I have been interested in doing for a while since it ...
- 199
3
votes
2
answers
233
views
RawSqlQuery minimizing risk of field name confusion
Is there a way to make the following code more maintainable?
...
- 443
3
votes
1
answer
372
views
EFCore Monitor Interceptor with logging queries
I created a SqlMonitorInterceptor that will check the execution time of queries and log errors. The main idea is to log queries in such a way that they can be easily copied into SQL Server Management ...
- 889
4
votes
2
answers
149
views
Get a list of the 25 most popular items on an E-Commerce site
I have a few lines where I am trying to get a list of the 25 most popular Items sold on an E-Commerce web site. The code works but I would like hints on how to optimize it.
...
- 527
1
vote
2
answers
164
views
Finding items involving a particular category
I have a Item Service that is Called from an Asp.Net Core API Controller. The query gets all items in a particular category for display on an eCommerce web site (reactjs). The controller only returns ...
- 527
1
vote
2
answers
760
views
0
votes
1
answer
158
views
How do I optimize my GetChildren method
UPDATED
I have a POCO class that is populated with _context.Categories.Load():
...
- 527