Entity Framework Core 8: Improved JSON, queryable collections , and more…

Entity Framework Core 8: Improved JSON, queryable collections , and more… | .NET Conf 2023

Рет қаралды 37,375

Күн бұрын

Пікірлер: 42

@davidmarron109 10 ай бұрын

I wasn't sure this would be worth 38 minutes of my life, but this is definitely worth it. Relational DBs solved a huge subset of problems, Doc DBs solved a different subset, and now you've taken a huge step towards merging both. This is important work you've done.

@MrStupiuno 10 ай бұрын

I love the new inline primitive array support that works without any config!

@clouddeveloper4549 10 ай бұрын

Well done! Solving real world problems and doing it in an elegant yet powerful way!

@kabal911 10 ай бұрын

The best ORM in any language just keeps getting better ❤

@ShakeelAhmed-xo3xz 10 ай бұрын

Wonderful new features, I have been using EF/EF Core for many years, but this video surprised me and my future work and projects shall benefit from this knowledge. Thanks you both.

@aqualinespirit90 10 ай бұрын

17:20 , this is really good, currently have to use predicates for that, glad it's been added to EF8.

@dvanrooyen1434 10 ай бұрын

Hey guys - before we had table params we used that hack of using xml to pass in lists, - its not a new technique...

@IndigoDalliance 8 ай бұрын

Wow! Stunning! So glad I didn't miss this video.

@Joooooooooooosh 9 ай бұрын

Unfortunately anything with JSON arrays can't be effectively indexed. Most of these queries will perform terribly on any large tables.

@derDooFi 10 ай бұрын

i love these guys! wish this were longer, lol

@maxd5661 10 ай бұрын

We have similar code running on SQL Server in production without EF (using direct SQL) and performance on larger data sets (few hundred thousand records) is terrible. Stay away from this on SQL Server if you are at all concerned about performance. SQL Server at its core is very behind the curve on native array and document support. This should work great on PostgreSQL though!

@OggVorbis69 9 ай бұрын

Yeah, it is cool to write the query but performance is always an issue when the volume comes.

@Joooooooooooosh 9 ай бұрын

Exactly. So much work was put into a feature that is pretty much an antipattern in the real world.

@maxd5661 9 ай бұрын

@@Joooooooooooosh I mean at least it will actually work well on PostgreSQL. Maybe when SQL Server catches up to 2023 with native array and document support this will be a thing, but until then, this is a total waste of time of the EF team.

@keinegutennamen 10 ай бұрын

Definitely one of my favorite talks.

@jaiderariza1292 3 ай бұрын

@ajcvickers I wonder how we can handle discriminator with json, example if address in UK may have different format that address in US and we use like interface (IAddress) or base abstract class , silly sample but I wonder if this can be achieve by the new EF core json support?

@asdasdaa7063 6 ай бұрын

I love these guys so much, Microsoft's best speakers! Thanks for this love EF core!

@GregMontoya1 10 ай бұрын

Automatically converting a .NET primitive array to a JSON formatted array as a parameter for a query is pretty nice. Now I won't have to do this manually.

@jeremyflowers8908 9 ай бұрын

Why are you guys not using CTEs or top instead of first for consistency when working with JSON (I'm presuming you are borrowing from Observables)? Also where are you storing the metadata to know what the composition of the JSON columns are within the database?

@janakaaravinda2507 9 ай бұрын

This is amazing thank you..

@goodstas 9 ай бұрын

Thank you for this video. Great features. Could you provide the code of your presentation, please?

@zapaneer 10 ай бұрын

Cool stuff. The section about collections of simple datatypes being mapped as JSON, does that apply to the Postgresql variant as well or does it natively support the Postgresql implementation of arrays (which I believe would be more efficient)? Maybe it is a question for the NPGSQL guys...

@zapaneer 10 ай бұрын

Sry, It got answered later on by Shay

@tarsisf8173 10 ай бұрын

Fantastic job!

@onlyice 10 ай бұрын

Brilliant presentation.

@gustavnilsson6597 10 ай бұрын

You guys are rockstars!!

@SchattenPV 7 ай бұрын

Can you please give me a link to the video you mentioned @22:05? I'm very interested about the join aspect because we have some perf problems in our app with this topic

@HikingUtah 8 ай бұрын

What version of SQL Server first supported keywords such as OPENJSON? This is my first time hearing about it.

@milada424 10 ай бұрын

this is awesome, great work thank you !

@gunnarliljas8459 10 ай бұрын

Cool, but just mentioning "perf" so briefly kind of falsely gives the impression that this JSON support is usable in anything but extremely small databases. It isn't. The JSON_VALUE thing can be indexed, but the collections not so much. PostgreSQL kind of handles it. The contains optimization is great, but something that has been solved by other OR mappers years ago. Still, good to see.

@pascalmbamungu3432 10 ай бұрын

What's the datatype for the column holding the json array?

@pureevil379 10 ай бұрын

Brilliant

@infotips2475 8 ай бұрын

How to handle it when 'Address' has another object? Does anyone have any ideas for configuration?

@xtonetware5493 7 ай бұрын

will this work exact same way for postgre sql

@thedreadedgman 10 ай бұрын

is JSON parsing faster then query planning?

@mamg301988 10 ай бұрын

Excellent, I'm going to update the version

@OggVorbis69 9 ай бұрын

Excellent work,. all the time it was said that RDBMS do not have concept of arrays I was thinking ... Postges?? the end clarification that the native capabilities are used there was just the cherry on top of very impressive work. Well done guys, I just enjoy seeing you two on my screen. Congratulations on the cool set of examples and their order. I was thinkin that the sample with at least one visit will be better written with IS NOT NULL, with more than one will be where the Visits column value length is > than the length of textual form of a single date, etc. but those are hacks in comparison with your clear / canonical solution. Hacks may be faster but the understandable and always working code is better, even when generated. Thanks a lot. I may just start using EF now. It is good enough for me not writing all my SQL by hand. And that is something keeping in mind I am doing it since SQL server 4.2 Again, thanks a lot. Your work should be a pleasure to use.