List<T>.ToAsyncEnumerable not accessible anymore after upgrade to CSVHelper 31.0.2 (.NET 8) about csvhelper

[moosetraveller]

This combination works:

<ItemGroup>
  <PackageReference Include="AspNetCore.Proxy" Version="4.4.0" />
  <PackageReference Include="CSVHelper" Version="31.0.0" />
  <PackageReference Include="HtmlSanitizer" Version="8.0.843" /> <!-- Ganss.XSS -->
  <PackageReference Include="MailKit" Version="4.4.0" />
  <PackageReference Include="Markdig.Signed" Version="0.35.0" />
  <PackageReference Include="Microsoft.AspNet.WebApi.Client" Version="6.0.0" />
  <PackageReference Include="Microsoft.AspNetCore.OpenApi" Version="8.0.2" />
  <PackageReference Include="Microsoft.EntityFrameworkCore" Version="8.0.2" />
  <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.2">
    <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    <PrivateAssets>all</PrivateAssets>
  </PackageReference>
  <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="8.0.2" />
  <PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite" Version="8.0.2" />
  <PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite" Version="8.0.2" />
  <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="8.0.2">
    <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    <PrivateAssets>all</PrivateAssets>
  </PackageReference>
  <PackageReference Include="Microsoft.Extensions.Hosting.Systemd" Version="8.0.0" />
  <PackageReference Include="MimeKit" Version="4.4.0" />
  <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.2" />
  <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite" Version="8.0.2" />
  <PackageReference Include="Quartz" Version="3.8.1" />
  <PackageReference Include="Quartz.AspNetCore" Version="3.8.1" />
  <PackageReference Include="Quartz.Extensions.DependencyInjection" Version="3.8.1" />
  <PackageReference Include="Quartz.Extensions.Hosting" Version="3.8.1" />
  <PackageReference Include="Swashbuckle.AspNetCore" Version="6.5.0" />
</ItemGroup>

But not when using:

<PackageReference Include="CSVHelper" Version="31.0.2" />

[moosetraveller]

I see that System.Linq.Async was removed with commit 2efe3a4. However, it does not make sense that this breaks my application.

If I add an unit test:

using System.Collections.Generic;
using System.Linq;
using Xunit;

namespace CsvHelper.Tests.Issues
{
	public class Issue2239
	{
		[Fact]
		public async void Issue2239Test()
		{
			List<string> values = ["a", "b", "c", "d", "e"];
			
			var updatedValues = await values.ToAsyncEnumerable() 
				.Where(value => value != "e")
				.ToListAsync();
		}
	}
}

And then remove <PackageReference Include="System.Linq.Async" Version="6.0.1" /> in CsvHelper.Tests.csproj, I get the same error.

It does not make sense to me. I have Microsoft.EntityFrameworkCore as a dependency added and also use using Microsoft.EntityFrameworkCore;.

My application breaks when upgrading from 31.0.0 to 31.0.2 (without any other changes).

[JoshClose]

There apparently is a conflict between System.Linq.Async and EntityFramework. System.Linq.Async was used for a single method call, so I removed it and change the code slightly. I'll have to look into why that's not available for you now.

[moosetraveller]

I have solved it by adding <PackageReference Include="System.Linq.Async" Version="6.0.1" /> to my project.

Nothing is wrong with the CSVHelper. I was using ToAsyncEnumerable() not realizing that it was provided from a third-party library through CSVHelper. I am very sorry for having added work to your plate.

[JoshClose]

Ha! No worries.