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