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