Mercurial > pub > bltoolkit

diff Tools/DocGen/Content/Doc/DataAccess/UpdateSql.htm @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Tools/DocGen/Content/Doc/DataAccess/UpdateSql.htm	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,25 @@
+<% 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>