CODEWITHSUNDEEP
sqllinq-to-sqlsqlitedblinq
Joey
Joey

Reputation: 354506

How can I find out the exact query that gets executed with LINQ to SQL in DbLinq and SQLite?

I'm using DbLinq with SQLite for a small project of mine. Is there any way to look at the actual SQL queries that get executed behind the scenes?

I remember a monitoring program for SQL Server from my internship but SQLite is a quite different beast, I fear.

Upvotes: 0

Views: 244

Answers (2)

Gabe
Gabe

Reputation: 86718

Your database context should have a Log property of type TextWriter. If you assign context.Log = Console.Out; for example, you should get the SQL written out to the console.

Upvotes: 2

Kefala
Kefala

Reputation: 100

If you're using Visual Studio 2010 Premium or Ultimate you may find the Tier Interaction Profiler helpful. There was a good blog post recently on Skinner's Blog over on MSDN that included viewing the generated SQL code

Upvotes: 0

Related Questions