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>