score:1
Accepted answer
var id_posts = from p in db.posts
join hp in db.have_privacy on p.id_post equals hp.id_post
join prv in db.privacy on hp.id_privacidade equals prv.id_privacidade
where prv.nome = 'private'
select p.texto;
score:0
var id_posts = from p in db.posts
join hp in db.have_privacy on p.id_post equals hp.id_post
join prv in db.privacy on hp.id_privacidade equals prv.id_privacidade
where prv.nome = 'private'
select p.texto;
Source: stackoverflow.com
Related Query
- ASP.NET MVC 5 - LINQ Query to Select Data from Database
- how to fetch data from database using linq query for relationship 1:N and N:N (between 3 entity) in asp.net mvc EF code first?
- How to query database using LINQ to bring data from database based on array of months in ASP.Net MVC 5?
- LINQ query performance issue when fetching data from db in MVC Razor
- Linq query how to select last one week data from today's date
- LINQ - database query using "into", how do I reference data prior to "into" in the select clause?
- Linq query to get data from Database using group by clause
- Select data from different object in linq query
- Linq query to select next id from a database table
- How to get data from linq query using select
- Get data from database using linq query and display it in dynamically generated labels in repeater
- Linq query to select data from table and join 2 tables
- Why can't I select data from my LINQ sub query join?
- How to read data from a nested select query linq
- Select data from tow table using LINQ in Asp Core razor pages
- Using a LINQ query to populate a combo box with data from an access database
- How to write a linq query to select data from two table?
- How to write linq query to match SQL like select top 100 * from tab?
- linq select from database where ID in an ArrayList
- Linq to select data from one table not in other table
- Dynamically build select list from linq to entities query
- LINQ to SQL: Complicated query with aggregate data for a report from multiple tables for an ordering system
- Retrieving Data from database within the last 7 days using linq
- Dynamic LINQ query to get Field value from Database
- .net MVC passing linq data from controller to view
- LINQ Query to insert data into the database
- Which LINQ query to select rows from 1 table that are not in another table
- LINQ EF Join query from 2 different data context
- LINQ Query Issues when trying to select from empty collection
- how delete more than one record from database using Linq in asp.net mvc
More Query from same tag
- Linq / Entity Framework - how to group by date with range
- Maintaining order when selecting a static group from a table
- Is this overusing extension methods?
- Proper LINQ syntax to order Ienumerable based on value in Icollection
- Counting Using Group By Linq
- Linq to sql - Join 2 tables, select 1 row from right table with a 1 to many relationship
- How to extract record from 10 to 20
- A two way KeyValuePair collection in C#
- Group by Dynamic Aggregate
- C# Linq to Group to a list if a Condition meets else do not group
- Linq - Limit list to 1 row per unique values based on value (minimum) of single field
- Entity Framework - Select specific columns and return strongly typed without losing cast
- sorting when name includes letters and numeric digits
- C# Linq add element to list of object where condition is met
- How to find items in a superset that are not in a subset
- Matching 2 lists in Linq to Entities
- How to get value of element with XDocument and Linq to XML
- How to extend LinqKit and use a custom method within a linq query?
- Compare two list in C# and reject or select the child list based on conditions using LINQ or foreach
- How to solve "The method 'Skip' is only supported for sorted input in LINQ to Entities."
- Cost of assigning a variable
- Dynamic Linq Where with Lambda Expression generates Error
- Use '1,2,3,4,5'.Contains(ID int) in LINQ?
- FInding sum of values in a column for each identical other columns in a list
- How to use LINQ to XML to output " to an XML file
- The specified type member 'TimeBandDescription' is not supported in LINQ to Entities
- Adding a default SelectListItem
- how to get this data via linq
- When to use lambda expressions instead of a Where clause in LINQ
- mvc fill dropdownlist