I know that with LoadOptions I can retrieve data from tables with associations using one only connection.
LoadOptions1.LoadWith<Customer>(c => c.Orders);
LoadOptions1.LoadWith<Order>(o => o.Order_Details);
But if i want to retrieve data from two tables with NO ASSOCIATION using one only connection, how can I do?
For example, I want in a form a list of Customers and a list of Suppliers, but I want to load these values using ONE only connection, because my database is on a remote server, so I want to optimize my connections.
If I do:
looking at Sql Profile I see a first SELECT, a Connection Reset, second SELECT, a Connection Reset.
I want First and Second SELECT and a Reset Connection.