Synchronizing SQL Server and SharePoint list data through the CLR (iii)

It's written in front.

This series of articles is divided into four parts:

1. CLR Overview.

2. Perform CLR integration programming in Visual Studio and deploy to SQL Server, including stored procedures, triggers, custom functions, custom types, and aggregations.

3. CLR integrated programming debugging and problems encountered.

4. Use the CLR to synchronize SQL Server tables and SharePoint list (from actual project applications).

This series of articles is based on the following software environments:

Windows Server 2003 Enterprise Edition Service Pack 2

Microsoft Visual Studio Team System 2008

Microsoft SQL Server 2008

Microsoft Office Sharepoint Server 2007

Debugging of CLR integrated programming

As mentioned earlier, the development of SQL CLR integrated programming in Visual Studio and Visual Studio also provide debugging for CLR integrated programming, making it easier to develop, two specific debugging methods are described below.

Using single step debugging in the Server Explorer window

1. Open the SQL CLR project in Visual Studio, open the CS file and set breakpoints on the code you want to debug, and Visual Studio prompts you to allow the SQL CLR to debug and click Yes. Also, in the Server Explorer window, right-click the connected database node and see that application debugging and allow SQL/CLR debugging have been selected.