view Tools/DocGen/Content/Doc/DataAccess/TableName.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>TableName</b> attribute specifies a name of the table represented by the decorated object.
</p>

TableName.cs
<% ..\..\..\HowTo\DataAccess\TableName.cs %>
<i>DataAccessor.SelectByKeySql</i> and <i>DataAccessor.SelectByKey</i> methods generate and execute the following SQL statement:
<% sql #
-- SelectByKeySql
SELECT
	[MiddleName],
	[PersonID],
	[LastName],
	[FirstName]
FROM
	[Person]
WHERE
	[PersonID] = @PersonID

-- SelectByKey
exec Person_SelectByKey @id=1
%>
App.config
<% Doc\Data\App.config %>
<a href="../Data/CreateSql.htm">Create.sql script</a>