Mercurial > pub > bltoolkit
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>