EntityFramework 在脚本中使用in

var nameList = new List() { "abc", "def" }.ToArray(); var sqlQuery = $"delete from MyTable where Name in ({string.Join(',', reminderList.Select(x => $"{{{Array.IndexOf(reminderList, x)}}}"))})"; // ReSharper disable once CoVariantArrayConversion var count = await dbContext.Database.ExecuteSqlRawAsync(sqlQuery, nameList);
原文地址:https://www.cnblogs.com/fudaming/p/15246879.html