Equivalent for .HasOptional in Entity Framework Core 1 (EF7)

by

You will not find an equivalent method in EF 7. By convention, a property whose CLR type can contain null will be configured as optional. So what decide if the relationship is optional or not is if the FK property is nullable or not respectively.

In summary, due to your Message_Id FK property is string, it already accepts null value, so if you use the following Fluent Api configuration:

modelBuilder.Entity<File>()
            .HasOne(s => s.Message)
            .WithMany()
            .HasForeignKey(e => e.Message_Id)

EF will configure your relationship as optional (or N : 0..1 as requested).

In case of your FK property is value type like int, you should declare it as nullable (int?).

Also I noticed now you have a navigation property with internal access modifier. You should always declare your entity properties as public.

More Related Contents:

  1. EF Core Second level ThenInclude missworks
  2. No executable found matching command “dotnet-ef”
  3. Loop/reflect through all properties in all EF Models to set Column Type
  4. EntityFramework Core automatic migrations
  5. Using EF Core ThenInclude() on Junction tables
  6. Changes in IDENTITY column after EF core 3
  7. What goes into DbContextOptions when invoking a new DbContext?
  8. How to instantiate a DbContext in EF Core
  9. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  10. Filter all queries (trying to achieve soft delete)
  11. Entity framework core update many to many
  12. How to add the same column to all entities in EF Core?
  13. Command dotnet ef not found
  14. Dynamically changing schema in Entity Framework Core
  15. How to unapply a migration in ASP.NET Core with EF Core
  16. ef core 2 apply HasQueryFilter for all entity
  17. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  18. Entity framework EF.Functions.Like vs string.Contains
  19. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  20. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  21. Cannot find command ‘dotnet ef’
  22. How to publish environment specific appsettings in .Net core app?
  23. How to get user information in DbContext using Net Core
  24. How should I manage DbContext Lifetime in MVC Core?
  25. Implementing recursive property loading in EF Core
  26. Entity Framework Core 2.0 – Run migrations step by step
  27. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  28. EF Core 2: How to apply HasQueryFilter for all entities
  29. Cascading deletes with Entity Framework – Related entities deleted by EF
  30. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]

Leave a Comment