public async Task SaveTreeTest() { MsSqlServer server = new MsSqlServer() { Server = @"DESKTOP-H3A8TDA\SQLEXPRESS", IntegratedSecurity = true }; if (!await server.TestConnectionAsync()) { throw new Exception(); } Database database = new Database("northwind"); MsSqlLoader loader = new MsSqlLoader(server); await loader.LoadChildren(database); using (FileStream fs = new FileStream(Path, FileMode.OpenOrCreate)) { fs.SetLength(0); DataContractSerializer saver = new DataContractSerializer(typeof(SaveData)); saver.WriteObject(fs, new SaveData(loader, database)); } Assert.IsTrue(File.Exists(Path)); }
static void Main(string[] args) { var DatabaseLoader = new MsSqlLoader(); DatabaseLoader.Unload("Server=jean-simon-pc;database=AdventureWorks2014;User Id=jeansimon; Password=password;", @"F:\Programmation\dataLoader\fileExamples\gender=m.dataload"); DatabaseLoader.Load("Server=jean-simon-pc;database=AdventureWorks2014;User Id=jeansimon; Password=password;", @"F:\Programmation\dataLoader\fileExamples\gender=m.dataload", true); Console.Read(); //DatabaseLoader.Unload("Server=jean-simon-pc;database=AdventureWorks2014;User Id=jeansimon; Password=password;", @"F:\Programmation\dataLoader\fileExamples\gender=m.dataload"); }
public async Task LoadProperties() { MsSqlServer server = new MsSqlServer() { Server = @"DESKTOP-H3A8TDA\SQLEXPRESS", IntegratedSecurity = true }; if (!await server.TestConnectionAsync()) { throw new Exception(); } Database database = new Database("northwind"); MsSqlLoader loader = new MsSqlLoader(server); await loader.LoadProperties(database); Assert.IsTrue(database.Properties.Count != 0); }
public async Task LoadChildrenTest() { MsSqlServer server = new MsSqlServer() { Server = @"CTDLAPTOP\SQLEXPRESS", IntegratedSecurity = true }; if (!await server.TestConnectionAsync()) { throw new Exception(); } Database database = new Database("Northwnd"); MsSqlLoader loader = new MsSqlLoader(server); await loader.LoadChildren(database); Assert.IsTrue(database.Children.Count != 0); }
public async Task LoadDescription() { MsSqlServer server = new MsSqlServer() { Server = @"DESKTOP-H3A8TDA\SQLEXPRESS", IntegratedSecurity = true }; if (!await server.TestConnectionAsync()) { throw new Exception(); } Database database = new Database("northwind"); MsSqlLoader loader = new MsSqlLoader(server); await loader.LoadChildren(database); DbObject child = database.Children.First(); new MsSqlPrinterFactory().GetPrinter(child).GetDefintition(child); Assert.IsTrue(!string.IsNullOrWhiteSpace(child.Definition)); }