public override IPuller Init() { var options = AttributeRepository.LoadOptions(AttributeModel.Id.ToString()); var sqlScript = options.GetValue("puller_sql_script"); var viewExists = adapter.GetView(AttributeModel.SourceViewName); if (viewExists != null) { adapter.DropView(AttributeModel.SourceViewName); } var createViewSQL = $@" CREATE VIEW {AttributeModel.SourceViewName} AS {sqlScript}"; adapter.Execute(createViewSQL); return(this); }
public override IPuller Init() { using (var entityRepository = ResolverFactory.Resolve <EntityRepository>()) { var options = entityRepository.LoadOptions(EntityModel.Id.ToString()); var sqlScript = options.GetValue("puller_sql_script"); var viewExists = adapter.GetView(EntityModel.SourceViewName); if (viewExists != null) { adapter.DropView(EntityModel.SourceViewName); } var createViewSQL = $@" CREATE VIEW {EntityModel.SourceViewName} AS {sqlScript}"; adapter.Execute(createViewSQL); return(this); } }