This SPEED is getting RIDICULOUS! - SQL Queries with Entity Framework Core BulkExtensions
🔥Learn SQL while making them FASTER as everyone else? Let's put that to the TEST! Try it Yourself! https://entityframework-extensions.ne...
This SPEED is getting RIDICULOUS! - SQL Queries with Entity Framework Core BulkExtensions - https://entityframework-extensions.ne...
🚀 Master C# and .NET programming EASILY with our best-selling C# Masterclass: https://bit.ly/47Hk3u7
Timestamps:
00:00 Learn to SPEED UP your SQL Queries FAST
00:28 What we did in the last video and why
01:03 SaveChanges and BulkSaveChanges
01:43 Create and host your SQL Server
03:27 Set up our project to work with SQL Server
06:08 Continuing with SaveChanges
09:12 Updating data on our SQL Database and Bulk Update
11:08 Deleting Data from our SQL Database and Bulk Delete
12:49 Merging local Data with SQL Database and Bulk Merge
14:01 Synchronizing your Data with SQL Database with Bulk Synchronize
15:17 But why would I want to improve the performance of my SQL Database and Queries?
16:38 Now you know how to work with SQL and be FAST at it! Thank you for watching!
🔥 What's Inside?
We revisit the data insertion tool from our last video, highlighting its effectiveness. But there's more to databases than just data entry! Prepare to learn about various daily operations and how to execute them faster and more efficiently.
We start with 'Bulk Save Changes,' a revolutionary method that streamlines the saving process by handling changes in bulk, reducing database round trips significantly.
Follow along in our practical demo, where we utilize the same Visual Studio project from our previous video.
We transition from SQLite to setting up a robust SQL database, guiding you through each step for a seamless experience.
Discover how Entity Framework Core uses Change Tracking to manage data persistence and how to overcome common errors.
Watch as we compare the traditional 'Save Changes' method with 'Bulk Save Changes,' demonstrating notable performance improvements.
Dive into Bulk Update, Bulk Delete, and Bulk Merge methods, each offering unique advantages in managing large-scale data operations.
Finally, explore the Bulk Synchronize method – a one-stop solution for updating, inserting, and deleting data to mirror your provided entities accurately.
We'll make sure to make a Developer out of you in no time!
So, what is C#?
C# (pronounced "See Sharp") is a modern, object-oriented, and type-safe programming language. C# enables developers to build many types of secure and robust applications that run in .NET. C# has its roots in the C family of languages and will be immediately familiar to C, C++, Java, and JavaScript programmers. This tour provides an overview of the major components of the language in C# 8 and earlier.
What are data operations?
Data Operations is the practice (e.g., frameworks, methods, capabilities, resources, processes and architecture) for delivering data to create insights and analytics with greater speed, scale, consistency, reliability, governance, security and cost effectiveness using modern cloud-based data platforms and tools applying agile principles.
What is SQL Serve?
Microsoft SQL Server is a relational database management system (RDBMS). Applications and tools connect to a SQL Server instance or database, and communicate using Transact-SQL (T-SQL). Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.
To learn more, make sure to watch the video, and we promise you that you'll become a C# developer by the end of the course! Have fun!
#csharp #coding #tutorial #learn #microsoft #net
TAGS
coding,software engineering,web development,programming,code,software engineer,visual studio,software developer,app development,c sharp,dotnet,software development,learn to code,csharp,c# tutorial,c# course,c# tutorial for beginners,.net core,c# programming,learn c#,how to,core,csharp learn,entity framework,entity framework core tutorial,relational database,databases,database tutorial,.net,entity framework core,ef core,data operations,data,insert
tutorialsEU offers you free video tutorials about programming and development for complete beginners up to experienced programmers.
This includes C#, Unity, Python, Android, Kotlin, Machine Learning, etc.
Stay tuned and subscribe to tutorialsEU: https://goo.gl/rBFh3x
C#: / @tutorialseuc
Facebook: / tutorialseu-109380204093233
LinkedIn: / tutorialseu
Discord: / discord
