How to debug linq for InsertOnSubmit sql statement?

Question

The following code to work.

db.DBUsers.InsertOnSubmit(new DBUser
    {
        AllTheStuff = valuesBeyondYourWildestDreams
    }
);
db.SubmitChanges();

My guess is that something has changed in the database and the feed is not running because the display is off.
Since the linq visualizer does not work for me (bonus points for fixing it), I want to find another way to find out what exactly is happening and why the feed does not work silently.

Update
I tried to use

db.SubmitChanges(ConflictMode.FailOnFirstConflict);

to get an exception, but it looks like work is working. Except that the database does not have a new new object.

Answer 1

SQL Server Profiler, - , , , .

LINQ , SP: StmtCompleted ( ) SQL: StmtCompleted ( TSQL) , , SQL LINQ.

, , . , , msdb master.

Answer 2

:

db.Log = Console.Out;

Answer 3

linq sql .

.

http://www.u2u.info/Blogs/Kris/Lists/Posts/Post.aspx?ID=11

Answer 4

You can also use LINQPad - copy your LINQ code there, go to the database and set dumps for effective LINQ debugging.