LINQ - query for pair values

Hi allanau20;

The following should give you what you want.

var myPost = (from bp in db.Posts
              where bp.PostID == postId
              select new
              {
                  bp.PostTitle,
                  tags = (from p in bp.PostTagPairs 
                          select new 
                          { 
                              TagName = p.PostTag.TagName, 
                              PostTagID = p.PostTag.PostTagID
                          }).ToList() 
              }).SingleOrDefault();

foreach( var pt in myPost.tags )
{
    Console.WriteLine("The TagName is : {0} The PostTagID is : {1}", pt.TagName, pt.PostTagID);
}

Select allOpen in new window

thanks guys; let me try it now and get back to you...

Hi FernandoSoto,

Got this error:

{"LINQ to Entities does not recognize the method 'System.Collections.Generic.List`1[<>f__AnonymousType0`2[System.String,System.Int32]] ToList[<>f__AnonymousType0`2](System.Collections.Generic.IEnumerable`1[<>f__AnonymousType0`2[System.String,System.Int32]])' method, and this method cannot be translated into a store expression."}


Any ideas?

Hi jyparask,

looks like it doesn't recognize temp:

any ideas?

Try this one

            var query = from t in PostTags
                        join pt in PostTagPairs
                        on t.PostTagId equals pt.PostTagId into
                        select new
                        {
                               p.PostTitle,
                               t.TagName
                        };

Giannis

PS what is your environment?

sorry Giannis.

This is razor on MVC3 with EF 4.1, .net 4.0; i'll try it now.

Hi Giannis.

for this --->  p.PostTitle,

I don't see where p (Posts) is defined?
also, would like to pull PostTagID (along with TagName). thx!

Do you use temp somewhere else in your code? Try renaming temp on my initial post to something else.

Hey,  it says tenp. This is a misspell. Change the error to temp.

Giannis

Thanks. I'm on the road. I'll try it again in 4hrs.

Thanks FernandoSoto; that works.

I'll want to try out yparask solution if you don't mind. thx.

Hi,

If you like, you may also check an article i wrote for joining in LINQ, that has just been published.

https://www.experts-exchange.com/Programming/Languages/.NET/LINQ/A_11369-Joining-in-LINQ.html

If you wish feel free to leave a comment.

Giannis

Thanks Giannis your solution would work too.
I guess if I wanted to PostTitle (outside the for loop) I cannot get to it like this?
var Title = query.PostTitle

Anyways, appreciate your help and will provide comment to your article later this week.

Not a problem allanau20, glad I could help.