System.InvalidCastException: Unable to cast object of type 'System.Data.SqlTypes.SqlString' to type 'System.Data.SqlTypes.SqlGuid'.
 at System.Data.SqlClient.SqlBuffer.get_SqlGuid()
 at System.Data.SqlClient.SqlDataReader.GetGuid(Int32 i)
 at lambda_method(Closure , DbDataReader )
 at Microsoft.EntityFrameworkCore.Storage.Internal.TypedRelationalValueBufferFactory.Create(DbDataReader dataReader)
 at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
 at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
 at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
 at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider._TrackEntities[TOut,TIn](IEnumerable`1 results, QueryContext queryContext, IList`1 entityTrackingInfos, IList`1 entityAccessors)+MoveNext()
 at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
 at System.Linq.Lookup`2.CreateForJoin(IEnumerable`1 source, Func`2 keySelector, IEqualityComparer`1 comparer)
 at System.Linq.Enumerable.JoinIterator[TOuter,TInner,TKey,TResult](IEnumerable`1 outer, IEnumerable`1 inner, Func`2 outerKeySelector, Func`2 innerKeySelector, Func`3 resultSelector, IEqualityComparer`1 comparer)+MoveNext()
 at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
 at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector)
 at Sunlight.Dcs.Application.Sales.SalesOrder.DegradedVehicleContracts.DegradedVehicleContractService.QueryByIdAsync(Int32 id) in E:\63318\sales-service\src\sales.orders\Application.Sales.Orders\SalesOrder\DegradedVehicleContracts\DegradedVehicleContractService.cs:line 99
 at Abp.Threading.InternalAsyncHelper.AwaitTaskWithPostActionAndFinallyAndGetResult[T](Task`1 actualReturnValue, Func`1 postAction, Action`1 finalAction)
 at Sunlight.Dcs.WebApi.Sales.Controllers.Orders.DegradedVehicleContractController.QueryById(Int32 id) in E:\63318\sales-service\src\WebApi.Sales\Controllers\Orders\DegradedVehicleContractController.cs:line 50
 at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
 at System.Threading.Tasks.ValueTask`1.get_Result()
 at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
 at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
 at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
 at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
 at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
 at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync()

public async Task<SimpleDegradedVehicleContractOutput> QueryByIdAsync(int id) {
 var queryResult = await _degradedVehicleContractRepository.GetAll()
 .Include(d => d.DegradedVehicleContractDetails)
 .SingleOrDefaultAsync(mp => mp.Id == id);
 if (queryResult == null)
 throw new ValidationException($"當(dāng)前Id為:{id}的降級(jí)車(chē)合同沒(méi)有找到");
 var result = _objectMapper.Map<SimpleDegradedVehicleContractOutput>(queryResult);
 result.Details = _objectMapper.Map<List<DegradedVehicleContractDetailDto>>(queryResult.DegradedVehicleContractDetails);

 //獲取ProductId
 var productIds = queryResult.DegradedVehicleContractDetails.Select(d => d.ProductId).Distinct().ToArray();
 //車(chē)輛Id
 var vinLists = queryResult.DegradedVehicleContractDetails.Select(r => r.Vin).Distinct().ToArray();

 var detailResult = (from detail in queryResult.DegradedVehicleContractDetails
 join product in _productRepository.GetAll().Where(p => productIds.Contains(p.Id))
 on detail.ProductId equals product.Id
 join vehicleDict in _vehicleInformationRepository.GetAll().Where(v => vinLists.Contains(v.Vin))
 on detail.Vin equals vehicleDict.Vin
 select new {
 ProductId = product.Id,
 product.ProductType,
 VehicleId = vehicleDict.Id,
 detail.Vin
 }).ToDictionary(r => Tuple.Create(r.ProductId, r.Vin), r => new { r.ProductType, r.VehicleId });

 result.Details.ForEach(r => {
 r.ProductType = detailResult[Tuple.Create(r.ProductId, r.Vin)]?.ProductType;
 r.VehicleId = detailResult[Tuple.Create(r.ProductId, r.Vin)].VehicleId;
 });

 return result;
 }

 private readonly IRepository<Product> _productRepository;
 private readonly IRepository<VehicleInformation> _vehicleInformationRepository;

public DegradedVehicleContractService(IObjectMapper objectMapper,
 IRepository<DegradedVehicleContract> degradedVehicleContractRepository,
 IRepository<Product> productRepository,
 IRepository<VehicleInformation> vehicleInformationRepository,
 IRepository<Company> companyRepository,
 IDegradedVehicleContractManager degradedVehicleContractManager,
 IRepository<ProductAffiProductCategory> productAffiProductCategoryRepository,
 IRepository<ProductCategoryBusinessDomain> productCategoryBusinessDomainRepository,
 IRepository<TiledProductCategory> tiledProductCategoryRepository,
 IRepository<BusinessDomain> businessDomainRepository,
 IMapper autoMapper) {
 _objectMapper = objectMapper;
 _degradedVehicleContractRepository = degradedVehicleContractRepository;
 _productRepository = productRepository;
 _vehicleInformationRepository = vehicleInformationRepository;
 _companyRepository = companyRepository;
 _degradedVehicleContractManager = degradedVehicleContractManager;
 _productAffiProductCategoryRepository = productAffiProductCategoryRepository;
 _productCategoryBusinessDomainRepository = productCategoryBusinessDomainRepository;
 _tiledProductCategoryRepository = tiledProductCategoryRepository;
 _businessDomainRepository = businessDomainRepository;
 _autoMapper = autoMapper;
 }

join vehicleDict in _vehicleInformationRepository.GetAll().Where(v => vinLists.Contains(v.Vin))   on detail.Vin equals vehicleDict.Vin

join product in _productRepository.GetAll().Where(p => productIds.Contains(p.Id)) on detail.ProductId equals product.Id