0
|
1 <% group # SQL text generation control attributes %>
|
|
2
|
|
3 <p class="j">
|
|
4 The <b>NonUpdatable</b> attribute indicates the field that should not be updated by <i>UPDATE</i> or <i>INSERT</i> SQL statements.
|
|
5 </p>
|
|
6
|
|
7 NonUpdatable.cs
|
|
8 <% ..\..\..\HowTo\DataAccess\NonUpdatable.cs %>
|
|
9 <i>DataAccessor.Insert</i> method generates and executes the following SQL statement:
|
|
10 <% sql #
|
|
11 INSERT INTO [Person] (
|
|
12 [MiddleName],
|
|
13 [Gender],
|
|
14 [LastName],
|
|
15 [FirstName]
|
|
16 ) VALUES (
|
|
17 @MiddleName,
|
|
18 @Gender,
|
|
19 @LastName,
|
|
20 @FirstName
|
|
21 )
|
|
22 %>
|
|
23 App.config
|
|
24 <% Doc\Data\App.config %>
|
|
25 <a href="../Data/CreateSql.htm">Create.sql script</a>
|