score:3
Accepted answer
not sure if i understood you correctly but this might be what you need:
dbcontext.cmscontent.where(r => r.cmscontents.any(t => t.id = someid))
Source: stackoverflow.com
Related Query
- LINQ Query that is able to identity a Row in a Junction Table with two variables - How to do it?
- How do I query a junction table
- linq - how do you do a query for items in one query source that are not in another one?
- How can I write the following code more elegantly using LINQ query syntax?
- How to dynamic add filters to a LINQ query against an Odata Source in C#
- How to get SQL query into LINQ form in C# code
- How can I code a Linq query to do an upward Include?
- How to join two table from two different edmx using linq query
- Linq Join Query - How to display new table in view MVC C#
- How to filter LINQ query by table column and get count
- How do you write a LINQ query that filters a sub table to a specific time period and sums the results of the sub table?
- Linq - EF : How to query a Junction table?
- How to include a table multiple times in Linq query
- How can I check the number of calls to the database in LINQ query when using .NET Core and Code First?
- How to integrate external list to raw sql query join as table in a linq raw sql query
- How do I determine the source of unpredictable LINQ query results?
- How to return values from a LINQ query and display them in a table using C#, ASP.NET MVC and Entity Framework
- How to select the max date from table in c# linq query
- How to query Link table based data in LINQ
- How to Select top (5) contributors group by Business type code in c# linq query
- how to fetch multiple table data in a single linq query and bind it to a autocomplete search model
- How can I code numerous MIN functions into one LINQ to DataSet query
- C# linq query- How to query on inner table with list of values
- How to code this LINQ query in a better way
- How to write aggregate query in LINQ reusing part of the select code
- How to execute code as a part of the LINQ query
- how to write a Linq query with a EF code first Many to Many relationship
- How to use LINQ query with DataGridView but a subset of table columns?
- How To Write Distance LINQ query i have Lat, Long in table with varchar type SQL Server
- How to get a strongly typed linq query of a data table and database
More Query from same tag
- how to get records from db having one common column values with another list?
- Get combined Expression<TDelegate> from IQueryable
- LINQ to SQL ForeignKeyReferenceAlreadyHasValueException error
- c# - Using LinQ to look for duplicate items in a list and updating object properties if so
- Using where in LINQ select new statement for specific columns
- Adding Key, Value XML Element using C#
- cancel update in datacontext = LInq
- What's the method based syntax equivalent of join into
- EF 4.1, database first and Many-to-Many relationships - How to get all sub-objects?
- Simple ASP.NET MVC SQL related question
- Efficiency and delayed execution of OrderBy
- LINQ, joining results of two methods
- Iterate through LINQ to SQL query containing COUNT and GROUP BY
- Get last value from child in xml
- Is there a LINQ equivalent for this code?
- How to add where condition to list?
- Entity Framework - loading entities by multiple navigation properties in one request
- making Linq case sensitive
- In operator using linq query
- How does IEnumerable<T>.ToArray() work?
- LINQ select first item from multi layer class
- SaveChanges() only affects one row
- EF Lambda include navigation properties
- C# Linq double groupby need min/max for hourly values once per day
- asp.net c# linq search List<object> tree
- LINQ Operations on Lambda Grouping
- Effective Validation with Linq + System.Data.Entity
- How to a List using LINQ Query?
- LINQ Get Latest Record from Multiple Records to List
- Return next 5 rows using LINQ in C# ASP.NET?