fork download
copy 
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. using Microsoft.VisualStudio.TestTools.UnitTesting;
  5.  
  6. namespace UnitTestProject1
  7. {
  8.     [TestClass]
  9.     public class UnitTest1
  10.     {
  11.         [TestMethod]
  12.         public void 単一利用で再利用しない場合()
  13.         {
  14.             SampleDao dao1 = new SampleDao();
  15.             try
  16.             {
  17.                 dao1.execute();
  18.             }
  19.             catch (Exception e)
  20.             {
  21.                 Assert.Fail();
  22.             }
  23.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  24.             Assert.AreNotEqual("", dao1.Connection.ConnectionString);
  25.         }
  26.  
  27.         [TestMethod]
  28.         public void 複数利用で再利用しない場合()
  29.         {
  30.             SampleDao dao1 = new SampleDao();
  31.             SampleDao dao2 = new SampleDao();
  32.  
  33.             // 初回
  34.             try
  35.             {
  36.                 dao1.execute();
  37.             }
  38.             catch (Exception e)
  39.             {
  40.                 Assert.Fail();
  41.             }
  42.  
  43.             // 2回目
  44.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  45.             Assert.AreNotEqual("", dao1.Connection.ConnectionString);
  46.             try
  47.             {
  48.                 dao2.execute();
  49.             }
  50.             catch (Exception e)
  51.             {
  52.                 Assert.Fail();
  53.             }
  54.             Assert.AreEqual(ConnectionState.Closed, dao2.Connection.State);
  55.             Assert.AreNotEqual("", dao1.Connection.ConnectionString);
  56.         }
  57.  
  58.         [TestMethod]
  59.         public void 複数利用で再利用する場合()
  60.         {
  61.             SampleDao dao1 = new SampleDao();
  62.  
  63.             // 初回
  64.             try
  65.             {
  66.                 dao1.execute();
  67.             }
  68.             catch (Exception e)
  69.             {
  70.                 Assert.Fail();
  71.             }
  72.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  73.             Assert.AreNotEqual("", dao1.Connection.ConnectionString);
  74.  
  75.             // 2回目
  76.             try
  77.             {
  78.                 dao1.execute();
  79.             }
  80.             catch (Exception e)
  81.             {
  82.                 Assert.Fail();
  83.             }
  84.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  85.             Assert.AreNotEqual("", dao1.Connection.ConnectionString);
  86.         }
  87.  
  88.         [TestMethod]
  89.         public void using_単一利用で再利用しない場合()
  90.         {
  91.             SampleDao dao1 = new SampleDao();
  92.             try
  93.             {
  94.                 dao1.executeWithUsing();
  95.             }
  96.             catch (Exception e)
  97.             {
  98.                 Assert.Fail();
  99.             }
  100.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  101.             Assert.AreEqual("", dao1.Connection.ConnectionString);
  102.         }
  103.  
  104.         [TestMethod]
  105.         public void using_複数利用で再利用しない場合()
  106.         {
  107.             SampleDao dao1 = new SampleDao();
  108.             SampleDao dao2 = new SampleDao();
  109.  
  110.             // 初回
  111.             try
  112.             {
  113.                 dao1.executeWithUsing();
  114.             }
  115.             catch (Exception e)
  116.             {
  117.                 Assert.Fail();
  118.             }
  119.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  120.             Assert.AreEqual("", dao1.Connection.ConnectionString);
  121.  
  122.             // 2回目
  123.             try
  124.             {
  125.                 dao2.executeWithUsing();
  126.             }
  127.             catch (Exception e)
  128.             {
  129.                 Assert.Fail();
  130.             }
  131.             Assert.AreEqual(ConnectionState.Closed, dao2.Connection.State);
  132.             Assert.AreEqual("", dao1.Connection.ConnectionString);
  133.         }
  134.  
  135.         [TestMethod]
  136.         public void using_複数利用で再利用する場合()
  137.         {
  138.             SampleDao dao1 = new SampleDao();
  139.  
  140.             // 初回
  141.             try
  142.             {
  143.                 dao1.executeWithUsing();
  144.             }
  145.             catch (Exception e)
  146.             {
  147.                 Assert.Fail();
  148.             }
  149.             Assert.AreEqual(ConnectionState.Closed, dao1.Connection.State);
  150.             Assert.AreEqual("", dao1.Connection.ConnectionString);
  151.  
  152.             // 2回目
  153.             try
  154.             {
  155.                 dao1.executeWithUsing();
  156.                 Assert.Fail();
  157.             }
  158.             catch (Exception e)
  159.             {
  160.                 Assert.AreEqual("", dao1.Connection.ConnectionString);
  161.             }
  162.         }
  163.  
  164.     }
  165.  
  166.     /// <summary>
  167.     /// UTで使うためのDao
  168.     /// </summary>
  169.     public class SampleDao
  170.     {
  171.  
  172.         #region データベース接続情報
  173.         private static readonly string DB_SERVER = "localhost";
  174.         private static readonly string DB_NAME = "TESTDB";
  175.         private static readonly string DB_USER = "sa";
  176.         private static readonly string DB_PASSWORD = "test";
  177.         private static readonly string DB_CONNECTION = string.Format(
  178.                                     "server={0};database={1};User ID={2};Password={3};",
  179.                                     DB_SERVER,
  180.                                     DB_NAME,
  181.                                     DB_USER,
  182.                                     DB_PASSWORD);
  183.         #endregion
  184.  
  185.         private SqlConnection connection;
  186.         /// <summary>
  187.         /// この処理で使用するSqlConnectionオブジェクト
  188.         /// </summary>
  189.         public SqlConnection Connection
  190.         {
  191.             get { return this.connection; }
  192.             set { this.connection = value; }
  193.         }
  194.  
  195.         public SampleDao()
  196.         {
  197.             this.Connection = new SqlConnection(DB_CONNECTION);
  198.         }
  199.  
  200.         /// <summary>
  201.         /// try-finallyでCloseする
  202.         /// </summary>
  203.         public void execute()
  204.         {
  205.             SqlCommand command = new SqlCommand();
  206.             command.CommandText = "SELECT GETDATE()";
  207.             command.Connection = this.Connection;
  208.  
  209.             try { 
  210.                 command.Connection.Open();
  211.                 command.ExecuteReader();
  212.             } finally { 
  213.                 command.Connection.Close();
  214.             }
  215.         }
  216.  
  217.  
  218.         /// <summary>
  219.         /// usingでCloseする
  220.         /// </summary>
  221.         public void executeWithUsing()
  222.         {
  223.             SqlCommand command = new SqlCommand();
  224.             command.CommandText = "SELECT GETDATE()";
  225.             command.Connection = this.Connection;
  226.  
  227.             command.Connection.Open();
  228.  
  229.             using (command.Connection)
  230.             { 
  231.                 command.ExecuteReader();
  232.             }
  233.         }
  234.  
  235.     }
  236. }
  237.  
Compilation error #stdin compilation error #stdout 0s 0KB
comments ()
stdin
copy 
Standard input is empty
compilation info 
prog.cs(2,14): error CS0234: The type or namespace name `Data' does not exist in the namespace `System'. Are you missing `System.Data' assembly reference?
prog.cs(3,14): error CS0234: The type or namespace name `Data' does not exist in the namespace `System'. Are you missing `System.Data' assembly reference?
prog.cs(4,17): error CS0234: The type or namespace name `VisualStudio' does not exist in the namespace `Microsoft'. Are you missing an assembly reference?
prog.cs(185,17): error CS0246: The type or namespace name `SqlConnection' could not be found. Are you missing an assembly reference?
prog.cs(189,16): error CS0246: The type or namespace name `SqlConnection' could not be found. Are you missing an assembly reference?
Compilation failed: 5 error(s), 0 warnings
stdout
copy 
Standard output is empty
https://ideone.com/CLJpqj
language:
C# (gmcs 5.20.1)
created:
3 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!