Mercurial > pub > bltoolkit
comparison HowTo/Data/OpenConfig3.cs @ 0:f990fcb411a9
Копия текущей версии из github
| author | cin |
|---|---|
| date | Thu, 27 Mar 2014 21:46:09 +0400 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| -1:000000000000 | 0:f990fcb411a9 |
|---|---|
| 1 using System; | |
| 2 using System.Data; | |
| 3 using System.Data.SqlClient; | |
| 4 | |
| 5 using NUnit.Framework; | |
| 6 | |
| 7 using BLToolkit.Data; | |
| 8 using BLToolkit.Data.DataProvider; | |
| 9 | |
| 10 namespace HowTo.Data | |
| 11 { | |
| 12 [TestFixture] | |
| 13 public class OpenConfig3 | |
| 14 { | |
| 15 const string connectionString = | |
| 16 "Server=.;Database=BLToolkitData;Integrated Security=SSPI"; | |
| 17 | |
| 18 [Test] | |
| 19 public void DbConnectionConfiguration() | |
| 20 { | |
| 21 using (SqlConnection con = new SqlConnection(connectionString)) | |
| 22 { | |
| 23 con.Open(); | |
| 24 | |
| 25 using (DbManager db = /*[a]*/new DbManager(con)/*[/a]*/) | |
| 26 { | |
| 27 Assert.AreEqual(ConnectionState.Open, db.Connection.State); | |
| 28 } | |
| 29 } | |
| 30 } | |
| 31 | |
| 32 [Test] | |
| 33 public void DbTransactionConfiguration() | |
| 34 { | |
| 35 using (SqlConnection con = new SqlConnection(connectionString)) | |
| 36 { | |
| 37 con.Open(); | |
| 38 | |
| 39 SqlTransaction tran = con.BeginTransaction(); | |
| 40 | |
| 41 using (DbManager db = /*[a]*/new DbManager(tran)/*[/a]*/) | |
| 42 { | |
| 43 Assert.AreEqual(ConnectionState.Open, db.Connection.State); | |
| 44 } | |
| 45 | |
| 46 tran.Commit(); | |
| 47 } | |
| 48 } | |
| 49 | |
| 50 [Test] | |
| 51 public void DataProviderConfiguration() | |
| 52 { | |
| 53 SqlDataProvider dp = new SqlDataProvider(); | |
| 54 | |
| 55 using (DbManager db = /*[a]*/new DbManager(dp, connectionString)/*[/a]*/) | |
| 56 { | |
| 57 Assert.AreEqual(ConnectionState.Open, db.Connection.State); | |
| 58 } | |
| 59 } | |
| 60 } | |
| 61 } |
