diff Tools/DocGen/Content/Doc/DataAccess/PrimaryKey.htm @ 0:f990fcb411a9

Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Tools/DocGen/Content/Doc/DataAccess/PrimaryKey.htm	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,37 @@
+<% group # SQL text generation control attributes %>
+<p class='j'>
+The <b>PrimaryKey</b> attribute indicates the field that is a part of a primary key.
+</p>
+
+PrimaryKey.cs
+<% ..\..\..\HowTo\DataAccess\PrimaryKey.cs %>
+<i>DataAccessor.SelectByKeySql</i> method generates and executes the following SQL statement:
+<% sql #
+SELECT
+	[MiddleName],
+	[PersonID],
+	[LastName],
+	[FirstName]
+FROM
+	[Person]
+WHERE
+	[PersonID] = @PersonID
+%>
+MultiplePrimaryKey.cs
+<% ..\..\..\HowTo\DataAccess\MultiplePrimaryKey.cs %>
+In this case <i>DataAccessor.SelectByKeySql</i> method generates and executes the following SQL statement:
+<% sql #
+SELECT
+	[MiddleName],
+	[PersonID],
+	[LastName],
+	[FirstName]
+FROM
+	[Person]
+WHERE
+	[FirstName] = @FirstName AND
+	[LastName] = @LastName
+%>
+App.config
+<% Doc\Data\App.config %>
+<a href="../Data/CreateSql.htm">Create.sql script</a>