August 2015
Beginner
1075 pages
40h 42m
English
Add a stored procedure item to your database project by right-clicking the project and selecting Add, New Item. From the Add New Item dialog, you select the SQL CLR C# category and then the SQL CLR C# Stored Procedure project item, as shown in Figure 13.29. Let’s name the stored procedure UpdateEmployeeLogin.
FIGURE 13.29 Adding a C# stored procedure.
A new class is added to the project. Listing 13.1 shows the base code that shows up within the new class file. You can add your custom code to the static void routine UpdateEmployeeLogin.
Note
Earlier versions of Visual Studio had a separate project type (SQL ...
Read now
Unlock full access