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

It seems to work for the ternary operator, but this is TRUE or FALSE and I need to have more than 2 alternatives. I'm attempting to incorporate an IF inside my LET in LINQ but I can't get it to work.

I believe this clarifies it.

I basically have a select that pulls objects from a database using joins. Then, based on the kind of items, I get the status for each record, but I must connect data from many databases. 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
}

Anyone have suggestions on how to implement a standard IF so I can choose which STATUS (let) I want to run?

I appreciate you.

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

That is possible using 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;
}

You could also do it this way if you are just utilizing the status for the StatusText.

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) There is currently just one ternary operator in C#, which is the conditional operator. It accepts three inputs.

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

Related Questions

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

I received this problem while attempting to use my repository in a Sub Select.... 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!

I'm attempting to send an anonymous function into my EF later so it can be utilized in my Linq query. The procedure would take an INT as input and output a BOOL (u.RelationTypeId is an INT). A condensed description of my role is given below:...public IEnumerable<UserBandRelation> GetBandRelationsByUser(Func<int, bool> relation) { using (var ctx...
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 somebody assist me in resolving my problem? I'm use the code 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'm having trouble comprehending this issue:...Here is the T-SQL query I must use LINQ to Entities to implement....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.BusinessID ...
c# entity-framework lambda linq-to-entities
asked by itisinteresting

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

I want to execute this basic LINQ code to create a record number in LINQ, however the outcome is below 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 ...
.net c# entity-framework linq
asked by ehsan

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

I am getting the problem when attempting to return a set of data in JSON format from a LINQ select executed against my EF Code First DB....Count must be a DbConstantExpression or a DbParameterReferenceExpression. Parameter name: count ...however, as I am not using a, I'm not sure why I'm getting it....COUNT... Why am I getting this problem when the...
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]

ZZZ_tmp
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'm attempting to develop a general method for discovering deals whose dates fall within a range of dates that the user has selected. Below is 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.Ap...
c# entity-framework entity-framework-6 linq linq-to-entities
asked by adam0101

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

ZZZ_tmp
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