Hi,

My apologies if this has been answered before either on this forum or in the documentation. I have looked but couldn't find anything...

I'm trying to translate the following into LLBLGen.

Please note I'm using .Net 2.0 so no LINQ unfortunately.

DELETE FROM EventDay
    FROM EventDay ed  
    INNER JOIN Event e ON ed.EventId = e.Id
    LEFT JOIN EventBooking b ON b.EventDayId = ed.Id 
    WHERE b.Id IS NULL AND e.Id = @EventId

Basically I'm trying to delete all the event days that haven't been booked yet. Is this possible? If so, whats the best way of doing it? Or shall I just write a SPROC?

Thanks

Chris.

This is possible using "DeleteEntitiesDirectly" - this accepts a RelationPredicateBucket which will allow you to specify the joins and the filters to be used.

Matt

Thanks for the replay. I should have said, I'm using self servicing so "DeleteEntitiesDirectly" isn't an option. Your post did point me in the right direction though. The standard DeleteMulti has an overload for a relation collection so I managed to achieve what I wanted with the following:

            EventDayCollection days = new EventDayCollection ();

            IRelationCollection relations = new RelationCollection();
            relations.Add(EventDaEntity.Relations.EventEntityUsingEventId);
            relations.Add(EventDaEntity.Relations.EventBookingEntityUsingEventDayId, JoinHint.Left);

            days.DeleteMulti(EventFields.Id == eventId & EventBookingFields.Id == DBNull.Value, relations);

Indeed for SelfServicing, you should use the DeleteMulti overload