|
0
|
1 <% group # Abstract accessors %>
|
|
|
2 <% order # 20 %>
|
|
|
3
|
|
|
4 <p class="j">The following example demonstrates how to create and use an abstract data accessor class.
|
|
|
5 All abstract methods of the class are generated at run-time depending on each method declaration.
|
|
|
6 Every part of the method declaration is important.
|
|
|
7 Method's return value specifies one of the Execute methods in the following way:
|
|
|
8 <table class='data'>
|
|
|
9 <tr><th>Return Type</th><th>Execute Method</th></tr>
|
|
|
10 <tr><td><i>IDataReader</i> interface</td><td>ExecuteReader</td></tr>
|
|
|
11 <tr><td>Subclass of <i>DataSet</i></td><td>ExecuteDataSet</td></tr>
|
|
|
12 <tr><td>Subclass of <i>DataTable</i></td><td>ExecuteDataTable</td></tr>
|
|
|
13 <tr><td>Class implementing the <i>IList</i> interface</td><td><a href="ExecuteList.htm">ExecuteList</a> or <a href="ExecuteList.htm">ExecuteScalarList</a></td></tr>
|
|
|
14 <tr><td>Class implementing the <i>IDictionary</i> interface</td><td><a href="ExecuteDictionary.htm">ExecuteDictionary</a> or <a href="ExecuteDictionary.htm">ExecuteScalarDictionary</a></td></tr>
|
|
|
15 <tr><td><i>void</i></td><td>ExecuteNonQuery</td></tr>
|
|
|
16 <tr><td><i>string</i>, <i>byte[]</i> or value type</td><td><a href="ExecuteScalar.htm">ExecuteScalar</a></td></tr>
|
|
|
17 <tr><td>In any other case</td><td><a href="ExecuteObject.htm">ExecuteObject</a></td></tr>
|
|
|
18 </table>
|
|
|
19 Method name explicitly defines action name which is converted to stored procedure name.<br/>
|
|
|
20 Type, sequential order, and name of the method parameters is mapped to the command parameters.
|
|
|
21 Exceptions from this rule are:
|
|
|
22 <br>
|
|
|
23 <div style="margin:-10px 0px -10px -10px"><ul compact="compact">
|
|
|
24 <li>a parameter of <a href="../Data/index.htm"><i>DbManager</i></a> type. In this case generator uses provided <a href="../Data/index.htm"><i>DbManager</i></a> to call the command.</li>
|
|
|
25 <li>parameters decorated with attribute <i>FormatAttribute</i>.</li>
|
|
|
26 </ul></div>
|
|
|
27 </p>
|
|
|
28 AbstractAccessor.cs
|
|
|
29 <% ..\..\..\HowTo\DataAccess\AbstractAccessor.cs %>
|
|
|
30 <a name='Person'></a>
|
|
|
31 Person.cs
|
|
|
32 <% ..\..\..\HowTo\DataAccess\Person.cs %>
|
|
|
33 Gender.cs
|
|
|
34 <% ..\..\..\HowTo\DataAccess\Gender.cs %>
|
|
|
35 App.config
|
|
|
36 <% Doc\Data\App.config %>
|
|
|
37 <a href="../Data/CreateSql.htm">Create.sql script</a>
|
