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