Hello,

I want to delete a Entity with his collection without fetching the collection.

Im using Template "adapter".

I have tried with UnitOfWork2 but there is no DeleteMulti.

Is there a way?

regards

Please use the DataAccessAdapter's method DeleteEntitiesDirectly() passing the appropriate filter.

Hello,

I need your help again.

I tried this:

bucket.PredicateExpression.AddWithAnd(new FieldCompareSetPredicate(TUserRolesFields.UserRoleId,null,
                TUserRoleRightsFields.UserRoleId, null,SetOperator.In,
                TUserRoleRightsFields.UserRoleId == userRolesEntity.UserRoleId)).
                AddWithAnd(TUserRolesFields.UserRoleId == userRolesEntity.UserRoleId) ;
    
    

            this.adapter.DeleteEntitiesDirectly(typeof(TUserRolesEntity),bucket);

but i got this exception:

Eine nicht behandelte Ausnahme des Typs 'SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException' ist in sd.llblgen.pro.ormsupportclasses.net11.dll aufgetreten.

Zusätzliche Informationen: An exception was caught during the execution of an action query: The DELETE statement conflicted with the REFERENCE constraint "FK_UserRoleRights_URID". The conflict occurred in database "3107", table "dbo.T_UserRoleRights", column 'UserRoleID'. The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

Can you help me?

It's a referential integrity error raised by your DB. Something in your T_UserRoleRights table is referencing the table you are trying to delete from, and you do not have Cascade Delete set on the relationship.

Either delete the dependant records from T_UserRoleRights first, or modify the relationship to CascadeDelete.

Matt