Please help me to accomplish the LLBLGEN version for the below mentioned SQL query. I am a beginer in LLBLGEN. Please help me.

DELETE FROM Friend
WHERE
(MemberGuid = memberGUID AND FriendGuid == friendGUID)
OR
(MemberGuid = friendGUID AND FriendGuid == memberGUID)

Thanks in advance.

You should use DeleteEntitiesDirectly and pass it a filter. This is an aprox code:

var bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(FriendFields.MemberGui == memberGUID & FriendFields.FriendGuid == friendGUID);
bucket.PredicateExpression.AddWithOr(FriendFields.MemberGui == friendGUI & FriendFields.FriendGuid == memberGUID);

using (var adapter = new DataAccessAdapter())
{
     adapter.DeleteEntitiesDirectly(typeof(FriendEntity), bucket);
}