Entity Framework Core - Knowledge Base (KB)
20 results for: in tag: navigation-properties
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
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
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
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 select on IQueryable throwing "must be reducible node"
I have this query where predicate is ...Expression<Func<Property, bool>>... and the whole query returns an ...IQueryable...:...var query = _db.PropertyRepository.Get(predicate) .Include(x => x.Info) .ThenInclude(x => x.Addres...
asked by monica
EF Core Collection Load .. of a Collection
Using EF Core 1.1.0...I have a model that has collections that themselves have collections....public class A { public string Ay {get;set;} public List<B> Bees {get;set;} } public class B { public string Be {get;set;} public List<C> Seas {ge...
asked by imukai
Shadow Properties to access related entity with Table-Per-Hierarchy inheritance model
I'm building a menu system for a website in ASP.Net Core. Let's assume I have a couple of database tables, one for ...Pages... and one for ...Articles..., although it only really matters that they are different entities. Each of them have a ...Name... and...
asked by Ashley Bye
navigation property should be virtual - not required in ef core?
As I remember in EF ...navigation property should be virtual...:...public class Blog { public int BlogId { get; set; } public string Name { get; set; } public string Url { get; set; } public string Tags { get; set; } publi...
asked by Alexan
Entity Framework Core: private or protected navigation properties
Is it somehow possible to define navigation properties in EFCore with private or protected access level to make this kind of code work:...class Model { public int Id { get; set; } virtual protected ICollection<ChildModel> childs { get; set; } }
asked by silent_coder
Entity framework core: How to test navigation propery loading when use in-memory datastore
There is an interesting feature exists in entity framework core: ...Entity Framework Core will automatically fix-up navigation properties to any other entities that were previously loaded into the context instance. So even if you don't explicitly incl...
asked by silent_coder
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
Foreign key reference object is returning null
I am referencing the ...AbpUser... table in an entity with the following property definition:...[ForeignKey("LocationManagerId")] public virtual User LocationManager { get; set; } public virtual long LocationManagerId { get; protected set; } ...My DTO is ...
asked by Jonas Vachal
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
ef core ignore navigation property
I have an entity ...User... that has two properties ...CreatedBy... and ...UpdatedBy... both referencing ...User.... By default, EF assumes that these two as a one to one relation to each other. I get the following error message: ...Message: System.Invali...
asked by Neville Nazerane
Included property returns object that it's included to
I'm working on my side project with is a WebAPI in ASP.NET Core 2.1. I'm using Entity Framework Core 2.1....I have a User:...public class User : Account { public UInt64 UserEmail { get; protected set; } public UserImage UserImage { get; set; } ...
asked by MadTiger2409
Conditional navigation properties in Entity Framework Core
I'm trying to create a navigation property in EF Core that would setup its reference conditionally based off the values of two properties. I'm not sure if this is even possible. ...Let me show you an example: let's say I have a hierarchical structure of e...
asked by RobotJones
EF core navigation property not loading
I'm modifying my application to be able to specify navigation properties to load in the repository....Model: Team and TeamTunerUser can be found in the ...domain entites.......Repository:...namespace Sppd.TeamTuner.Infrastructure.DataAccess.EF.Repositorie...
asked by Philippe
Error in getting navigation property in a many to many relationship in entity framework core
I have two entities that are connected in a many to many relationship as follows...public class Fee { public int Id { get; set; } [Required] public string Label { get; set; } public string Description { get; set; } ----Ignored for brev...
asked by Josh
Page 1 of 1