I want to save many entities that are in a graph related to each other. Suppose the root entity is ROOT.

The DB is not on local machine. it is im[portamt for me to reduce the numebr of sql command. When I use Save(ROOT), the sql profiler show many sql script. and it is very slow! I do it in a transaction too!

Is there something in LLBLGen (like VIEW in fetching) that reduce the number of SQL command.

I saw somewhere a sql command like "INSERT INTO ALL ...". does LLBLGEn support this? if not, is there a solution?

If you want to insert 1000 rows into a table, in sqlserver, you have to execute 1000 insert statements, OR use INSERT INTO table SELECT ... . As the data comes from the entities, you're bound to the 1000 insert statements. What exactly would you have liked llblgen pro did instead of what it does now? Could you describe that in more detail, please?

I mean insertion to multiple tables in a single shot! is it possible?

I don't believe there is a syntax to do that. Could you give an example query that you are trying to reproduce?

Thanks All...

I saw somewhere a sql command like this :

INSERT INTO ALL x(...) values(...) y(...) values(...) ...

but i think this is not implemented in LLBLGEN.

see this : http://www.oracle-base.com/articles/9i/SQLNewFeatures9i.php

array parameters for doing this aren't supported, it's a native Oracle feature and because the code ordering the production of the queries is generic code it can't utilize it. Also is it pretty limited in general. It works for bulk inserts like inserts of data imported from a resource, but for general usage it's somewhat limited due to the fact that it requires that all inserts are the same (just different values), which isn't the case in inserts in an O/R mapper where some inserts have fields ABC set, others don't.

ok thanks again

Lets explain the problem:

Suppose we have a tree of entities related to each other with root of ROOT. we want o save this ROOT (with related entities) about 1000 times. My DB is not on a local machine too. what is the fastest solution.

I want to send miminim SLQ command over the network.
Let me explain if it is not clear!

Here's one suggestion:

Use a stored procedure.

Convert the root entity and related entities to XML and pass as a parameter into the procedure.

Inside the procedure read the XML and use it in your insert statement.

1 DB call.

I indeed think that if you just want to limit the # of calls, a proc is all you have. Though I also think that the real slowness is from the transaction, not the 1000 insert statements.