how to include a column from a second table in my LINQ query

c# entity-framework entity-framework-6 linq-to-sql

Question

ZZZ_tmp
1
1
1/13/2019 6:40:08 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

ZZZ_tmp
2
1/13/2019 6:47:11 AM

Popular Answer

public object GetAd(long currentUser, long adId)
{
    return from a in Context.Favourite
           where a.UserId  == currentUser
           select new {
                      flag = a.AdId != null
                      a.FavouriteId,
                      //etc
                      };
}
CodeMan

Related Questions

Invalid column name when including child collection navigation property involving 2 joins to the same table

I created a repository GetList method that effectively handles the majority of navigational properties. However, when I attempt to include a specific navigation property that is based on a group of entities, it fails....the subsequent domain classes that include many-to-many relationships...[Table("Template")] public class Template : LoggedEntity {...
c# entity-framework entity-framework-6
asked by Kirsten Greed

Entity Framework Include related table when table is empty

I'm reading data from a database into the datasource of a gridview. I can have my Table2 empty. I get an error saying that Table2 doesn't include that column when I attempt to bind columns from it. I examined the information being returned by the query. Table 2 exists, but columns are absent. Simply Count: 0...How can I access related table columns...
.net c# entity-framework entity-framework-6 entity-framework-6.1
asked by TurKorsaN

How to retrieve child data, via LINQ Include, in one query, to improve performance?

ZZZ_tmp
entity-framework entity-framework-6 linq linq-to-entities
asked by SamJolly

Entity Framework not including columns with default value in insert into query

ZZZ_tmp
c# entity-framework entity-framework-core
asked by bubi

EFCore Linq ThenInclude Two Foreign Keys To Same Table

ZZZ_tmp
asp.net-core c# entity-framework-core linq-to-entities
asked by Gert Arnold

EFCore Linq ThenInclude Two Foreign Keys To Same Table

ZZZ_tmp
asp.net-core c# entity-framework-core linq-to-entities
asked by Gert Arnold

Select only specific columns from included table in Entity Framework Core

ZZZ_tmp
entity-framework entity-framework-core
asked by Mathias Rönnlund

How to refer two tables, using a column in another table - Entity Framework

ZZZ_tmp
.net asp.net entity-framework entity-framework-6 sql-server
asked by David Browne - Microsoft

Is there any difference in performance between these two LINQ to SQL queries?

ZZZ_tmp
c# entity-framework-core linq
asked by ManishM

I need query LINQ and C# core 3.1 with Include and ThenInclude

ZZZ_tmp
c# ef-core-3.0 entity-framework-core linq
asked by lukaG96

Need some help on a Linq query, 3rd level include where

ZZZ_tmp
blazor c# entity-framework-core linq
asked by Tjopsta

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