✅ System.InvalidOperationException: The LINQ expression
Hello guys. I'm writing a blog API, and in the process of adding a category, I want the first letter of the value in my DTO object to always be capitalized and added to the database in that format. I've tried many attempts, but I keep getting errors, and I haven't been able to find a solution even with AI. If you can help, I'd appreciate it.
CategoryRepo:
public async Task<CategoryDto> CreateCategoryAsync(CategoryDto categoryDto)
{
categoryDto.Name = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(categoryDto.Name);
var normalizedName = categoryDto.Name.Substring(0, 1).ToUpperInvariant() + categoryDto.Name.Substring(1).ToLowerInvariant();
var existingCategory = await _context.Categories.AnyAsync(x =>
x.Name.ToUpperInvariant() == normalizedName &&
x.Id != categoryDto.Id);
if (existingCategory)
{
throw new InvalidOperationException("Aynı isimde bir kategori zaten var.");
}
var categoryEntity = _mapper.Map<Category>(categoryDto);
await _context.Categories.AddAsync(categoryEntity);
await _unitOfWork.SaveChangesAsync();
return _mapper.Map<CategoryDto>(categoryEntity);
}
Error :
System.InvalidOperationException: The LINQ expression 'DbSet<Category>()\r\n .Any(c => c.Name.Equals(\r\n value: normalizedName_0, \r\n comparisonType: OrdinalIgnoreCase) && c.Id != categoryId_1)' could not be translated. Additional information: Translation of the 'string.Equals' overload with a 'StringComparison' parameter is not supported. See https://go.microsoft.com/fwlink/?linkid=2129535 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'.
CategoryRepo:
public async Task<CategoryDto> CreateCategoryAsync(CategoryDto categoryDto)
{
categoryDto.Name = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(categoryDto.Name);
var normalizedName = categoryDto.Name.Substring(0, 1).ToUpperInvariant() + categoryDto.Name.Substring(1).ToLowerInvariant();
var existingCategory = await _context.Categories.AnyAsync(x =>
x.Name.ToUpperInvariant() == normalizedName &&
x.Id != categoryDto.Id);
if (existingCategory)
{
throw new InvalidOperationException("Aynı isimde bir kategori zaten var.");
}
var categoryEntity = _mapper.Map<Category>(categoryDto);
await _context.Categories.AddAsync(categoryEntity);
await _unitOfWork.SaveChangesAsync();
return _mapper.Map<CategoryDto>(categoryEntity);
}
Error :
System.InvalidOperationException: The LINQ expression 'DbSet<Category>()\r\n .Any(c => c.Name.Equals(\r\n value: normalizedName_0, \r\n comparisonType: OrdinalIgnoreCase) && c.Id != categoryId_1)' could not be translated. Additional information: Translation of the 'string.Equals' overload with a 'StringComparison' parameter is not supported. See https://go.microsoft.com/fwlink/?linkid=2129535 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'.
