Why does "IQueryable.Where()" provide different results than "IEnumerable.Where()" in this query?

Different results from [ForeignKey] attribute vs. OnModelCreating or EntityTypeConfiguration

It appears that your mapping is incorrect....You have a navigation property because...Group... It must be added in the mapping in the following manner:...modelBuilder.Entity<Person>() .HasOptional(t => t.Group) .WithMany(t => t.People) // <--- .HasForeignKey(t => t.GroupId); ...If not, EF will construct a new foreign key and utilize the...

why i cannot await 'System.Linq.IQueryable

ZZZ_tmp

Entity framework IQueryable extension methods do not work as a sub query

Where possible, I try to use extension methods when writing my queries. As a result, the following is a query that I can use:...int studentId = ( from u in db.Users .FromOrganisation(org.Id) .IsStudent() .IsActive() where u.ExtId == dto.StudentExtId select u.Id ).FirstOrDefault();...

EF Core join entity IQueryable with id IQueryable

ZZZ_tmp

Entityframework 6.2.0 IQueryable.Count VS IQueryable.ToList().Count

ZZZ_tmp

Why are queries that modify database data awaitable, while queries that only read data not?

ZZZ_tmp

Why can't I filter an IQueryable like I can with a List?

ZZZ_tmp

IEnumerable from DBContext vs IEnumerable from code Memory usage

ZZZ_tmp

IQueryable WHERE inside a for loop does not produce expected result

ZZZ_tmp

IQueryable vs IEnumerable - how many DB calls?

ZZZ_tmp