Mercurial > pub > bltoolkit

annotate Tools/DocGen/Content/Doc/DataAccess/PrimaryKey.htm @ 6:11b6da379593

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Исправлена странная ошибка при использовании OfType<...>().Where(...)
author cin
date Mon, 05 Dec 2016 05:50:52 +0300
parents f990fcb411a9
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
1 <% group # SQL text generation control attributes %>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
2 <p class='j'>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
3 The <b>PrimaryKey</b> attribute indicates the field that is a part of a primary key.
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
4 </p>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
5
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
6 PrimaryKey.cs
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
7 <% ..\..\..\HowTo\DataAccess\PrimaryKey.cs %>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
8 <i>DataAccessor.SelectByKeySql</i> method generates and executes the following SQL statement:
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
9 <% sql #
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
10 SELECT
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
11 [MiddleName],
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
12 [PersonID],
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
13 [LastName],
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
14 [FirstName]
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
15 FROM
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
16 [Person]
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
17 WHERE
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
18 [PersonID] = @PersonID
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
19 %>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
20 MultiplePrimaryKey.cs
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
21 <% ..\..\..\HowTo\DataAccess\MultiplePrimaryKey.cs %>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
22 In this case <i>DataAccessor.SelectByKeySql</i> method generates and executes the following SQL statement:
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
23 <% sql #
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
24 SELECT
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
25 [MiddleName],
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
26 [PersonID],
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
27 [LastName],
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
28 [FirstName]
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
29 FROM
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
30 [Person]
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
31 WHERE
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
32 [FirstName] = @FirstName AND
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
33 [LastName] = @LastName
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
34 %>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
35 App.config
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
36 <% Doc\Data\App.config %>
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
37 <a href="../Data/CreateSql.htm">Create.sql script</a>