System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at System.Data.SqlClient.SqlBuffer.get_Int32() at lambda_method(Closure , IQueryRunner , IDataReader ) at LinqToDB.Linq.QueryRunner.Mapper`1.Map(IQueryRunner queryRunner, IDataReader dataReader) at LinqToDB.Linq.QueryRunner.ExecuteQuery[T](Query query, IDataContext dataContext, Mapper`1 mapper, Expression expression, Object[] ps, Int32 queryNumber)+MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Nop.Services.Directory.CountryService.<>c__DisplayClass10_0.b__0() in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Services\Directory\CountryService.cs:line 107 at Nop.Core.Caching.MemoryCacheManager.<>c__DisplayClass6_0`1.b__0(ICacheEntry entry) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Core\Caching\MemoryCacheManager.cs:line 83 at Microsoft.Extensions.Caching.Memory.CacheExtensions.GetOrCreate[TItem](IMemoryCache cache, Object key, Func`2 factory) at Nop.Core.Caching.MemoryCacheManager.Get[T](CacheKey key, Func`1 acquire) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Core\Caching\MemoryCacheManager.cs:line 79 at Nop.Services.Directory.CountryService.GetAllCountries(Int32 languageId, Boolean showHidden) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Services\Directory\CountryService.cs:line 86 at Nop.Services.Directory.CountryService.GetAllCountriesForShipping(Int32 languageId, Boolean showHidden) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Services\Directory\CountryService.cs:line 141 at Nop.Web.Factories.ShoppingCartModelFactory.PrepareEstimateShippingModel(IList`1 cart, Boolean setEstimateShippingDefaultAddress) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Presentation\Nop.Web\Factories\ShoppingCartModelFactory.cs:line 773 at Nop.Web.Factories.ProductModelFactory.PrepareProductDetailsModel(Product product, ShoppingCartItem updatecartitem, Boolean isAssociatedProduct) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Presentation\Nop.Web\Factories\ProductModelFactory.cs:line 1544 at Nop.Web.Controllers.ProductController.ProductDetails(Int32 productId, Int32 updatecartitemid) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Presentation\Nop.Web\Controllers\ProductController.cs:line 192 at lambda_method(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at WebMarkupMin.AspNetCore3.WebMarkupMinMiddleware.ProcessAsync(HttpContext context, Boolean useMinification, Boolean useCompression) at WebMarkupMin.AspNetCore3.WebMarkupMinMiddleware.ProcessAsync(HttpContext context, Boolean useMinification, Boolean useCompression) at WebMarkupMin.AspNetCore3.WebMarkupMinMiddlewareBase.Invoke(HttpContext context) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 125 at Nop.Services.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Services\Authentication\AuthenticationMiddleware.cs:line 79 at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Nop.Services.Installation.InstallUrlMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Services\Installation\InstallUrlMiddleware.cs:line 52 at Nop.Services.Common.KeepAliveMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in E:\projects\Nahrdev\Aliraqi-Portal\NopCommerce\Libraries\Nop.Services\Common\KeepAliveMiddleware.cs:line 49 at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.HandleException(HttpContext context, ExceptionDispatchInfo edi) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context) HEADERS ======= Accept: */* Connection: close Host: eliraqi.com.eg User-Agent: claudebot