Is there any way to do a Insert or Update / Merge / Upsert in LLBLGen

Question

I'd like to do an upmerge using LLBLGen without first fetching then saving the entity.
I already found the possibility to update without fetching the entity first, but then I have to know it is already there.

Updating entries would be about as often as inserting a new entry.

Is there a possibility to do this in one step?
Would it make sense to do it in one step?

Facts:

• LLBLgen Pro 2.6
• SQL Server 2008 R2
• .NET 3.5 SP1

Answer 1

I know I'm a little late for this, but As I remember working with LLBLGenPro, it is totally possible and one of its beauties is everithing is possible! I don't have my samples, but I'm pretty sure you there is a method named UpdateEntitiesDirectly that can be used like this:

// suppose we have Product and Order Entities
using (var daa = new DataAccessAdapter())
{
    int numberOfUpdatedEntities = 
        daa.UpdateEntitiesDirectly(OrderFields.ProductId == 23 && OrderFields.Date > DateTime.Now.AddDays(-2));
}

When using LLBLGenPro we were able to do pretty everything that is possible with an ORM framework, it's just great! It also has a method to do a batch delete called DeleteEntitiesDirectly that may be usefull in scenarios that you need to delete an etity and replace it with another one.

Hope this is helpful.