|
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>
|
