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