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)); }