I have question about a situation like this i have a stored procedure looks like this

create proc myProc as

SELECT * FROM cusomters SELEC * FROM orders

How can i cast the resulting DataTable into the entity type Customer and Order ? Can someone post sample code for me ?

the procedure construct itself looks wrong, did you mean that it will return one result or the other conditionally?

vairam2008 wrote:

the procedure construct itself looks wrong, did you mean that it will return one result or the other conditionally?

This is correct
SQL server supports returning unlimted number of results in one statment . This is useful as a performance gain . You can get a customer and his orders in one trip to the server .

Oracle supports this also using packages . MySQL supports it also via procedures .

That's indeed possible. Please read LLBLGenPro Help - Using the generated code - (Adapter | SS) - Fetching DataReaders and projections - Resulset projections - Projecting Stored Procedure resultset onto entity collection.