How to know whether a property stored in DbEntityEntry is a property`?

c# entity-framework entity-framework-6

Question

In Entity Framework 6 within an DbEntityEntry certain information can be retrieved by calling Property. However, this fails with an ArgumentException when the property is not a property but a collection or reference. Than other functions must be used.

How can I know which function to call? That is, how can I know of what type (simple property, complex property, reference, collection) the property is?

For DbEntityEntry see https://msdn.microsoft.com/en-us/library/system.data.entity.infrastructure.dbentityentry%28v=vs.113%29.aspx

I am using Entity Framework 6.1.3 in Visual Studio 2013.

1
2
5/8/2015 4:24:26 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

DbEntityEntry.Member(string) returns a DbMemberEntry, which you can check with (memberEntry is DbPropertyEntry).

2
5/14/2015 12:31:58 AM

Popular Answer

I have find how to get if the navigation property is collection type or not. For this, we need to get BuiltInTypeKind of the property.

I am using this code for getting all navigation properties of the entity:

var entitySetElementType = ((IObjectContextAdapter)context).ObjectContext.CreateObjectSet<TEntity>().EntitySet.ElementType;
var navProperties = entitySetElementType.NavigationProperties;

Then, we can know if th navigation property is collection or not:

foreach (var navigationProperty in entiySetElementType.NavigationProperties)
{
      var builtInType = navigationProperty.TypeUsage.EdmType.BuiltInTypeKind;
      var isCollection = builtInType == System.Data.Metadata.Edm.BuiltInTypeKind.CollectionKind
                      || builtInType == System.Data.Metadata.Edm.BuiltInTypeKind.CollectionType;
}

UPDATE

Since EF has been moved to a separate assembly & namespace, the System.Data.Metadata.Edm.BuiltInTypeKind.CollectionKind in above code should be changed to System.Data.Entity.Core.Metadata.Edm.BuiltInTypeKind.CollectionKind.

Farhad Jabiyev

Related Questions

How to avoid Lazy Loading when accessing foreign key ID property through navigation property?

Nope, you'll need to add them as property in your class (that is; if you want it strong typed) like this to access it directly....public class User { public int ID { get; set; } public string FullName { get; set; } //added ID public int OrganizationID { get; set; } public virtual Organization Organization { get; set; } ...
c# ef-code-first entity-framework entity-framework-6
asked by Stefan

Entity Framework will only set related entity property to "null" if I first get the property

As a workaround, the easiest way I've found to mitigate this issue is to have the setter call the getter ...before... setting the backing field to null, e.g....public class Foo { public int? Id { get; set; } private Bar _bar; public virtual Bar { get { return _bar; } set { var entityFrameworkH...
c# entity-framework entity-framework-6
asked by Nathan

After upgrade to EF6 - The property cannot be configured as a navigation property

I had the same problem. I removed ...InverseProperty... attributes and the problem solved. Hope it helps.
asp.net-mvc-5 entity-framework entity-framework-6
asked by Mahmoodvcs

EF: The property 'Street' is not a declared property on type 'Address'

Your Street property is immutable, it has to have a setter for your code to work. Currently, you don't have a setter defined on Street and that's why you are getting the error.
c# entity-framework entity-framework-6
asked by sachin

EntityEntry.Property() throws InvalidOperationException when property does exist

The problem is that ...Property... method supports only primitive properties while you are calling it with navigation property....You can use ER Core metadata services accessible via ...EntityEntry.Metadata... property which returns ...IEntityType.... In your case, the ...FindProperty... method, although you should really use ...GetProperties... in...
.net-core asp.net-core c# entity-framework entity-framework-core
asked by Ivan Stoev

Should I define `foreign key Id` property in addition to the corresponding `navigation property`?

I found a partial answer for my question in this page:...http://www.learnentityframeworkcore.com/conventions...Foreign Key Shadow Properties:... If you choose not to explicitly include a foreign key property in the dependant end of the relationship, EF Core will create a shadow property using the pattern Id....But I still do not know if this is t...
.net .net-core c# entity-framework entity-framework-core
asked by Mohammed Noureldin

GetEntityTypes: configure entity properties using the generic version of .Property<TEntity> in EF Core

What about, in your context, adding something like this... public override int SaveChanges() { AddTimestamps(); return base.SaveChanges(); } public override async Task<int> SaveChangesAsync(bool acceptAllChangesOnSuccess, CancellationToken cancellationToken = default(CancellationToken)) { AddTimestamps();...
c# ef-core-2.0 entity-framework entity-framework-core
asked by nicecatch

EF core: cannot insert object with foreign key using ID properties (only navigation properties work)

I've finally found the problem. To reproduce (at least with NpgSql):...using (var db = new TestContext()) { // This works: db.Groups.Add(new Group { Id = 42, }); db.Identities.Add(new Identity { Id = 666, }); db.SaveChanges(); db.Memberships.Add(new Membership { GroupId = 42, IdentityId...
c# entity-framework-core
asked by Paolo Tedesco

Access a Class (dbcontext) Property Dynamically by Property Name

Since these classes have exactly same fields, you can create ...a common class... as the base class to store the fields. ...In my example, there are three tables (tb1, tb2, tb3) and a base class (...tbBase...),the base class is not related to database:... public class tbBase { public int Id { get; set; } public string Description { get; set...
asp.net-core c# entity-framework-core
asked by Yongqing Yu

replace a returned property with another property from a different model linking by Id

If you don't already, you should have a navigation property on your ...Character... class like:...public SpiritAnimal SpiritAnimal { get; set; } ...Then, when you make your query, you should include this relationship, so it's joined in the same query:...var characters = await _context.Character.Include(x => x.SpiritAnimal).ToListAsync(); ...As you'...
asp.net-core asp.net-core-3.0 asp.net-core-webapi entity-framework-core
asked by Chris Pratt

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