C#将list集合转化为sql

将list集合转化为sql in 的范围对象 比如

List<string> idList= new List<string>();
idList.Add(“001”);
idList.Add(“002”);
idList.Add(“003”);

select * from table where id in (‘001’,‘002’,‘001’)

公共方法

 		/// <summary>
        /// C#实现把String字符串转化为SQL语句中的In后接的参数
        /// </summary>
        /// <param name="aa"></param>
        /// <returns></returns>
        public static string ToSqlListString(List<string> guidList)
        {
            StringBuilder sqlString = new StringBuilder();
            foreach (string item in guidList)
            {
                sqlString.AppendFormat("'{0}',", item);
            }
            string result = sqlString.ToString();
            return result.Trim(',');
        }