|
0
|
1 <% group # SQL text generation control attributes %>
|
|
|
2 <p class='j'>
|
|
|
3 The <b>TableName</b> attribute specifies a name of the table represented by the decorated object.
|
|
|
4 </p>
|
|
|
5
|
|
|
6 TableName.cs
|
|
|
7 <% ..\..\..\HowTo\DataAccess\TableName.cs %>
|
|
|
8 <i>DataAccessor.SelectByKeySql</i> and <i>DataAccessor.SelectByKey</i> methods generate and execute the following SQL statement:
|
|
|
9 <% sql #
|
|
|
10 -- SelectByKeySql
|
|
|
11 SELECT
|
|
|
12 [MiddleName],
|
|
|
13 [PersonID],
|
|
|
14 [LastName],
|
|
|
15 [FirstName]
|
|
|
16 FROM
|
|
|
17 [Person]
|
|
|
18 WHERE
|
|
|
19 [PersonID] = @PersonID
|
|
|
20
|
|
|
21 -- SelectByKey
|
|
|
22 exec Person_SelectByKey @id=1
|
|
|
23 %>
|
|
|
24 App.config
|
|
|
25 <% Doc\Data\App.config %>
|
|
|
26 <a href="../Data/CreateSql.htm">Create.sql script</a>
|
