Entity Framework Core Select Property with multiple conditions

asp.net-core entity-framework-core linq

Question

I have this query in linq

var records = _context.Records.Select(r => new{
    r.Quantity,
    r.CreatedOn,
    r.Name,
    Group = // if(condition1) value1 | if(condition2) value2 | etc...
})

As you can see i want to be able to create an anonymous property based on many checks so i can use that property for grouping after.

The conditions are date constant date checks starting on CreatedOn date.

For example,

the first check would be

if(r.CreatedOn.TimeOfDay > r.CreatedOn.TimeOfDay.Add(TimeSpan.FromHours(1)) return 1 // 1st hour
if(r.CreatedOn.TimeOfDay > r.CreatedOn.TimeOfDay.Add(TimeSpan.FromHours(2)) return 2 // 2st hour
if(r.CreatedOn.TimeOfDay > r.CreatedOn.TimeOfDay.Add(TimeSpan.FromHours(3)) return 3 // 3st hour

... up to 8th hour
1
1
8/28/2019 11:48:30 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Have a separate method to do the logic for simplicity. Then use that in the Select statement.

private string GroupingLogic(string val1, strinv val2, ...)
{
    if(condition 1) return "group-1"
    else if(condition 2) return "group-2"
    else if(condition 3) return "group-3"
    else return "group-3"
}

var records = _context.Records.Select(r => new{
    r.Quantity,
    r.CreatedOn,
    r.Name,
    Group = GroupingLogic(r.CreateOn, r.AnyOtherValue)
})

Now in the next step you can use the Group for grouping.

1
8/28/2019 11:52:35 AM

Related Questions

Select multiple nested levels of child tables in Entity Framework Core

You can use the keyword ...ThenInclude... instead...e.g....var company = context.Companies .Include(co => co.Employees).ThenInclude(emp => emp.Employee_Car) .Include(co => co.Employees).ThenInclude(emp => emp.Employee_Country) .FirstOrDefault(co => co.companyID == companyID);
entity-framework-core
asked by devfric

Entity Framework Core - LINQ select over navigational properties creates invalid query

As I understand,There are no issue with entity framework code....Output of entity framework code.... But in Sql query [model] mentioned here is [SpeedingTickets] table created by entity framework. That table does not contain any column call [CarManufacturerId].That is the error.
c# entity-framework-core linq sql
asked by Nithila Shanmugananthan

Include after select not load navigation property in Entity Framework core

From the EF Core documentation - ...Loading Related Data... - ...Ignored includes... section (highlight is mine):...If you change the query so that it no longer returns instances of the entity type that ...the query began with..., then the include operators are ignored....This is different from EF6 where ...Include... works on the final query entit...
.net-core entity-framework entity-framework-core
asked by Ivan Stoev

Select specific properties from include ones in entity framework core

If I understand correctly, you don't want to load the ...Author... entity (because there is no way to load entity with just some non navigation properties populated)....Then the question is why did you specifically add ...Include(x => x.Author)... which is requesting EF to load the ...Author.... ...Include... / ...ThenInclude... methods support ...
entity-framework-core
asked by Ivan Stoev

Entity Framework Core: Dynamically build select list with navigational properties

You could do this with Expression.ListInit, here the ...TResult... must have an ...Add... instance method e.g. ...Dictionary<string, object>.... This could just work but I havent even compiled it. In any way this should give enough hint on how to build this the way you want....public Expression<Func<TSource, Dictionary<string, object>>> ToDynamicCo...
entity-framework entity-framework-core
asked by Ibrahim ben Salah

Multiple tenants with Entity Framework Core and SQL Server 2017 in ASP.NET Core application

Yea, it depends on your application....I'd go with 1. ...some tables (client defines on setup which one) must be shared between tenants, for example: it has common tables for users, groups, rights, user-settings, but separate for offers, prices, events...If you need tables for settings, user management, groups, rights, etc you should create a s...
asp.net-core entity-framework entity-framework-core sql-server sql-server-2017
asked by Razvan Dumitru

Entity Framework Core - Include Multiple Levels of a Property for a Collection

There are two overloads of ...ThenInclude..., one for the case the previous navigation property is a single entity, and another one for collections:...public static IIncludableQueryable<TEntity, TProperty> ThenInclude<TEntity, TPreviousProperty, TProperty>([NotNullAttribute] this IIncludableQueryable<TEntity, TPreviousProperty> source, [NotNullAttr...
c# entity-framework-core
asked by Alisson

Entity Framework Core: create a migration that merges multiple DbContexts (with multiple migrations)

In my opinion, you have to keep 3 default(old) contexts....Because: It's a very bad practice to merge 3 in 1 and retire their default contexts. ...all those 3 contexts have their APIs to play with their data, which APIs will make sure all data is well maintained and which APIs will make Code-First is real code-first, but not a Code-Once. ...if you ...
c# entity-framework-core entity-framework-core-2.2 entity-framework-core-migrations identityserver4
asked by Dongdong

Connect multiple Databases to .NET core project via Entity Framework Core

Create base context and including all settings into this, DBSET:...public abstract class BaseContext : DbContext { public BaseContext(DbContext options) : base(options) { } public DbSet<object> FirstDbSet { get; set; } ... } ...inherit from BaseContext for both DBs(Databases):...public class NavaContext : BaseContext { publi...
.net-core asp.net-core c# entity-framework-core
asked by Mojtaba Nava

LINQ - Entity Framework Core - SELECT most recent record, only if it matches another condition

I achieved it like this:...var pending = myContext.Records .GroupBy(t => t.Nodeid) .Select(grp => grp.OrderByDescending(t => t.Utctimestamp).First()) .Where(t => t.Status == "Pending");
entity-framework-core linq-to-entities
asked by Chris Halcrow

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow