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 TempDBSqlite(createTable, insertData))
{
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
using (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());
}
}
}
//---------------Test Result -----------------------
}
}
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 TempDBSqlite(new[] { createTable, insertData }))
{
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
using (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());
}
}
}
//---------------Test Result -----------------------
}
}
public void Dispose_ShouldRemoveTheTempDatabase()
{
//---------------Set up test pack-------------------
string file = null;
using (var db = new TempDBSqlite())
{
//---------------Assert Precondition----------------
file = db.DatabaseFile;
Assert.IsTrue(File.Exists(file));
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
}
Assert.IsFalse(File.Exists(file));
}
public void Dispose_ShouldRemoveTheTempDatabase()
{
//---------------Set up test pack-------------------
string file;
using (var db = new TempDBSqlite())
{
//---------------Assert Precondition----------------
file = db.DatabasePath;
Assert.IsTrue(File.Exists(file));
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
}
Assert.IsFalse(File.Exists(file));
}
public void Construct_ShouldCreateTemporarySqliteDatabase()
{
//---------------Set up test pack-------------------
using (var db = new TempDBSqlite())
{
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
Assert.IsTrue(File.Exists(db.DatabasePath));
using (var conn = new SQLiteConnection(db.ConnectionString))
{
Assert.DoesNotThrow(conn.Open);
}
}
}
public void Construct_ShouldCreateTemporarySqlCeDatabase()
{
//---------------Set up test pack-------------------
using (var db = new TempDBSqlite())
{
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
Assert.IsTrue(File.Exists(db.DatabaseFile));
using (var conn = new SqlCeConnection(db.ConnectionString))
{
Assert.DoesNotThrow(conn.Open);
}
}
}
