C#_list变成逗号和引号隔开的字符串

string类型的List，变成sql的in查询方式，即变成：'a','b','c'

List<string> list=new List<string>(){"a","b","c","d","e",}

var str= string.Join(",", list.Select(e => $"'{e}'"));

//这里的str现在就是：
//'a','b','c','d','e'