Execute Store Procedure by Entity Framework .NET core

Hello

For example, our Store Procedure (SP) called "DeletePartsById"

Now, from C# code we want call this SP on x Ids, so call SP x times
Function returns delete statuses of D (CRUD ) operation:

1. public List<DeleteStatus> Delete(List<PartToDelete> partsToDelete)
2. {

3. //Order of usings etc.:

4. //1. Create connection and make open

5. //2. Create transaction from connection

6. //3. Create command from connection and transaction

7. //4. do all db CRUD operations

8. //5. Commit transaction

10. List<DeleteStatus> deleteStatuses = new List<DeleteStatus>();

12. using (SqlConnection connection = new SqlConnection(_connectionString))

13. {

14. if (connection.State == System.Data.ConnectionState.Closed)

15. {

16. connection.Open();

17. }

19. using (var transaction = connection.BeginTransaction())

20. {

21. using (SqlCommand cmd = new SqlCommand("DeletePartsById", connection, transaction))

22. {

23. cmd.CommandType = System.Data.CommandType.StoredProcedure;

24. cmd.Parameters.Add(SPGroupIdParameterName, System.Data.SqlDbType.VarChar);

26. foreach (PartToDelete partToDelete in partsToDelete)

27. { 

    //Execute Store Procedure

    cmd.Parameters[0].Value = partToDelete.Id; 

    int resultOfExecuteSP = cmd.ExecuteNonQuery();

28. //delete from  table

29. EntityEntry<Part> removedPart = _context.Remove

30. (_context.Part.FirstOrDefault(part => part.Id == partToDelete.Id));

31. _context.SaveChanges();

33. //create result

34. DeleteStatus deleteStatus = new DeleteStatus(partToDelete.Id, removedPart.State.ToString());

35. deleteStatuses.Add(deleteStatus);

36. }

38. transaction.Commit();

    
    

    }

39. }

40. }

42. return deleteStatuses;

43. }