| 
0
 | 
     1 <% group # SQL text generation control attributes %>
 | 
| 
 | 
     2 <p class='j'>
 | 
| 
 | 
     3 BLToolkit supports different ways to provide metadata information for business objects.
 | 
| 
 | 
     4 One of the ways is using attributes. Another one is XmlExtension.
 | 
| 
 | 
     5 XmlExtension is a simple xml file where you can specify a type and its attributes.
 | 
| 
 | 
     6 </p>
 | 
| 
 | 
     7 
 | 
| 
 | 
     8 XmlExtension.cs
 | 
| 
 | 
     9 <% ..\..\..\HowTo\DataAccess\XmlExtension.cs %>
 | 
| 
 | 
    10 XmlExtension.xml
 | 
| 
 | 
    11 <% ..\..\..\HowTo\DataAccess\XmlExtension.xml %>
 | 
| 
 | 
    12 <i>DataAccessor.SelectByKetSql</i> method generates and executes the following SQL statement:
 | 
| 
 | 
    13 <% sql #
 | 
| 
 | 
    14 SELECT
 | 
| 
 | 
    15 	[MiddleName],
 | 
| 
 | 
    16 	[PersonID],
 | 
| 
 | 
    17 	[LastName],
 | 
| 
 | 
    18 	[FirstName]
 | 
| 
 | 
    19 FROM
 | 
| 
 | 
    20 	[Person]
 | 
| 
 | 
    21 WHERE
 | 
| 
 | 
    22 	[PersonID] = @PersonID
 | 
| 
 | 
    23 %>
 | 
| 
 | 
    24 App.config
 | 
| 
 | 
    25 <% Doc\Data\App.config %>
 | 
| 
 | 
    26 <a href="../Data/CreateSql.htm">Create.sql script</a>
 |