Repository Pattern and Inspect() how to get sql executed?

Hi there,

 Just wondering when using the Repository pattern how can we inspect the sql that is being executed?

 i.e DB.Save(product) =>> INSERT INTO ......

Regards Dotnetshadow 

You can do this in a number of ways, but the short answer is that we don't have an Inspect() mechanism yet. If you were to run this query outside of the Factory method (DB.Save()) you could just do a SqlQuery.ToString() and it would return the sql.

Other than that, SQL Profiler can help as well as setting a break point. 

Thanks for the reply,

So with regards to running SqlQuery.ToString() do you mean just Query qry = new Query(Tables.Products); qry.ToString()?

With the breakpoint method do you mean like debug the Subsonic code so you can drill down to the actualy executing sql?

Regards DotnetShadow