Mercurial > pub > bltoolkit
view Tools/DocGen/Content/Doc/DataAccess/PrimaryKey.htm @ 2:79a04c6442bf
file name case fix
author | cin |
---|---|
date | Fri, 22 Aug 2014 13:41:57 +0400 |
parents | f990fcb411a9 |
children |
line wrap: on
line source
<% 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>