Share this page!

Oleg Kyrylchuk Profile picture
Twitter logo
23 Dec, 14 tweets, 4 min read
LINQ query enhancements in EF Core 6.0 thread.

12 features with code samples.

Retweets are appreciated 😊

#dotnet6 #efcore6 #coding #devcommunity
Better support for GroupBy queries
String.Concat translation with 3 and 4 arguments
EF.Functions.FreeText supports binary columns
Translate ToString on SQLite
EF.Functions.Random
Improved SQL Server translation for IsNullOrWhitespace
Defining query for in-memory provider
Translate Substring with a single parameter
Split-queries for non-navigation collections
Remove last ORDER BY clause when joining for collection
Tag queries with the file name and line number
Changes to owned optional dependent handling
All samples published on my GitHub
github.com/okyrylchuk/dot…

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Oleg Kyrylchuk

Oleg Kyrylchuk Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @okyrylchuk

Oleg Kyrylchuk Profile picture
26 Dec
This year I've met on Twitter a lot of amazing folks πŸ™‚

Thank you for interacting with me to all in the circles and beyond 😊 Image
Circle 1
@BelloneDavide
@ppenza
@badamczewski01
@MarusykRoman
@gsferreira
@dustinmoris
@foo_fighter
@KatyCodesStuff
Circle 2
@ErikEJ
@cezary_piatek
@GozukaraFurkan
@Franc0Fernand0
@SajuShajil
@phorsight2020
@GriyoPikliz
@WalenciukC
@rahulpnath
@carlcod_es
@hypeartistmusic
@SabitK
@tckscz
@druzgala_marcin
@BuildItBusk
Read 5 tweets
Oleg Kyrylchuk Profile picture
25 Dec
EF Core 6.0 new features. 48 code samples.

The biggest thread of mine so far. With sub-threads. The last this year.

It took me almost two months to go through many new features in EF Core 6.

Retweets are appreciated 😊

#dotnet6 #efcore6 #coding #devcommunity Image
A new Unicode attribute
A new Precision attribute
Read 30 tweets
Oleg Kyrylchuk Profile picture
2 Nov
A big thread of new APIs in the .NET 6. 🧡

Retweets are appreciated ☺️

#dotnet6 #coding #devcommunity #programming
Reflection API for nullability information.
Reflection API for nested nullability information.
Read 20 tweets
Oleg Kyrylchuk Profile picture
5 Oct
A thread about LINQ improvements in .NET 6 🧡

As always, retweets are appreciated 😌

#dotnet6 #linq #coding #devcommunity
Override default value in '*OrDefault' methods.
New 'MinBy', 'MaxBy', 'DistinctBy', 'ExceptBy', 'IntersectBy', 'UnionBy' methods.
Read 8 tweets
Oleg Kyrylchuk Profile picture
26 Sep
All my tweets about C# 10 features in one thread. 🧡

Retweets are appreciated 😊

#dotnet #csharp #coding #devcommunity
Constant interpolated strings
Extended property patterns
Read 15 tweets
Oleg Kyrylchuk Profile picture
6 Sep
Self-contained apps are cool in #dotnet. You can bundle runtime and framework with the app. The downside is the size.

To resolve the size problem you can use app trimming.

.NET 5 introduces multiple options to trim the app.

1/4 🧡

#coding #devcommunity
The assembly-level trimming leaves only used assemblies in the app.

TrimMode=CopyUsed is default when using PublishTrimmed=true.

Result: 10.8 MB.

2/4
The member-level trimming is more aggressive. It removes types and members that are not used.

⚠️ It's an experimental feature. It's not ready for mainstream use.

Result: 2.58 MB.

3/4
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

Like this author's thread?

Get emails when @okyrylchuk has new unrolls!

Check out other threads from @okyrylchuk!

Read all threads by @okyrylchuk

:(