% group # Basic CRUDL operations and SQL text generation %>
<% order # 153 %>
UpdateSql.cs
<% ..\..\..\HowTo\DataAccess\UpdateSql.cs %>
DataAccessor.UpdateSql method generates and executes the following SQL statement:
<% sql #
UPDATE
[Person]
SET
[MiddleName] = @MiddleName,
[Gender] = @Gender,
[LastName] = @LastName,
[FirstName] = @FirstName
WHERE
[PersonID] = @PersonID
%>
Person.cs
<% ..\..\..\HowTo\DataAccess\Person.cs %>
Gender.cs
<% ..\..\..\HowTo\DataAccess\Gender.cs %>
App.config
<% Doc\Data\App.config %>
Create.sql script