Mercurial > pub > bltoolkit
view Tools/DocGen/Content/Doc/DataAccess/PrimaryKey.htm @ 9:1e85f66cf767 default tip
update bltoolkit
author | nickolay |
---|---|
date | Thu, 05 Apr 2018 20:53:26 +0300 |
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>