ef 批量删除问题

[lizhengqin]

[code=csharp]
public int DeleteAll(string strListIDs)
{
using (csh0067Entities db = new csh0067Entities())
{
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@CodeID",SqlDbType.NVarChar,100)
};
pars[0].Value = strListIDs;

string strSql="delete from InviteCode where CodeID in( @CodeID)";
//string strSql = "delete from InviteCode where CodeID in( " + strListIDs + ")";
return db.ExecuteStoreCommand(strSql, pars);

}
}
[/code

上面的代码删除一条数据正常,删除多条数据就报错了,是我写的语法有问题吗

如果我把最后2行代码修改成下面代码,也就正确了

string strSql = "delete from InviteCode where CodeID in( " + strListIDs + ")";
return db.ExecuteStoreCommand(strSql, null);

请问一下,我第一种写法错在哪里,谢谢

[q107770540]

 public int DeleteAll(string strListIDs)
        {
            using (csh0067Entities db = new csh0067Entities())
            {
                var pars = new DbParameter[]{
			new SqlParameter{ParameterName ="@CodeID",Value = strListIDs}	
		};
                

                string strSql="delete from InviteCode where CodeID in (@CodeID)";
              
                return db.ExecuteStoreCommand(strSql, pars);
                
            }
        }

[lizhengqin]

和我的第一种写法报相同错误

如果我传进去的值:45 程序正常,如果,我传进去是: 45,67,23 就报错

在将 nvarchar 值 ' 45,67,23' 转换成数据类型 int 时失败。

[q107770540]

看来你还是直接字符串拼接吧： http://stackoverflow.com/questions/10780958/executestorequery-and-where-in-0

[lizhengqin]

看了你提供的网址,好像也是拼接字符串 谢谢楼上