Udostępnij za pośrednictwem


Debugging (How Do I in C#)

This page links to Help on widely used debugging tasks. For more information about other categories of popular tasks covered in Help, see How Do I in C#.

Using the Visual Studio Debugger

.NET Framework Trace Functionality

Debugging Web Services

Debugging Windows Forms

Debugging SQL Applications

  • Debugging Support (LINQ to SQL)
    Links to various topics on debugging LINQ to SQL applications.

  • Walkthrough: Debug a SQL CLR User-Defined Table-Valued Function
    Shows how to debug a SQL Server CLR integration User Defined Table-Valued Function (UDF).

  • Walkthrough: Debugging a SQL CLR Trigger
    Shows how to debug a SQL Server CLR integration trigger. It uses the Contact table in the AdventureWorks sample database, which is one of the databases installed with SQL Server 2005. The sample creates a new insert CLR trigger on the Contact table, and then steps into it.

  • Walkthrough: Debugging a SQL CLR User-Defined Type
    Shows how to debug a SQL Server CLR integration user-defined type. It creates a new SQL Server CLR integration type in the Adventureworks sample database. The type is then used in a table definition, an INSERT statement, and then a SELECT statement.

  • Walkthrough: Debugging a SQL CLR User-Defined Scalar Function
    Shows how to debug SQL Server CLR integration User Defined Function (UDF). It creates a new SQL Server CLR integration User-Defined Function in the Adventureworks sample database.

  • Walkthrough: Debugging a SQL CLR User-Defined Aggregate
    Shows how to debug a SQL Server CLR integration user-defined aggregate. It creates a new SQL Server CLR integration aggregate function named Concatenate in the Adventureworks sample database. When this function is invoked in a SQL statement, it will concatenate together all the values for the column specified as its input parameter.

  • Transact-SQL Database Debugging
    Describes the necessary setup procedures, and provides a sample that illustrates how to debug a multi-tiered application.

  • Walkthrough: Debugging a Transact-SQL Trigger
    Discusses an example that uses the Adventureworks database, which has a Sales.Currency table with an UPDATE trigger. The sample includes a stored procedure that updates a row in the table, thus causing the trigger to fire. Set breakpoints in the trigger, and by executing the stored procedure with different parameters, you can follow different execution paths in the trigger.

  • Walkthrough: Debugging a Transact-SQL User-Defined Function
    Discusses an example that uses an existing User Defined Function (UDF) in the Adventureworks database, named ufnGetStock that returns a count of items in stock for a given ProductID.

  • Walkthrough: Debug a Transact-SQL Stored Procedure
    Shows how to create and debug a Transact-SQL stored procedure by Direct Database Debugging, i.e. stepping into it via Server Explorer. It also illustrates different debugging techniques such as setting breakpoints, viewing data items, etc.

Additional Resources

This site requires an Internet connection.

See Also

Concepts

How Do I in C#