Mercurial > pub > bltoolkit
diff UnitTests/DataProvider/SqlCe/CreateDatabase.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/UnitTests/DataProvider/SqlCe/CreateDatabase.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,49 @@ +using System; +using System.IO; +using BLToolkit.Data; + +using NUnit.Framework; + +namespace UnitTests.CS +{ + [TestFixture, Explicit, Category("DB setup")] + public class CreateDatabase + { + [Test] + public void Test() + { + const string path = @"..\..\..\..\Data\Create Scripts\SqlCe.sql"; + + using (DbManager db = new DbManager()) + { + string cmd = string.Empty; + string term = "GO"; + + foreach (string s in File.ReadAllLines(path)) + { + string line = s.TrimEnd(); + + if (!line.EndsWith(term)) + { + cmd += line + Environment.NewLine; + continue; + } + + line = line.Substring(0, line.Length - term.Length).Trim(); + + Console.WriteLine("Executing script:"); + Console.WriteLine(cmd + line); + + db + .SetCommand(cmd + line) + .ExecuteNonQuery() + ; + + Console.WriteLine("Succeeded."); + + cmd = string.Empty; + } + } + } + } +}