public async Task SchemaGenerationTimeSpan()
{
var TestObject = new SQLServerSchemaGenerator(Canister.Builder.Bootstrapper.ResolveAll <ISourceBuilder>(), Canister.Builder.Bootstrapper.ResolveAll <ICommandBuilder>(), Canister.Builder.Bootstrapper.Resolve <IConfiguration>(), Helper, Helper);
var Source = await TestObject.GetSourceStructureAsync(new Connection(Configuration, SqlClientFactory.Instance, "", "Default2")).ConfigureAwait(false);
var Destination = new Modeler.Providers.Source("Default2");
var Table = Destination.AddTable("AllReferencesAndID_", "dbo");
Table.AddColumn <TimeSpan>("TimeSpanValue_", typeof(TimeSpan).To <DbType>());
var Results = TestObject.GenerateSchema(Destination, Source);
Assert.Empty(Results);
}
public async Task SchemaGenerationForeignKeysAlreadyExist()
{
var TestObject = new SQLServerSchemaGenerator(Canister.Builder.Bootstrapper.ResolveAll <ISourceBuilder>(), Canister.Builder.Bootstrapper.ResolveAll <ICommandBuilder>(), Canister.Builder.Bootstrapper.Resolve <IConfiguration>(), Helper, Helper);
var Source = await TestObject.GetSourceStructureAsync(new Connection(Configuration, SqlClientFactory.Instance, "", "Default2")).ConfigureAwait(false);
var Destination = new Modeler.Providers.Source("Default2");
var Table = Destination.AddTable("ConcreteClass3_", "dbo");
var Column1 = Table.AddColumn <int>("IInterface1_ID_", typeof(int).To <DbType>());
var Table2 = Destination.AddTable("IInterface1_", "dbo");
Table2.AddColumn <int>("ID_", typeof(int).To <DbType>());
Column1.AddForeignKey("IInterface1_", "ID_");
Table.SetupForeignKeys();
var Results = TestObject.GenerateSchema(Destination, Source);
Assert.Empty(Results);
}
