Linq Foreign Key Select

c# entity-framework-6 linq

Question

I have two tables with a one (Articles) to many (Details) relationship. Details may not contain any data for the particular Article entry.

Articles: Id, Title, Numb (PK), Name

Details: Id (PK), Person, Numb (FK), Name

In the Entity Framework, there are the appropriate Navigation properties and it shows the correct One:Many relationship.

What I want to do is get all Articles that match the end user's query (by 'Name') as well as all, if any, data from the Details table (Id, Person, Numb, Name).

What I'm stuck on is right now I can query Articles just fine (var article = db.Articles.Where(b => b.Name.Equals(name));), but while the result does include a HashSet for Details.Numb on each row of Articles, there is no data in that HashSet. There are appropriate corresponding entries in the database for Article.Numb => Details.Numb.

1
2
3/17/2015 3:03:46 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Actually there is two ways to achieve this.

  1. Enable Lazy Loading.
  2. Call Include method as other answers says.

Using Lazy Loading see msdn article for more detail.

    db.ContextOptions.LazyLoadingEnabled = true;

Using Include method

    var article = db.db.Articles.Include("Details").Where(b => b.Name.Equals(name))).FirstOrDefault();
1
3/17/2015 3:36:22 AM

Related Questions

EF does not generate foreign key association from foreign key in table

I have a table tblEvent and another table tblContact. There is a field ContactID in tblEvent that is linked by a foreign key to ContactID in tblContact. I've triple checked; the foreign key is in the database....The Entity Framework model DOES NOT generate a navigation property and foreign key association for it as it does for the other foreign k...
entity-framework
asked by rsteckly

Get foreign key table with a single query using LINQ

I have the following two tables...Groups - Id - Name Members - Id - GroupId - Name ...I want to display a list of Groups with their member count. I can get all the groups and then use a foreach statement to count the number of members. But this is very inefficient....Is there a way to write a LINQ query that will return the member count in a singl...
c# entity-framework linq
asked by James

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...On the Order table, there is a foreign key defined on the PersonId and CompanyId columns, th...
entity-framework entity-framework-6 insert
asked by WerkingWill

select from a list with field name and field value with linq (similar to select command)

I want to select from a dynamic list where the list field name is for example 'SecName'and the SecName value is equal to for example 'xxx', I know how to create it in sql, but I want to create and use it with entity framework. Like Executing String in sql. How can I make it in entity framework and linq. It should be something like this...var lst=_...
c# entity-framework-6 linq sql-server
asked by Hootan.Ghiasi

Entity Framework code-first set foreign key with primary key in same table

I have this ...WdUser... class inherited from ...SysModelBase...:...[Serializable] public class WdUser : SysDomainModelBase, IWdUser { [Display(Name = "UserName")] [MaxLength(25)] [Required] public string UserName { get; set; } [Required] [Index(IsUnique = true)] [MaxLength(25)] [Display(Name = "LoginName ")] pu...
asp.net c# entity-framework-6
asked by Autyan

Mapping foreign key to non primary surrogate key column in EF code first

public class A { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Aid { get; set; } public virtual ICollection<B> B { get; set; } } public class B { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Bid { get; set; } [Key] [Column(Order = 0)] ...
c# ef-code-first entity-framework entity-framework-6 foreign-keys
asked by user5419119

Delete the foreign key data when the data in the foreign table is deleted

I have 2 database tables, and I want when I delete a data in the table where the foreign key is pointing (where the primary key is), the foreign key pointing to that data also be deleted.... [HttpPost, ActionName("Delete")] [ValidateAntiForgeryToken] public async Task<ActionResult> DeleteConfirmed(int id) { Report report = a...
ado.net-entity-data-model asp.net-mvc entity-framework-6 linq linq-to-entities
asked by Arianit

Entity framework- EF Code First Select foreign key

Model:...public class Address { [Key] public long AddressId { get; set; } public string Street { get; set; } public string Town { get; set; } public string State { get; set; } public string Country { get; set; } } public class User { [Key] public long UserId { get; set; } public string UserName { get; set; }...
asp.net-mvc-5.2 entity-framework entity-framework-4 entity-framework-5 entity-framework-6
asked by jena malone

Mapping composite foreign key to composite primary key where the foreign key is also a primary key

I want to make VM_hostname,datetime and name properties as a composite Key for ...Disk class... . At the same time VM_hostname and datetime of ...Disk class... should refer to VM_hostname and datetime of ...VirtualMachine... class (ie Foreign keys) . ...I did this but it gives me this exception : The ForeignKeyAttribute on property 'datetime' on ty...
data-annotations entity-framework entity-framework-6
asked by NeuralLynx

Why does this linq query fail when I change the select clause to select new Model

Why does this query work:...var rooms = from m in db.Rooms where m.FK_HotelID == id select m; return View(rooms.ToList()); ...but this query (which I generated from a program called 'Linqer') seemingly fails?...var rooms = from m in db.Rooms where ...
ado.net-entity-data-model asp.net-mvc-5 c# entity-framework-6 linq
asked by salmanxk

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