Mercurial > pub > bltoolkit
diff HowTo/Data/ExecuteNonQuery.cs @ 0:f990fcb411a9
Копия текущей версии из 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/HowTo/Data/ExecuteNonQuery.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,53 @@ +using System; +using NUnit.Framework; +using BLToolkit.Data; + +namespace HowTo.Data +{ + using DataAccess; + + [TestFixture] + public class ExecuteNonQuery + { + [Test] + public void Test() + { + Person person = new Person(); + + person.FirstName = "John"; + person.LastName = "Smith"; + person.Gender = Gender.Male; + + using (DbManager db = new DbManager()) + { + db.BeginTransaction(); + + // Execute. + // + db + .SetSpCommand("Person_Insert", db.CreateParameters(person)) + ./*[a]*/ExecuteNonQuery/*[/a]*/(); + + // Check the result. + // + person = db + .SetCommand( + "SELECT * FROM Person WHERE LastName = @lastName", + db.Parameter("@lastName", "Smith")) + .ExecuteObject<Person>(); + + Assert.IsNotNull(person); + + // Cleanup. + // + db + .SetCommand( + "DELETE FROM Person WHERE LastName = @lastName", + db.Parameter("@lastName", "Smith")) + ./*[a]*/ExecuteNonQuery/*[/a]*/(); + + db.CommitTransaction(); + } + } + } +}