Mercurial > pub > bltoolkit
view Tools/DocGen/Content/Doc/DataAccess/PrimaryKey.htm @ 5:f7d63a092920
Исправлено условие Where в тех случаях, когда репозитарий не является генериком
author | cin |
---|---|
date | Tue, 10 Mar 2015 16:02:11 +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>