view Tools/DocGen/Content/Doc/DataAccess/UpdateSql.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 # Basic CRUDL operations and SQL text generation %>
<% order # 153 %>

UpdateSql.cs
<% ..\..\..\HowTo\DataAccess\UpdateSql.cs %>
<i>DataAccessor.UpdateSql</i> method generates and executes the following SQL statement:
<% sql #
UPDATE
	[Person]
SET
	[MiddleName] = @MiddleName,
	[Gender]     = @Gender,
	[LastName]   = @LastName,
	[FirstName]  = @FirstName
WHERE
	[PersonID]   = @PersonID
%>
<a name='Person'></a>
Person.cs
<% ..\..\..\HowTo\DataAccess\Person.cs %>
Gender.cs
<% ..\..\..\HowTo\DataAccess\Gender.cs %>
App.config
<% Doc\Data\App.config %>
<a href="../Data/CreateSql.htm">Create.sql script</a>