System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 62) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Co3.FH.Dw.DAL.Repositories.ProductRepository.GetCustomerAllowedProducts(String accountNum, String custProductGroupId, String command) in C:\Data\Development\git\fhe4-espresso-master\Co3.FH.Dynamicweb\DAL\Repositories\ProductRepository.cs:line 184 at Co3.FH.Dw.Services.ProductService.GetCustomerAllowedProducts(String accountNum, String customerProductGroupId, Boolean skipAssortmentAll, String command) in C:\Data\Development\git\fhe4-espresso-master\Co3.FH.Dynamicweb\Services\ProductService.cs:line 71 at Co3.FH.Dw.Subscribers.BeforeProductPaging.OnNotify(String notification, NotificationArgs args) in C:\Data\Development\git\fhe4-espresso-master\Co3.FH.Dynamicweb\Subscribers\BeforeProductPaging.cs:line 43 at Dynamicweb.Extensibility.Notifications.NotificationManager.Notify(String notification, NotificationArgs eventArgs) at Dynamicweb.Ecommerce.Frontend.Frontend.ListProducts(ProductCollection products, String groupsIdent, Boolean hasBeenSorted) at Dynamicweb.Ecommerce.Frontend.Frontend.GetProductsFromIndexQuery() ClientConnectionId:8a70f98f-1087-4d76-997a-85a1bd89310c Error Number:1205,State:52,Class:13