Mercurial > pub > bltoolkit
diff HowTo/DataAccess/Delete.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/DataAccess/Delete.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,58 @@ +using System; + +using NUnit.Framework; + +using BLToolkit.Data; +using BLToolkit.DataAccess; + +namespace HowTo.DataAccess +{ + [TestFixture] + public class Delete + { + private int Insert() + { + using (DbManager db = new DbManager()) + { + return db + .SetCommand(@" + INSERT INTO Person ( + FirstName, LastName, Gender + ) VALUES ( + @FirstName, @LastName, @Gender + ) + SELECT Cast(SCOPE_IDENTITY() as int)", + db.Parameter("@FirstName", "Crazy"), + db.Parameter("@LastName", "Frog"), + db.Parameter("@Gender", "U")) + .ExecuteScalar<int>(); + } + } + + [Test] + public void Test1() + { + int id = Insert(); + + /*[a]*/SprocQuery<Person> query = new SprocQuery<Person>()/*[/a]*/; + + query./*[a]*/DeleteByKey(id)/*[/a]*/; + } + + [Test] + public void Test3() + { + int id = Insert(); + + using (DbManager db = new DbManager()) + { + /*[a]*/SqlQuery<Person> query = new SqlQuery<Person>()/*[/a]*/; + + Person person = query.SelectByKey(db, id); + + query./*[a]*/Delete(db, person)/*[/a]*/; + } + } + } +} +