| 
0
 | 
     1 <% group # Basic CRUDL operations and SQL text generation %>
 | 
| 
 | 
     2 <% order # 153 %>
 | 
| 
 | 
     3 
 | 
| 
 | 
     4 UpdateSql.cs
 | 
| 
 | 
     5 <% ..\..\..\HowTo\DataAccess\UpdateSql.cs %>
 | 
| 
 | 
     6 <i>DataAccessor.UpdateSql</i> method generates and executes the following SQL statement:
 | 
| 
 | 
     7 <% sql #
 | 
| 
 | 
     8 UPDATE
 | 
| 
 | 
     9 	[Person]
 | 
| 
 | 
    10 SET
 | 
| 
 | 
    11 	[MiddleName] = @MiddleName,
 | 
| 
 | 
    12 	[Gender]     = @Gender,
 | 
| 
 | 
    13 	[LastName]   = @LastName,
 | 
| 
 | 
    14 	[FirstName]  = @FirstName
 | 
| 
 | 
    15 WHERE
 | 
| 
 | 
    16 	[PersonID]   = @PersonID
 | 
| 
 | 
    17 %>
 | 
| 
 | 
    18 <a name='Person'></a>
 | 
| 
 | 
    19 Person.cs
 | 
| 
 | 
    20 <% ..\..\..\HowTo\DataAccess\Person.cs %>
 | 
| 
 | 
    21 Gender.cs
 | 
| 
 | 
    22 <% ..\..\..\HowTo\DataAccess\Gender.cs %>
 | 
| 
 | 
    23 App.config
 | 
| 
 | 
    24 <% Doc\Data\App.config %>
 | 
| 
 | 
    25 <a href="../Data/CreateSql.htm">Create.sql script</a>
 |