Castle ActiveRecord 如何条件批量更新或删除多条记录

[jzywh]

Castle ActiveRecord 如何条件批量更新或删除多条记录？

例如希望实现功能 sql = "update Clothes set ClothesTypeId = null where ClothesTypeId = 1"，

该如何做呢？ 可以在SimpleQuery中写update语句么？

[nutpp]

ActiveRecordMediator.DeleteAll(typeof(T), where);

[nutpp]

批量删除
ActiveRecordMediator.DeleteAll(typeof(T), where);

如
ActiveRecordMediator.DeleteAll(typeof(T), "ClothesTypeId = 1");

T为对应的实体类

[jzywh]

Update 呢？

[MyNameEPC]

The most efficient way is writing a sql query to do this. Castle support build-in query execution.

[DoNotTomcat]

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);

[jiejiep]

关注。。。