1.3w+
社区成员
- 全部
Castle ActiveRecord 如何条件批量更新或删除多条记录
Castle ActiveRecord 如何条件批量更新或删除多条记录？
例如希望实现功能 sql = "update Clothes set ClothesTypeId = null where ClothesTypeId = 1"，
该如何做呢？ 可以在SimpleQuery中写update语句么？
例如希望实现功能 sql = "update Clothes set ClothesTypeId = null where ClothesTypeId = 1"，
该如何做呢？ 可以在SimpleQuery中写update语句么？
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
jiejiep 2010-04-19
关注。。。
DoNotTomcat 2008-04-07
ISessionFactoryHolder sessionHolder = ActiveRecordMediator.GetSessionFactoryHolder();
ISession session = sessionHolder.CreateSession(typeof(News));
try
{
System.Data.IDbCommand command = session.Connection.CreateCommand();
command.CommandText = "update news set IsPassed=" + IsPassed + " ,checkerList='" + adminRealName + "' WHERE id in('" + NewsIdList + "')";
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
sessionHolder.ReleaseSession(session);
ISession session = sessionHolder.CreateSession(typeof(News));
try
{
System.Data.IDbCommand command = session.Connection.CreateCommand();
command.CommandText = "update news set IsPassed=" + IsPassed + " ,checkerList='" + adminRealName + "' WHERE id in('" + NewsIdList + "')";
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
sessionHolder.ReleaseSession(session);
MyNameEPC 2008-04-01
The most efficient way is writing a sql query to do this. Castle support build-in query execution.
jzywh 2008-03-26
Update 呢？
nutpp 2008-03-25
批量删除
ActiveRecordMediator.DeleteAll(typeof(T), where);
如
ActiveRecordMediator.DeleteAll(typeof(T), "ClothesTypeId = 1");
T为对应的实体类
ActiveRecordMediator.DeleteAll(typeof(T), where);
如
ActiveRecordMediator.DeleteAll(typeof(T), "ClothesTypeId = 1");
T为对应的实体类
nutpp 2008-03-25
ActiveRecordMediator.DeleteAll(typeof(T), where);
