Upgrading to Version 2.6

Posts   
 
    
Amith
User
Posts: 23
Joined: 21-Aug-2008
# Posted on: 28-Apr-2010 00:03:18   

What are the benefits I can get by upgrading LLBLGen V 2.0 to V 2.6 ?

I am more looking in to Performance improvement and better SQL statements including Derived Table Definitions and also is it any better or different way of doing Concurrency predicate with V 2.6?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39797
Joined: 17-Aug-2003
# Posted on: 28-Apr-2010 09:34:46   

concurrency predicates: no changes, as it worked properly. performance: many improvements, especially in the memory consumption area and also in fetching entities. Also little tweaks like not emitting 'TOP 1' with scalar queries, not emitting DISTINCT if not necessary etc. v2.6 also has derived table support which allows you to formulate queries which weren't possible before (including using linq).

Frans Bouma | Lead developer LLBLGen Pro
Amith
User
Posts: 23
Joined: 21-Aug-2008
# Posted on: 28-Apr-2010 17:21:53   

Is there any way I can do a Batch Update / Insert with the new version? I mean sending as a list of entity objects to update / insert.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39797
Joined: 17-Aug-2003
# Posted on: 28-Apr-2010 18:15:32   

Amith wrote:

Is there any way I can do a Batch Update / Insert with the new version? I mean sending as a list of entity objects to update / insert.

using a UnitOfWork object you mean? That can be done for a long time already (also in 2.0). Just add objects for persistence to the unit of work object, then commit it to do everything in 1 go (deletes as well).

Batching of INSERT or UPDATE SQL statements isn't supported.

So I'm not entirely sure what you mean, could you give an example?

Frans Bouma | Lead developer LLBLGen Pro
Amith
User
Posts: 23
Joined: 21-Aug-2008
# Posted on: 28-Apr-2010 21:49:51   

Otis wrote:

Amith wrote:

Is there any way I can do a Batch Update / Insert with the new version? I mean sending as a list of entity objects to update / insert.

using a UnitOfWork object you mean? That can be done for a long time already (also in 2.0). Just add objects for persistence to the unit of work object, then commit it to do everything in 1 go (deletes as well).

Batching of INSERT or UPDATE SQL statements isn't supported.

So I'm not entirely sure what you mean, could you give an example?

I am trying to send a list of objects to persist instead of sending one by one. I didn't try UnitOfWork. I will have a look at it. Or is there anything better?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39797
Joined: 17-Aug-2003
# Posted on: 29-Apr-2010 09:28:45   

Amith wrote:

Otis wrote:

Amith wrote:

Is there any way I can do a Batch Update / Insert with the new version? I mean sending as a list of entity objects to update / insert.

using a UnitOfWork object you mean? That can be done for a long time already (also in 2.0). Just add objects for persistence to the unit of work object, then commit it to do everything in 1 go (deletes as well).

Batching of INSERT or UPDATE SQL statements isn't supported.

So I'm not entirely sure what you mean, could you give an example?

I am trying to send a list of objects to persist instead of sending one by one. I didn't try UnitOfWork. I will have a look at it. Or is there anything better?

It's what you need. You can also just save an entity collection btw, that also will work in your situation.

Frans Bouma | Lead developer LLBLGen Pro