public override IPuller Init() { var options = AttributeRepository.LoadOptions(AttributeModel.Id.ToString()); var sqlScript = options.GetValue("puller_sql_script"); var truncateSQL = $@" IF EXISTS ( SELECT * FROM sys.views WHERE name = N'{AttributeModel.SourceViewName}' ) BEGIN DROP VIEW [{AttributeModel.SourceViewName}]; END "; adapter.Execute(truncateSQL); var createViewSQL = $@" CREATE VIEW [{AttributeModel.SourceViewName}] AS {sqlScript}"; adapter.Execute(createViewSQL); return(this); }
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); } }