Entity Framework 6 - Knowledge Base (KB)
20 results in tag: navigation-properties
Navigation properties from Entity Framework TPH classes are included.
I've got an EF hierarchy that (dramatically simplified) looks something like this:...class Room { EntityCollection<Session> Sessions; } class Session { EntityCollection<Whiteboard> Whiteboards; EntityReference Room; } class Whiteboard { EntityCollection<W...
asked by Ken Smith
Selective Condition on Included Navigation Property in Entity Framework
Assume I have these simplified EF generated entities......public class PurchaseOrder { public int POID {get;set;} public int OrderID {get;set;} public int VendorID {get;set;} public IEnumerable<Order> Orders {get;set;} } public class ...
asked by ctorx
. Skip(). SELECT * on my SQL Server is being executed by Take() on Entity Framework Navigation Properties.
I have a method on my generated partial class like this:...var pChildren = this.Children .Skip(skipRelated) .Take(takeRelated) .ToList(); ...When I look at my SQL Server, I can see the generated code is doing a ...SELECT *.* FROM Children... T...
asked by Nate
How to include all underlying navigation properties automatically with entity framework
Scenario: I'd like to add an entity to the database that would have navigation properties and ...that... entity has navigation properties.. and so on. Basically the tables in the database are connected with each other - all of them....I use EF4.3 and cont...
asked by JahManCan
EF5 How to get list of navigation properties for a domain object
I'm working on an EF 5 Code-First solution and I am trying to update an existing entity with a modified one using the Repository pattern:... public void UpdateValues(T originalEntity, T modifiedEntity) { _uow.Context.Entry(originalEntity).C...
asked by Adolfo Perez
Entity Framework - Include / Reference / Collection
I was wondering why there are separate methods for populating navigation properties....If I work on an entire set, i can call ...Include... on either a property or a collection....However, if I work on a single entity, there are two separate methods to ca...
asked by Simon
EF codefirst : Should I initialize navigation properties?
I had seen some books(e.g ...programming entity framework code first Julia Lerman...) define their domain classes (POCO) with no initialization of the navigation properties like:...public class User { public int Id { get; set; } public string User...
asked by Iman Mahmoudinasab
EF6 Code First Entity with navigation property collection of same type - how do I tell EF what the relationship is?
I dont quite understand EF so please bear with me as I try to trudge through my ignorance and confusion. I have one restriction, I cannot change the database structure....TBLGRADES...GRADEID GUID (PK) | GRADETITLE VARCHAR --------------...
asked by user3215462
What is the best way to set navigation property having only id in Entity Framework?
I have the next enitities:...public class MyEntity { public virtual int Id { get; set; } public virtual MySecondEntity SecondEntity { get; set; } } public class MySecondEntity { public virtual int Id { get; set; } ... some properties h...
asked by Alexander Vasilyev
Entity framework Navigation Properties
I am currently trying to develop my first .NET MVC application and so learning the main concepts....In my application I have a table that displays a list of animals from an animals table. In the table I am also trying to display the animal breed, but I am...
asked by user2437588
How can you add a navigation property on a view in EF 6.1 CodeFirst
Let's make a case to explain my problem. ...MyTable1...+id...+myTable2Id...MyTable2...+id...MyView1...+id...+myTable2Id...MyView1 exists in the case, from data from the MyTable1. Now i want to create a Navigation property from my EF6.1 Code first approach...
asked by Spons
Not Exists using Linq
sorry for my english, I'll try to be short and concise....I have to tables "ALUMNOS" and "MATERIAS". In SQL exist another table "ALUMNOS BY MATERIAS". I know this is not necessary in EF because exists the properties navigation, but I need to get the ALUMN...
asked by Guille
Why Navigation Properties are virtual by default in EF
I have following POCO class being used in EF 6.x....My question...: Why is the navigation property of 'Posts' under 'Blog' entity declared as virtual?...public class Blog { public int BlogId { get; set; } public string Name { get; set; } ...
asked by Sunil
Prevent EF6 from generate navigation properties
I've recently started to use EF6 and i'm building a couple of T4 templates to generate some code automatically (on VS2012)....I'm generating my model from the database and this process creates all the associations automatically based on the DB ForeignKeys...
asked by Flavio Oliveira
EF SqlQuery with navigation properties
I want call sp in t-sql from EF 6. At the same time i want load data to navigation property. On sql server side my SP Joins 2 table and returns. But EF side dont bind navigation properties....My query code loads car data but when i want reach Engine.Name ...
asked by user1924375
OData and WebAPI: Navigation property not present on model
I'm trying to put together a simple toy project using Entity Framework, WebAPI, OData, and an Angular client. Everything is working fine, except the navigation property that I have put on one of my models doesn't seem to be working. When I call my API usi...
asked by MWinstead
An object of type cannot be set or removed from the Value property of an EntityReference of type
I'm trying to add an object to a navigation property of an entity but I keep getting this exception....System.InvalidOperationException An object of type 'System.Collections.ObjectModel.Collection`1[[WakeSocial.BusinessProcess.Core.Domain.UserDevice, Wake...
asked by Joel Dean
Entity Framework will only save navigation properties for new entities, not updates
I tried loading the navigation properties first by using ...Include..., and I ensured that the children were loaded. ...For new items, I can add a child navigation set with no issues. For updated items, I tried to pass in a completely new collection to ov...
asked by Dinerdo
How to work with Navigation Property and non-standard keys?
Assume I have following database tables with 1:1 mapping...Table dbo.Foo with PrimaryKey FooRowId Table dbo.Bar with PrimaryKey BarRowId ...No foreign keys exist on either table....Using EF, I defined models as follows....Modeling Foo table...public class...
asked by SamDevx
When declaring relationship is not necessary in Entity Framework 6?
In EF6 we have two ways to declare relationship between two tables:...Annotations Attributes...Fluent API...Today (by accident) I removed one relationship between two tables and everything kept working well. I was very surprised because there was no way E...
asked by Ish Thomas
