Dick Baker

the docs relate to an app doing var allblogs=ctx.Blogs.Include("Posts").OrderBy(b=>b.BlogId).ToList() and the Blogs columns would be repeated in the non-split case[you are correct] I was thinking about the orthogonal [as you...

I still think sticking a WHERE clause is justified so devs see gen'ed code [imho it doesn't distract any more than the OrderBy clause] I haven't enabled logging [to see...

what about that "Post"->"Posts" promise in #4051 that Uncle Arthur approved? that GH page still shows "Post". Maybe its still in the pipeline and yet to reach the spotlight? https://github.com/dotnet/EntityFramework.Docs/blob/main/entity-framework/core/querying/single-split-queries.md#split-queries-1...

DISTINCT ... in the case that I raised arising from var allposts=ctx.Posts.Include("Blog").OrderBy(p=>p.PostId).ToList() where you have [say] 1 Blogs row and 2 child Posts the 2nd split would surely surface parent...

back on the subject of plural/singular table names [often argued by zealots to wee small hours, usually involving beer] we are talking about "Post" vs "Posts" [I have always favoured...

Having agreed with the PostTag usage found here https://github.com/dotnet/EntityFramework.Docs/blob/main/entity-framework/core/modeling/relationships.md I now find a rival "PostTags" usage here https://github.com/dotnet/EntityFramework.Docs/blob/main/samples/core/Modeling/Relationships/FluentAPI/ManyToManyShared.cs?name=ManyToManyShared so I urge you to ensure consistent message. BTW I have found...

@roji, yes the fixture means 1-off, but propose guideline to devs to employ static ctor anyway in their own code. I agree heavy impact, but EnsureCreated should be quick if...

The "DELETE FROM [Blogs] WHERE 1=1;" clause is required on SQL Server (which is what the sample is for) please explain why this is necessary. Are you sure MSSQL doesn't...

weird! Trying to repro your experience I have just tried my SSMS apps v17.9.1 [aka 14..0.17289.0] v18.12.1 [aka 15.0.18424.0] v19.0 Preview 3 [aka 16.0.19061.0 and [outdated] ADS v1.32.0 (user setup)...

update .. I tried SO that mentioned AWS Redshift but no help to us here I have now found these gems that suggests this is a JetBrains client-side "help" https://intellij-support.jetbrains.com/hc/en-us/community/posts/4410218655122-delete-without-where-not-possible...