Implementing Foreign Keys using EF. #4477

4 Answer(s)

• 

  0

  ismcagdas created 7 years ago

  Support Team

  Hi @sparkyjr,

  I assume it needs to act like you said. Can you share your related code ? By the way, you are using EF 6.x, right ?

  Save Cancel
• 

  0

  sparkyjr created 7 years ago

  Yes I am using EF 6.0.

  The following is my code snippet: I am setting LazyLoadingEnabled to false in DbContext.

  public ABXDbContext()
              : base("Default")
          {
              Configuration.LazyLoadingEnabled = false;
          }
  
          public ABXDbContext(string nameOrConnectionString)
              : base(nameOrConnectionString)
          {
              Configuration.LazyLoadingEnabled = false;
          }
  

  Here are my entities with virtual removed:

  public class CascadeLevel : FullAuditedEntity, IMustHaveTenant
      {
          [Required]
          public int TenantId { get; set; }
          [Required]
          [MaxLength(100)]
          public string Name { get; set; }
          [Required]
          public int Level { get; set; }
          public ICollection<CascadeLevelType> CascadeLevelTypes { get; set; }
      }
  
  public class CascadeLevelType : FullAuditedEntity, IMustHaveTenant
      {
          [Required]
          public int TenantId { get; set; }
          [Required]
          public int CascadeLevelId { get; set; }
          public CascadeLevel CascadeLevelData { get; set; }
          [Required]
          [MaxLength(100)]
          public string Name { get; set; }
          [MaxLength(500)]
          public string Description { get; set; }
          public string IconClass { get; set; }
          public string AssociationId { get; set; }   //Gaurav(1)
          public ICollection<CascadeLevelTypeLabelValueRelation> CascadeLevelTypeLabelValueRelations { get; set; }
          public ICollection<CascadeLevelTypeKPIRelation> CascadeLevelTypeKPIRelations { get; set; }
          public ICollection<Initiative> Initiatives { get; set; }
      }
  
  
  private readonly IRepository<CascadeLevel> _cascadeLevelRepository;
  private readonly IRepository<CascadeLevelType> _cascadeLevelTypeRepository;
  
   public async Task<GetCascadeLevelsDto> GetAllCascadeLevels()
          {
              GetCascadeLevelsDto cascadeLevelsDto = new GetCascadeLevelsDto();
              var allCascadeLevels = await _cascadeLevelRepository.GetAllListAsync();
              var allCascadeLevelTypes = await _cascadeLevelTypeRepository.GetAllListAsync();
  

  

  Save Cancel
• 

  0

  aaron created 7 years ago

  Support Team

  Is your breakpoint on the foreach statement?

  Since you have executed _cascadeLevelTypeRepository.GetAllListAsync(), EF fills the collection property for you.

  Try putting the breakpoint on that statement instead. The collection property should be null.

  Save Cancel
• 

  0

  alper created 7 years ago

  Support Team

  hi,

  if you declare it non-virtual : Your property will (by default) be loaded right away along with all the other property in your main entity. This means your property will be ready to access : it has already been retreived. Entity won't have to query again the database because you access this property.

  <a class="postlink" href="https://stackoverflow.com/a/41881389/1767482">https://stackoverflow.com/a/41881389/1767482</a>

  Save Cancel