EntityFramework-Extensions icon indicating copy to clipboard operation
EntityFramework-Extensions copied to clipboard

Support Microsoft.Data.SqlClient for BatchSaveChanges

Open GebitMattias opened this issue 1 year ago • 2 comments

Description

EF6 got an official update to version 6.5 and with this suggests using the Microsoft.Data.SqlClient provider:

  • https://github.com/dotnet/ef6/releases/tag/v6.5.0
  • https://learn.microsoft.com/en-us/ef/ef6/what-is-new/microsoft-ef6-sqlserver

However the BatchSaveChanges() methods do not support this provider as discussed here #467. It returns this exception: Oops! The provider 'Microsoft.Data.SqlClient.SqlConnection' is not supported for 'BatchSaveChanges'. Uses 'BulkSaveChanges' instead.

We cannot change our code to BulkSaveChanges as suggested. Are there plans to update BatchSaveChanges to support Microsoft.Data.SqlClient?

GebitMattias avatar Jun 17 '24 11:06 GebitMattias