Cannot perform a shrinkdatabase operation inside transaction

Question

While executing below-mentioned query in C# using Entity framework below-mentioned error occurred.Please find this.This query successfully executed in SQL server management studio.But not working on the C# code.Please, anyone, help me.
var RunStoredProcedure1 = _context.Database.ExecuteSqlCommand( "USE MDRFDataBase;  DBCC SHRINKDATABASE(N'MDRFDataBase' );  " );
Cannot perform a shrink database operation inside a user transaction. Terminate the transaction and reissue the statement.

Sagar Pandurang Kap · Accepted Answer

Hi,   Try below code :-   _context.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, "EXEC procedurename");   Hope it helps...

Manish Kumar · Answer

Shrinking the database causes heavy fragmentation of the tables and reduces the performance. Do NOT shrink your database.