public void Construct_ShouldRunGivenScriptsOnDatabase()
{
var createTable = "create table TheTable(id int primary key, name nvarchar(128));";
var insertData = "insert into TheTable(id, name) values (1, 'one');";
var selectData = "select name from TheTable where id = 1;";
using (var db = new TempDBSqlCe(createTable, insertData))
{
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
using (var conn = new SqlCeConnection(db.ConnectionString))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = selectData;
using (var rdr = cmd.ExecuteReader())
{
Assert.IsTrue(rdr.Read());
Assert.AreEqual("one", rdr["name"].ToString());
}
}
}
//---------------Test Result -----------------------
}
}
public void Dispose_ShouldCloseManagedConnectionsBeforeAttemptingToDeleteTheFile()
{
var createTable = "create table TheTable(id int primary key, name nvarchar(128));";
var insertData = "insert into TheTable(id, name) values (1, 'one');";
var selectData = "select name from TheTable where id = 1;";
string theFile;
using (var db = new TempDBSqlCe(createTable, insertData))
{
theFile = db.DatabasePath;
Assert.IsTrue(File.Exists(theFile));
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
var conn = db.OpenConnection();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = selectData;
using (var rdr = cmd.ExecuteReader())
{
Assert.IsTrue(rdr.Read());
Assert.AreEqual("one", rdr["name"].ToString());
}
}
//---------------Execute Test ----------------------
}
//---------------Test Result -----------------------
Assert.IsFalse(File.Exists(theFile));
}
public void Dispose_ShouldRemoveTheTempDatabase()
{
//---------------Set up test pack-------------------
string file;
using (var db = new TempDBSqlCe())
{
//---------------Assert Precondition----------------
var conn = db.OpenConnection();
var cmd = conn.CreateCommand();
cmd.CommandText = "create table [test] ([id] int primary key identity, [name] nvarchar(128));";
cmd.ExecuteNonQuery();
cmd = conn.CreateCommand();
cmd.CommandText = "insert into [test] ([name]) values ('the name');";
cmd.ExecuteNonQuery();
cmd = conn.CreateCommand();
cmd.CommandText = "select * from [test];";
cmd.ExecuteReader();
file = db.DatabasePath;
Assert.IsTrue(File.Exists(file));
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
}
Assert.IsFalse(File.Exists(file));
}
public void Dispose_ShouldCloseManagedConnectionsBeforeAttemptingToDeleteTheFile()
{
var createTable = "create table TheTable(id int primary key, name nvarchar(128));";
var insertData = "insert into TheTable(id, name) values (1, 'one');";
var selectData = "select name from TheTable where id = 1;";
string theFile = null;
using (var db = new TempDBSqlCe(new[] { createTable, insertData }))
{
theFile = db.DatabaseFile;
Assert.IsTrue(File.Exists(theFile));
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
var conn = db.CreateConnection();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = selectData;
using (var rdr = cmd.ExecuteReader())
{
Assert.IsTrue(rdr.Read());
Assert.AreEqual("one", rdr["name"].ToString());
}
}
//---------------Execute Test ----------------------
}
//---------------Test Result -----------------------
Assert.IsFalse(File.Exists(theFile));
}
public void Construct_ShouldRunGivenScriptsOnDatabase()
{
var createTable = "create table TheTable(id int primary key, name nvarchar(128));";
var insertData = "insert into TheTable(id, name) values (1, 'one');";
var selectData = "select name from TheTable where id = 1;";
using (var db = new TempDBSqlCe(new[] { createTable, insertData }))
{
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
using (var conn = new SqlCeConnection(db.ConnectionString))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = selectData;
using (var rdr = cmd.ExecuteReader())
{
Assert.IsTrue(rdr.Read());
Assert.AreEqual("one", rdr["name"].ToString());
}
}
}
//---------------Test Result -----------------------
}
}
public void Construct_ShouldCreateTemporarySqlCeDatabase()
{
//---------------Set up test pack-------------------
using (var db = new TempDBSqlCe())
{
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
Assert.IsTrue(File.Exists(db.DatabasePath));
using (var conn = new SqlCeConnection(db.ConnectionString))
{
Assert.DoesNotThrow(conn.Open);
}
}
}
public void Construct_ShouldCreateTemporarySqlCeDatabase()
{
//---------------Set up test pack-------------------
using (var db = new TempDBSqlCe())
{
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
Assert.IsTrue(File.Exists(db.DatabaseFile));
using (var conn = new SqlCeConnection(db.ConnectionString))
{
Assert.DoesNotThrow(conn.Open);
}
}
}
public void Dispose_ShouldRemoveTheTempDatabase()
{
//---------------Set up test pack-------------------
string file = null;
using (var db = new TempDBSqlCe())
{
//---------------Assert Precondition----------------
var conn = db.CreateConnection();
var cmd = conn.CreateCommand();
cmd.CommandText = "create table [test] ([id] int primary key identity, [name] nvarchar(128));";
cmd.ExecuteNonQuery();
cmd = conn.CreateCommand();
cmd.CommandText = "insert into [test] ([name]) values ('the name');";
cmd.ExecuteNonQuery();
cmd = conn.CreateCommand();
cmd.CommandText = "select * from [test];";
var rdr = cmd.ExecuteReader();
file = db.DatabaseFile;
Assert.IsTrue(File.Exists(file));
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
}
Assert.IsFalse(File.Exists(file));
}
