.NET 7 🚀 JSON Columns with Entity Framework 7 / EF 7

[@oguzhankomcu2031]

I was waiting for the this video in the channel :D

[@Qrzychu92]

32:05 I felt personally attacked :D

[@PatrickGod]

😅

[@fbf3023]

I flinched

[@danimerz5861]

Ich hatte noch nie so freude an einem newsletter 😂🥳

[@PatrickGod]

Freut mich! Danke dir! 😊

[@thebitterbeginning]

The background music is distracting. Either lower the level or side-chain compress it with the dialog. Other than that...your videos are pretty great. Thanks for sharing!

[@PatrickGod]

Sorry about that. Thanks for your feedback! Maybe I should ditch the music altogether?

[@Wfmike]

@@PatrickGod yes please remove the background music.

[@LeonNel]

Yes ditch the music

[@DougNelson]

Another great video. Looking forward to .NET 7

[@PatrickGod]

Thank you so much! 😊

[@douglasPmn]

Thank you for this. I wouldn’t use this for day to day items but I do a lot of bulk requests over rest and need a ‘q-n-d’ drop point for data review. This technique will work splendidly.

[@Adronius]

It would be great to see how would it work for one to many relationship for JSON column.

[@PatrickGod]

Great idea! Let me write that down. 😉

[@10Totti]

You are the best!

[@PatrickGod]

Thank you very much! 😊

[@haydarm.al-samawe9819]

Hello Patrick, Always with new amazing Videos, we Appreciate your time, in your Videos, you always said to write you if there is some topic interesting to make a video about, So what about one course Blazor Authentication with Microsoft Identity And Without using "custom Auth" and include : 1-JWT Token 2-Facebook auth 3-twitter auth 4-google auth 5-GitHub auth 6-confirm email 7- reset the Password 8- Keep me signed in 9- refresh Token I know you make some of this in several videos before, but believe me, this All together in one solution with .Net6 will be like a reference for all developers. just an Idea I hope you like it, with my respect

[@PatrickGod]

Hey there, this is a great idea, thanks a lot for reaching out. I will put it on my list, but it will take some time, though. 😉 Take care, Patrick

[@dragonknight2839]

@@PatrickGod Hello Patrick, Thanks for all your efforts and amazing tutorials I really love your work. I totally agree with haydar M.Al-samawe. A Blazor cource like that will be a perfect A to Z reference to help all Blazor beginners (like me) improving their skills add will save much time and confusing about Authentication staff. And it will be much better if you use Blazor Server App rather than Web Assembly. God bless you 😊

[@geoffbarlow5077]

How about adding Google Authenticator for 2fa to the list as well?

[@arianmoslehi9962]

Thank you master because your video help me to the solve database connection in real project and thanks for timing to create this video.

[@meirkr]

Great news. How would future migration version work within existing json data?

[@SophieneMaroc]

Thnaks for the video. Maybe you could add an example of creating an object by the code in stead of using swagger. And an example of deserialization of the JSON column in the code too :))))

[@josbexerra8115]

Muchas gracias mister Patrick...

[@PatrickGod]

You're welcome! 😊

[@mariumbegum7325]

Interesting video, keep up the great work!

[@allied-data]

Thanks for the video. You say you are not a fan of json columns because you are having problems "at work". Can you please specify what those problems are?

[@cmartinez4727]

The JSON column is promising. Does anyone know the linq query performance compared to the nonJson column way?

[@volodymyrliashenko1024]

Thanks for sharing! But I wanted to see how the sql query looks when we have a json column... But any it looks promising

[@dotnetdevni]

If they can be mapped dyamically would be great for custom fields?

[@mikev1098]

Nice video. Are you going to update your .Net 6 courses to reflect .Net 7?

[@PatrickGod]

Hey, thanks for reaching out. Yes, I'm already working on the .NET 7 Jumpstart course. 😊

[@aah134-K]

I worked on a project before with xml column, it was a pain in the ass honslestly because it mapped enheritance in that column, i didnt enjoy working with it because migration was tough, i think json is better but for better result you should map a json version number with json type on two more column to make sure nothing breaks when doing any migration

[@aliramazanyildirim]

Hello there I'm so excited for your Blazor WebAssembly E-Commerce Course, but I have a little problem. Can you add german subtitles for your Blazor WebAssembly E-Commerce Course? thanks in advance

[@daydrivver2074]

Can you make a video on repository service interfaces (solid) project with net 6? I like your style and there aren't many videos out there that talk about Enterprise grade system designs

[@cyrildouglas9262]

As far as I know this features is still not compatible with permative type collections, or is it?

[@nothingisreal6345]

VS 2022 is buggy :-( ctor sometimes also doesn't work for me. And besides that: in the past VS was the tool that added business value. Now you need to install and use an additional dotnet tool and there is ZERO support in VS to create a code first data model. Left alone to create a data model first and then generate C# from it. We are essentially down to the same capabilities as using VS Code - which is for free. Note: please take care to always specify attributes for string types that control the length charset. Else the default will be nvarchar(max) - which is B.A.D. It would have been interesting to what EF creates as SQL Statement to filter the city.

[@khalilaibrahim1278]

Amazing as always, can u make a video on the use of Cancellation token in WASM

[@luan_maik]

What about query generated?

[@albertwaelti7561]

Hi Patrick Thank you for the video. I added another ICollection Property in the entity SuperHero: public ICollection? Posts { get; set; } and defined it as Json modelBuilder.Entity().OwnsMany(sh => sh.Posts, nb => nb.ToJson()); Post is the following class: public class Post { public string Text { get; set; } = String.Empty; public DateTime Created { get; set; } } It works great when inserting a new record. But I get an error "could not be translated" when I'm trying to do the following LINQ Query: var heroes = await _context.Heroes .Where(h => h.Posts!.Any(po => po.Text.Contains(textToSearch))) .Include(h => h.Details) .Include(h => h.Posts) .ToListAsync(); Is this not possible?

[@leodeguzman463]

hoping to see a query / MYSQL or MariaDB related video. men you are making .NET look so easy on every tutorial you make.

[@ilanmazuz]

But the column is still nvarchar, when will sql server will have a real JSON column?

[@dmuthami]

Entity Framework and Json columns is revoluionary.

[@mck9512]

I did not come here to watch you setup swagger. Im interested just interested in how to work with json columns.

[@rankarat]

The background music in the beginning is a bit annoying

[@PatrickGod]

Alright! Thanks for your feedback!

[@marcinignatiuk6417]

It'd be nice if You actually prepare Yourselfe to make a video next time. Json part is about 2 mins for about ~38min video. Countless mistakes, messy code, no overlook over subsequent approaches differences. Bit a waste of time...