LINQ: Using a ternary ( ?: ) with LINQ let is not enough, need an "IF" but can't seem to get it to work

entity-framework linq

Question

I am trying to include an IF within my LET in LINQ but i can't get it to work, it seems to work for the ternary operator, but this is TRUE or FALSE and i need to have more than 2 options.

I think this explains it well

Basically i have a select which selects items using joins from a DB. Then the i get the status for each record but i have to make a join on separate tables depending on the type from products.type

var tst = from p in products join i in info on p.id equals i.pid

// if p.type = "home" then ...

let status = from s in homestatus
select new { status = s.status }

// if p.type ="offshore" then


let status = from s in offshorestatus
select new { status = s.status }


// if p.type ="internal" then


let status = from s in internalestatus
select new { status = s.status }

select new {
name = p.name,
status = status.StatusText
}

Anybody have any ideas how to do a standard IF so i can select which STATUS (let) i wish to execute.

Thanks in advance

1
2
6/14/2012 9:10:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You can do that with the conditional operator (1)

var tst = from p in products join i in info on p.id equals i.pid

let status = p.type = "home" ? homestatus.Select(s=>s.status) :
             p.type = "offshore" ? offshorestatus.Select(s=>s.status) :
             p.type = "internal" ? internalestatus.Select(s=>s.status) : null
select new {
name = p.name,
status = status != null ? status.StatusText : string.Empty;
}

If you are not using the status for anything else than the StatusText you could also do it like this

var tst = from p in products join i in info on p.id equals i.pid

let status = (p.type = "home" ? homestatus.Select(s=>s.status.StatusText) :
             p.type = "offshore" ? offshorestatus.Select(s=>s.status.StatusText) :
             p.type = "internal" ? internalestatus.Select(s=>s.status.StatusText) : null) ?? string.Empty
select new {
name = p.name,
status = status;
}

(1) A ternary operator is any operator that takes three arguments, of which there at present is only one in C# called the conditional operator

9
6/14/2012 9:18:06 AM

Related Questions

The method 'System' is not recognized by LINQ to Entities. Linq.IQueryable

When I try to call my repository in a Sub Select, I got this error.... IGrpTextRepository rep = new GrpTextRepository(); var query = new DetailViewModel { ViewDet = (from gh in _db.Grp select new MultiDetailViewModel { Header = gh, ...
c# entity-framework
asked by Jean-Francois

"LINQ to Entities does not support the LINQ expression node type 'Invoke'" - perplexed!

In my EF later, I'm trying to pass in an anonymous function to be used as part of my Linq query. The function would pass in an INT and return a BOOL (u.RelationTypeId is an INT). Below is a simplified version of my function:...public IEnumerable<UserBandRelation> GetBandRelationsByUser(Func<int, bool> relation) { using (var ctx = new OpenGroove...
asp.net c# entity-framework linq linq-to-entities
asked by Ryan Peters

The ArrayIndex LINQ expression node type is not supported in LINQ to Entities.

public List<string> GetpathsById(List<long> id) { long[] aa = id.ToArray(); long x; List<string> paths = new List<string>(); for (int i = 0; i < id.Count; i++) { x = id[i]; Presentation press = context.Presentations.Where(m => m.PresId == aa[i]).FirstOrDefault(); paths.Add(press.FilePath); } r...
arrays c# entity-framework linq linq-to-entities
asked by Artur Keyan

The LINQ expression node type 'Invoke' is not supported in the entity framework's LINQ to Entities.

can anyone help me out in solving my issue. I am using the code given below:...public IEnumerable<InvoiceHeader> Getdata(Expression<Func<InvoiceHeader, bool>> predicate) { return AccountsContext.InvoiceHeaders.Include("Company").Include("Currency") .Include("BusinessPartnerRoleList").Include("DocumentType") .Where(predicate); } ...
c# entity-framework expression linq predicate
asked by zaheer abbas

LINQ-To-Entity (LINQ to Entities does not support the given type member ".)

I am having difficulty understanding this problem:...Here is the T-SQL query I need to implement using LINQ to Entities...select r.ReviewID, b.BusinessID, b.Name as BusinessName ,r.Description from gb_business.Review r inner join gb_business.Business b on r.BusinessID = b.BusinessID inner join gb_listing.RegionalService rs on b.BusinessID = rs.Busi...
c# entity-framework lambda linq-to-entities
asked by itisinteresting

LINQ to Entities does not recognize the method 'System.Linq.IQueryable`

I want to run this LINQ simple code to have record number in LINQ but result is beneath error...var model = _db2.Persons.Select( (x, index) => new { rn = index + 1, col1 = x.Id }).ToList(); ...Error:...LINQ to Entities does not recognize the method 'System.Linq.IQueryable...1[<>f__AnonymousType2...2 [System.Int3...
.net c# entity-framework linq
asked by ehsan

Error on Cout but i am not using Count in my LINQ exrpression,

I am trying to return a set of data in JSON formate from a LINQ select ran against my EF Code First DB and am getting the error...Count must be a DbConstantExpression or a DbParameterReferenceExpression. Parameter name: count ...but I am not sure why I am getting it as I am not using a ...COUNT... parameter in my LINQ query so why am I getting this...
asp.net-mvc-5 c# entity-framework-6 linq-to-entities
asked by Matthew Verstraete

rowVersion gets mapped to byte[8] in Entityframe work but when manually casting it's byte[18]

I am getting ...rowVersion... from database as ...byte[8]...var rowVersion= new MyContext().Employee.FirstOrDefault(x => x.Id).rowVersion; // suppose above the actual databse values is 0x0000000000038B8C var rowVersionToLong = BitConverter.ToInt64(rowVersion,0); ...Now if i manually do this:...String rowversionStr = "0x0000000000038B8C"; byte[] myb...
c#-4.0 entity-framework-6 rowversion
asked by InTheWorldOfCodingApplications

Getting error "The parameter was not bound in the specified LINQ to Entities query expression."

I am trying to create a generic way to find deals that have a date that fall within a list of user-specified date ranges. Here's my code:...var closeDates = new List<Range<DateTime>> {{ new Range<DateTime>{ Start = DateTime.Now, End = DateTime.Now.AddDays(1) }}; var deals = dbContext.Deals.AsQueryable(); deals = _helperService.ApplyDateRanges(...
c# entity-framework entity-framework-6 linq linq-to-entities
asked by adam0101

LINQ Query to LINQ Method; Why do I need CBool?

When I started using Entity Framework, I used Query Syntax as I was more used to using SQL than Method. Now I understand how to use Method, so I'm converting some of my older LINQ Query's to Method as I find that Method makes more sense from a programming perspective....My question is, why does the compiler want me to use CBool() around some where ...
entity-framework-6 lambda linq vb.net
asked by Kayot

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