LINQ to Entities在结果上分割字符串

LINQ to Entities在结果上分割字符串

您可以

AsEnumerable

用来使选择发生在内存中，而不是EF中。

var playedBanDataList = query.AsEnumerable()    .Select(bannedPlayers => new PlayerBanData    {        Admin = bannedPlayers.Admin,        BannedUntil = bannedPlayers.BannedUntil,        IsPermanentBan = bannedPlayers.IsPermanentBan,        PlayerName = bannedPlayers.PlayerName,        Reason = bannedPlayers.Reason,        IpAddresses = bannedPlayers.IpAddresses.Split( new [] {","},  StringSplitOptions.RemoveEmptyEntries).ToList()    });