KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am at a loss with the following query, which is peanuts in plain T-SQL. We have three physical tables: Band (PK=BandId) MusicStyle (PK=MuicStyleId) BandMusicStyle (PK=BandId+MusicStyleId, FK=BandId, MusicStyleId) Now what I'm trying to do is get a list of MusicStyles that are linked to a Band which contains a certain searchstring in it's name. The bandname should be in the result aswell. The T-SQL would be something like this: SELECT b.Name, m.ID, m.Name, m.Description FROM Band b INNER JOIN BandMusicStyle bm on b.BandId = bm.BandId INNER JOIN MusicStyle m on bm.MusicStyleId = m.MusicStyleId WHERE b.Name like '%@searchstring%' How would I write this in Linq To Entities? PS: StackOverflow does not allow a search on the string 'many to many' for some bizar reason...
Tags (comma-separated)
Save Edits
Cancel