\u5b9f\u306f java \u7248\u306e DBUnit \u306f xml \u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u306b\u884c\u304f\u3057\u3001DBUnit.net \u306f\u52d5\u4f5c\u7684\u306b\u540c\u3058\u306a\u306e\u3067\u3001\u81ea\u524d\u306e DBUnit \u3092\u4f5c\u308a\u307e\u3059\u3002
\n\u540d\u524d\u304c\u30c0\u30d6\u3063\u3066\u3044\u308b\u3051\u3069\u3001\u3053\u308c\u306f\u5f8c\u304b\u3089\u3002<\/p>\n
UIDD \u306b\u5247\u3063\u3066\u3001\u6700\u521d\u306f\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9\u3092\u3056\u3063\u304f\u308a\u3068\u4f5c\u308a\u307e\u3059\u3002
\n\u3053\u3093\u306a\u98a8\u306b\u4f7f\u3048\u308b\u3068\u3001\u30de\u30cb\u30e5\u30a2\u30eb\u306a\u3057\u3067\u3082\u4f7f\u3048\u308b\u304b\u3082\u306d\u3001\u3068\u3044\u3046\u96f0\u56f2\u6c17\u3067\u3002<\/p>\n
[code lang=”csharp”]
\nusing System;
\nusing System.Collections.Generic;
\nusing System.Text;
\nusing System.Data;
\nusing System.Data.SqlClient;
\nusing NUnit.Framework;
\nusing DBUnit.Framework;<\/p>\n
namespace Test.DBUnit
\n{
\n\t[TestFixture]
\n\tpublic class TestDBUnit
\n\t{
\n \/\/\/ <summary>
\n \/\/\/ \u524d\u51e6\u7406
\n \/\/\/ <\/summary>
\n\t\t[SetUp]
\n\t\tpublic void SetUp()
\n\t\t{
\n \/\/ \u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u3092\u4fdd\u6301
\n\t\t\tDB.Connection = new SqlConnection("");
\n\t\t}<\/p>\n
\/\/\/ <summary>
\n \/\/\/ \u5f8c\u51e6\u7406
\n \/\/\/ <\/summary>
\n [TearDown]
\n public void TearDown()
\n {
\n \/\/ \u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u3092\u524a\u9664
\n DB.Clear();
\n }<\/p>\n
\/\/\/ <summary>
\n \/\/\/ DataTable \u3092\u4f7f\u3063\u3066\u30c6\u30b9\u30c8
\n \/\/\/ <\/summary>
\n\t\t[TestCase]
\n\t\tpublic void TestSetUp()
\n\t\t{
\n\t\t\tDataTable dt = new DataTable();<\/p>\n
\t\t\tdt.TableName = "XProduct";
\n\t\t\tdt.Columns.Add( new DataColumn("ID", typeof(int) ));
\n\t\t\tdt.Columns.Add( new DataColumn("Name", typeof(string) ));
\n\t\t\tDataRow dr = dt.NewRow();
\n\t\t\tdr["ID"] = 10;
\n\t\t\tdr["Name"] = "masuda";
\n dt.Rows.Add(dr);<\/p>\n
dr = dt.NewRow();
\n dr["ID"] = 20;
\n dr["Name"] = "tomoaki";
\n dt.Rows.Add(dr);<\/p>\n
\t\t\t\/\/ \u524d\u51e6\u7406
\n\t\t\tDB.Insert(dt);<\/p>\n
DataTable result = new DataTable();
\n SqlDataAdapter da = new SqlDataAdapter(
\n "SELECT * FROM XProduct", DB.Connection);
\n da.Fill(result);<\/p>\n
Assert.AreEqual(2, result.Rows.Count);
\n Assert.AreEqual(10, result.Rows[0]["ID"]);
\n Assert.AreEqual("masuda", result.Rows[0]["Name"]);<\/p>\n
\/\/ \u5f8c\u51e6\u7406
\n\t\t\tDB.Truncate(dt);
\n\t\t}<\/p>\n
\/\/\/ <summary>
\n \/\/\/ \u72ec\u81ea\u306eDBUnit.DBTable \u3092\u4f7f\u3063\u3066\u30c6\u30b9\u30c8
\n \/\/\/ <\/summary>
\n\t\t[TestCase]
\n\t\tpublic void TestSetup2()
\n\t\t{
\n\t\t\tDBTable dt = new DBTable("XProduct");<\/p>\n
\/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u8a2d\u5b9a
\n\t\t\tdt.SetDefault(
\n "ID", 0,
\n "Name", "",
\n "Update_at", DateTime.Now);
\n \/\/ \u8a2d\u5b9a\u3059\u308b\u5217\u540d
\n\t\t\tdt.AddColumns("ID","Name");
\n \/\/ \u884c\u3092\u8a2d\u5b9a
\n\t\t\tdt.AddRow(10, "masuda");
\n\t\t\tdt.AddRow(20, "tomoaki");
\n \/\/ insert \u3092\u5b9f\u884c
\n\t\t\tdt.Insert();<\/p>\n
\/\/ \u30c7\u30fc\u30bf\u3092\u30af\u30ea\u30a2
\n\t\t\tdt.Clear();
\n\t\t\tAssert.AreEqual( 0, dt.Rows.Count );<\/p>\n
\/\/ \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u8aad\u307f\u8fbc\u307f
\n\t\t\tdt.Select();
\n\t\t\tAssert.AreEqual(2, dt.Rows.Count);
\n\t\t\tAssert.AreEqual(10, dt[0]["ID"]);
\n\t\t\tAssert.AreEqual("masuda", dt[0]["Name"]);<\/p>\n
\/\/ \u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u3092\u524a\u9664
\n\t\t\tdt.Delete();
\n\t\t}
\n\t}
\n}
\n[\/code]<\/p>\n
\u5fae\u5999\u306b\u30b3\u30fc\u30c9\u304c\u5197\u9577\u306a\u306e\u306f\u3001.NET v2.0 \u3092\u5bfe\u8c61\u306b\u3057\u3066\u3044\u308b\u304b\u3089\u3067\u3059\u3002\u624b\u5143\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c v2.0 \u306a\u306e\u3067\u305d\u308c\u306b\u5408\u308f\u305b\u3066\u4f5c\u3089\u306a\u3044\u3068\u610f\u5473\u304c\u306a\u3044\u306e\u3067\u3001\u3068\u3044\u3046\u306e\u304c\u7b2c\u4e00\u306e\u7406\u7531\u3002LINQ to SQL \u3068\u30bf\u30d7\u30eb\u306a\u3093\u304b\u3092\u4f7f\u3048\u308b\u3068\u3082\u3046\u5c11\u3057\u30de\u30b7\u306a\u30b3\u30fc\u30c9\u306b\u306a\u308b\u3068\u601d\u3046\u306e\u3067\u3059\u304c\u3001\u305d\u3053\u306f v2.0 \u304c\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u3044\u3046\u3053\u3068\u3067\u3002<\/p>\n
TestSetUp \u306e\u307b\u3046\u3067\u306f\u3001\u65e2\u5b58\u306e DataTable\/DataRow \u3092\u4f7f\u3063\u3066\u307f\u305f\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002\u30ab\u30e9\u30e0\u3092\u4f5c\u308b\u3068\u3053\u308d\u304c\u3084\u3084\u9762\u5012\u306a\u306e\u3067\u3059\u304c\u3001\u3053\u308c\u3060\u3068\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u5165\u308c\u308b\u306e\u304c\u5927\u5909\u306a\u306e\u3067\u3001\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9\u3092\u4f5c\u308b\u306e\u304c\u82e6\u52b4\u3057\u305d\u3046\u3067\u3059\u3002<\/p>\n
\u306a\u306e\u3067\u3001TestSetup2 \u306e\u3088\u3046\u306b\u3001\u3079\u305f\u3079\u305f\u306a\u4ed5\u69d8\u306b\u3059\u308b\u306e\u304c\u3044\u3044\u304b\u306a\u3068\u3002
\n\u6240\u8a6e NUnit \u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9\u306b\u3057\u304b\u4f7f\u308f\u306a\u3044\u306e\u3067\u3001\u5206\u304b\u308a\u3084\u3059\u3044\u307b\u3046\u304c\u826f\u3044\u3067\u3057\u3087\u3046\u3002\u578b\u4ed8\u306e DataTable \u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u8003\u3048\u305f\u306e\u3067\u3059\u304c\u3001\u3053\u308c\u306f\u74b0\u5883\u4f9d\u5b58\uff08\u3068\u3044\u3046\u304b\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u65b9\u91dd\u4f9d\u5b58\uff09\u306b\u306a\u308a\u305d\u3046\u306a\u306e\u3067\u3001DataTable \u98a8\u306b\u6271\u3044\u307e\u3059\u3002<\/p>\n
\u3053\u308c\u3092\u3056\u3063\u304f\u308a\u3068\u30af\u30e9\u30b9\u3068\u30e1\u30bd\u30c3\u30c9\u3092\u4f5c\u3063\u3066\u3001\u30b3\u30f3\u30d1\u30a4\u30eb\u304c\u901a\u308b\u3088\u3046\u306b\u3057\u305f\u306e\u304c\u4e0b\u8a18\u3067\u3059\u3002<\/p>\n
[code lang=”csharp”]
\nusing System;
\nusing System.Collections.Generic;
\nusing System.Text;
\nusing System.Data;
\nusing System.Data.SqlClient;<\/p>\n
namespace DBUnit.Framework
\n{
\n\tpublic class DB
\n\t{
\n public static SqlConnection Connection;
\n\t\tpublic static void Insert(DataTable dt)
\n\t\t{
\n\t\t}
\n\t\tpublic static void Delete(DataTable dt)
\n\t\t{
\n\t\t}
\n\t\tpublic static void Truncate(DataTable dt)
\n\t\t{
\n\t\t}
\n public static void Clear()
\n {
\n }
\n\t}<\/p>\n
\tpublic class DBRow
\n\t{
\n\t\tpublic int Count;
\n\t\tpublic object this[string key]
\n\t\t{
\n\t\t\tget
\n\t\t\t{
\n\t\t\t\treturn null;
\n\t\t\t}
\n\t\t}
\n\t}
\n\tpublic class DBTable
\n\t{
\n\t\tpublic string TableName;
\n\t\tpublic List<DBRow> Rows;<\/p>\n
public DBTable(string name)
\n {
\n this.TableName = name;
\n }<\/p>\n
\t\tpublic void SetDefault(params object[] ps)
\n\t\t{
\n\t\t}
\n\t\tpublic void AddColumns(params string[] columns)
\n\t\t{
\n\t\t}
\n\t\tpublic void AddRow(params object[] rows)
\n\t\t{
\n\t\t}
\n\t\tpublic void Insert()
\n\t\t{
\n\t\t}
\n\t\tpublic void Clear()
\n\t\t{
\n\t\t}
\n\t\tpublic void Select()
\n\t\t{
\n\t\t}
\n\t\tpublic void Delete()
\n\t\t{
\n\t\t}
\n\t\tpublic DBRow this[ int index ]
\n\t\t{
\n\t\t\tget
\n\t\t\t{
\n\t\t\t\treturn this.Rows[index];
\n\t\t\t}
\n\t\t}
\n\t}
\n}
\n[\/code]<\/p>\n
\u305d\u3057\u3066\u3001DBUnit \u3092 NUnit \u3092\u4f7f\u3063\u3066\u4f5c\u6210\u3059\u308b\u3001\u3068\u3044\u3046\u4e0d\u601d\u8b70\/\u5f53\u305f\u308a\u524d\u306a\u3053\u3068\u3092\u3084\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5b9f\u306f java \u7248\u306e DBUnit \u306f xml \u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u306b\u884c\u304f\u3057\u3001DBUnit.net \u306f\u52d5\u4f5c\u7684\u306b\u540c\u3058\u306a\u306e\u3067\u3001\u81ea\u524d\u306e DBUnit \u3092\u4f5c\u308a\u307e\u3059\u3002 \u540d\u524d\u304c\u30c0\u30d6\u3063\u3066\u3044\u308b\u3051\u3069\u3001\u3053\u308c\u306f\u5f8c\u304b\u3089\u3002 UIDD \u306b\u5247\u3063\u3066\u3001\u6700\u521d\u306f … \u7d9a\u304d\u3092\u8aad\u3080