How would this Linq query with Join be written as a Lambda?

entity-framework-6 lambda vb.net

Question

I am trying to learn how to do joins as lambdas and I have this linq query but cannot figure out how to do it as a lambda

From posts In db.be_Posts Join t In db.be_PostTag On posts.PostID 
Equals t.PostID Where t.Tag = tag Select posts.Title

The above Join works in LinqPad. And this is what I have so far as a lambda. I am also trying to put everything into the viewmodel. 

db.be_Posts.OrderByDescending(Function(x) x.DateCreated).Join(db.be_PostTag, 
Function(p) p.PostID, Function(t) t.PostID, Function(p, t).Select(Function(p1) 
New be_PostsViewModel
With {.Id =

I don't get an intellisense after .Id when I type either p, p1 or t. What am i doing wrong? Thank you

1
2
7/3/2017 12:45:54 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

This part looks very weird (intended or typo?) :

....Function(p, t).Select(Function(p1)...

Something like this should work as far as I can see :

db.be_Posts.
    OrderByDescending(Function(x) x.DateCreated).
    Join(db.be_PostTag, _
            Function(p) p.PostID, _
            Function(t) t.PostID, _
            Function(p, t) New be_PostsViewModel With 
                            {
                                .Id = p.PostID,
                                ....
                                ....
                            })

And your LINQ query syntax can be translated to method syntax like this :

db.be_Posts.
    Join(db.be_PostTag, _
            Function(p) p.PostID, _
            Function(t) t.PostID, _
            Function(p, t) p.Title)
4
7/24/2014 4:05:02 AM

Related Questions

Entityframework Join using lambdas and the join method

Generally i prefer the lambda syntax with LINQ, but ...Join... is one example where i prefer the query syntax - purely for readability....Nonetheless, here is the equivalent of your above query (i think, untested):...var query = db.Categories // source .Join(db.CategoryMaps, // target c => c.CategoryId, // FK ...
entity-framework join lambda
asked by RPM1984

Should I use lambda or LINQ for a multi-table join in Entity Framework 4.1?

You can use a lamda expression inside of the Include method with the newest version of Entity Framework. Then you can use a second select to get an extra layer deep into the relationship. ...var result = context.News.Include(x=>x.NewsCommunity.select(z=>z.Communities)).Where(...)
asp.net-mvc entity-framework lambda linq sql
asked by BZink

How can I build a LINQ IN clause query that also acts as a LIKE operator?

In order to fulfil your requirement about returning all items if none are specified, you need to check for the lists being empty. ...var brands = brandid.Split(',').Select(x => Int32.Parse(x)); var styles = bodystyleid.Split(',').Select(x => Int32.Parse(x)); var result = from c in car where (!brands.Any() || brands.Contains(c.brandid)...
entity-framework in-clause linq linq-to-entities sql-like
asked by Richard

Writing Join Query Using Linq In VB.net

On where condition you can not use Equals (Operator) like Join LINQ query. Here Equals is a method of object class so you can access using '.' e.g. ...employee.AncillaryId.Equals(iCompanyId)...And Also one more thing in Where condition for new line VB.net required '_'. ...e.g....From b In context.H_Table_B Join employee In context.Employe...
entity-framework join linq vb.net
asked by Jignesh Thakker

LINQ Query to inner join DbContext Entities to IQueryable

You shouldn't need to extract child relationships like this - EF does it for you:...public IQueryable<Service> ExtractServices(IQueryable<Event> events) { return events.SelectMany(e => e.Services).OrderBy(s => s.EventId); }
c# entity-framework linq
asked by PinnyM

LEFT JOIN or RIGHT JOIN using LINQ Entity-Framework

Updated for the error: ...You will need to create a new class with the required properties and return it.... var applicantList = (from app in context.APPLICANTs join a in context.Profiles on app.Profile_id equals a.PROFILE_ID into output from j in output.DefaultIfEmpty() ...
asp.net asp.net-mvc c# entity-framework linq
asked by cheedep

How to join two table from two different edmx using linq query

Update...As per your comment, EF wasn't able to parse a combined Expression tree across 2 different contexts....If the total number of records in the tables is relatively small, or if you can reduce the number of records in the join to a small number of rows (say < 100 each), then you can materialize the data (e.g. ....ToList() / .ToArray() / .AsEn...
edmx entity-framework linq
asked by StuartLC

How to make LEFT JOIN in Lambda LINQ expressions

And this is the more complicated way using lambda expressions to write it:...order.Items .GroupJoin ( productNonCriticalityList, i => i.ProductID, p => p.ProductID, (i, g) => new { i = i, g = g } ) .SelectMany ( temp => temp.g.DefaultIfEmpty(), (...
c# entity-framework linq
asked by Magnus

Linq Query With Multiple Joins Not Giving Correct Results

Using joins with LINQ method syntax is hard to read and error prone....Using joins with LINQ query syntax is better, but still error prone (you can join by the wrong key as you did) and does not give you information about join cardinality....The best for LINQ to Entities queries is to use navigation properties (as Gert Arnold suggested in the comme...
c# entity-framework entity-framework-6 linq
asked by Ivan Stoev

Write this SQL query to Entity Framework lambda expression or other way

So you have tables with ...Enquiries... and ...FollowUps.... Every ...Enquiry... has zero or more ...FollowUps..., every ...FollowUp... belongs to exactly one `Enquiry, using a foreign key: A straightforward one-to-many relation....If you'd followed the ...entity framework code first conventions,... you would have had classes like:...class Enquiry ...
c# entity-framework entity-framework-6 linq linq-to-sql
asked by Harald Coppoolse

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