quick question, I'm very new to database programming and have found llblgen pro to be great help. Was wondering is there any way to see the corresponding sql statement for a given llblgen pro command?

for example

llblgen code:

CustomerCollection customers = new CustomersCollection(); customers.GetMulti(null);

SQL code:

Select * from Customer

Thanks

erichar11 wrote:

Was wondering is there any way to see the corresponding sql statement for a given llblgen pro command?

The easiest way if you are using SQL Server is to use the Microsoft "Profiler" tool. It is installed with the SQL Server client. This tool allows you to capture all of the interactions with the SQL Server, including all of the SQL statements generated by LLBLGen.

There is plenty more that you can do with Profiler, but I am sure you can work that out

Thanks for the tip, just got profiler running and it should work just fine.

erichar11 wrote:

Thanks for the tip, just got profiler running and it should work just fine.

You can also step into the code, until you arrive into the DAO class, then step over the creation of the query (for example a selectQuery) and type in the command window in vs.net: (C#)

?((RetrievalQuery)selectQuery).ToString()

You can also click open the selectQuery's Command object and browse to the CommandText property's contents.

But profiler is the best choice

thanks Frans for the insight, I like profiler better than steping into the code.

erichar11 wrote:

thanks Frans for the insight, I like profiler better than steping into the code.

I agree however it can sometimes be a little tricky because if you run some code which executes a lot of queries, which code started which query?