Thanks for the valuable information but if you provide me an option using EF Core methods instead of inline update statement to update the records in bulk for optimization that would really help. Please do a video on this. From this video even i cleared few concepts which i don't aware earlier... Kudos for your efforts.
Particularly from the type of update shown in the video, which sets the same value for every ticket (the updated date is ms in difference and could just be the same) from .EF Core 7 you can do IQueryable ExecuteUpdate(). Other than that, you would require a package specific for bulk operations.
@Mohamad Lawand, surely the app settings is not dynamically configurable with that code only. How is the configuration section going to detect that the app settings has been changed? Don't you need a configuration refresher?
hello, thanks for your work. Now with .NET 8/7 we can also use ExecuteUpdateAsync/ExecuteDeleteAsync extension to update/delete rows in single request query. To bind configuration in my program.cs I prefer to use extension with generics like this : var dbConfig = builder.Configuration.GetSection("DatabaseConfig").Get(). Thanks again
Very excellent and smooth explanation
Thank you very much brother Mohamad.
Thank you
I'm a simple guy.
I see a new video of this bearded wizard, I like it. 🙂
I appreciate it, thank you
Very useful all your videos, very instructive and easy to understand. Greetings from Cuba, thank you.
I respect you a lot bro.
Amazing video
Thanks for the valuable information but if you provide me an option using EF Core methods instead of inline update statement to update the records in bulk for optimization that would really help. Please do a video on this.
From this video even i cleared few concepts which i don't aware earlier... Kudos for your efforts.
Particularly from the type of update shown in the video, which sets the same value for every ticket (the updated date is ms in difference and could just be the same) from .EF Core 7 you can do IQueryable ExecuteUpdate(). Other than that, you would require a package specific for bulk operations.
@Mohamad Lawand, surely the app settings is not dynamically configurable with that code only. How is the configuration section going to detect that the app settings has been changed? Don't you need a configuration refresher?
thank you
Thanks for the Video. Can we use this ExecuteSqlInterpolatedAsync for when we GET data from the DB, instead of Update
hello, thanks for your work.
Now with .NET 8/7 we can also use ExecuteUpdateAsync/ExecuteDeleteAsync extension to update/delete rows in single request query.
To bind configuration in my program.cs I prefer to use extension with generics like this : var dbConfig = builder.Configuration.GetSection("DatabaseConfig").Get().
Thanks again
Thanks!
Is it safe from SQL injection?
Yes it’s safe
Where can I get git code repository?
Hello,
I have a question
If any error occurred between DbContext.Database.BeginTransaction() and commit transaction . Is there rollback transaction?
Yes there is rollback
@@MohamadLawandautomatic or have to write code?
diff Postman vs insomnia.