public void CanCreateSchema() { var mapper = new AutoMapper(); var map = mapper.GetMap(typeof(SomeClass)); var properties = map.Properties; var keyProperties = properties.Where(p => p.IsKey); var creator = new SchemaManager(new SqlConnectionFactory(ConnectionString), "testtable", "testdata", "testproc", keyProperties, properties, schema: "bimse"); creator.DropSchema(true, true, true); creator.CreateSchema(true, true, true); }
public void CanCreateSchema() { using var connection = new SqlConnection(ConnectionString); connection.Open(); using var command = connection.CreateCommand(); command.CommandText = @" if not exists (select top 1 * from [sys].[schemas] where [name] = 'bimse') exec('create schema bimse'); "; command.ExecuteNonQuery(); var mapper = new AutoMapper(); var map = mapper.GetMap(typeof(SomeClass)); var properties = map.Properties; var keyProperties = properties.Where(p => p.IsKey); var creator = new SchemaManager(new SqlConnectionFactory(ConnectionString), "testtable", "testdata", "testproc", keyProperties, properties, schema: "bimse"); creator.DropSchema(true, true, true); creator.CreateSchema(true, true, true); }