Entity Framework 7 (EF7) : New bulk update API

-



Entity Framework 7 (EF7) has introduced a new bulk update API that allows developers to update multiple entities in a single database round trip. This feature is particularly useful when you need to update large amounts of data, as it can help reduce the number of database round trips and improve performance.

Here's an example of how to use the bulk update API in Entity Framework 7:


In this example, we first retrieve a list of blogs using LINQ, just like in the previous example. Next, we loop through the list of blogs and update the URL property of each blog. Finally, we use the UpdateRange method on the context to update all of the blogs in a single database round trip, and then call SaveChanges to persist the changes to the database.

By using the bulk update API in Entity Framework 7, you can significantly improve the performance of your application when updating large amounts of data.


Comments

Post a Comment

Popular posts from this blog

Error: The client and server cannot communicate, because they do not possess a common algorithm.

-
Error:MySql.Data.Common.Ssl.StartSSL(Stream& baseStream, Encoding encoding, String connectionString) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() This issue is related to a connection issue between a .NET application and a MySQL database. The stack trace shows the application encountering an exception while attempting to open a connection to the MySQL database. It seems like the error is due to a problem with establishing a Secure Sockets Layer (SSL) connection. The exception is thrown in the MySql.Data.Common.Ssl.StartSSL method, which suggests that the error occurred...
Read more

How to split comma separated string into rows in mysql?

-
When we have a comma-separated string like 1,2,3... and if we need to display as row like  ID  1  2  3  Here is the query we can use for the same  e.g.  Table name: tblTest  Column Name : vals  SELECT        DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(vals, ',', n.digit+1), ',', -1) val  FROM         tblTest        INNER JOIN (SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6) n ON LENGTH(REPLACE(vals, ',' , '')) <= LENGTH(vals)-n.digit;  Hope this is helpful!
Read more

Disable Copy Paste And Mouse Right Click JavaScript, jQuery

-
Here is the code we can use to Disable Right Mouse Click Using jQuery: <script type="text/javascript"> $(document).ready(function () {     //Disable full page     $("body").on("contextmenu",function(e){         return false;     });           //Disable part of page     $("#id").on("contextmenu",function(e){         return false;     }); }); </script> Disable Cut, Copy, Paste Using jQuery: <script type="text/javascript"> $(document).ready(function () {     //Disable full page     $('body').bind('cut copy paste', function (e) {         e.preventDefault();     });           //Disable part of page     $('#id').bind('cut copy paste', function (e) {         e.preventDefault();     }); }); </script> Hope this will help!
Read more