private void CreateExecutables()
{
_Sequence = new LibCF.Sequence("Example for a sequence").AddComponent(_Package);
new LibCF.SQLTask(
"Example for a simple sql",
_ConnectionManager)
.AddComponent(_Sequence)
.AddDirectInput("create table #test ( id int not null )");
new LibCF.SQLTask(
"Example for a sql with result",
_ConnectionManager)
.AddComponent(_Sequence)
.AddDirectInput("Select 1")
.SetResultSetType(LibCF.ResultSetType.SingleRow)
.AddResultSet(new LibCF.SQLResultSet("0", SQLResultVariable));
_Sequence.ConnectAllTasks();
new LibCF.SQLTask(
"Example for a sql with parameter",
_ConnectionManager)
.AddComponent(_Package)
.AddDirectInput(@"
create table #test ( text nvarchar(50) not null )
insert into #test values( '?' )"
)
.AddParameter(new LibCF.SQLTaskParameter("0", LibCF.ParameterDirections.Input, Lib.DataType.WSTR, "ExampleVar1"));
_Package.ConnectAllTasksWithExpression("@[User::ExampleVar2] == 1");
}
public void EventHandler(LibCF.Package package, Lib.ConnectionManager connection)
{
LibCF.Sequence seq = new LibCF.Sequence("Sequence")
.AddComponent(package);
Lib.EventHandlerWrap postExecute = seq.GetPostExecuteEventHandler();
LibCF.SQLTask sqlTask = new LibCF.SQLTask("sql task", connection)
.AddComponent(seq)
.AddDirectInput("SQL");
postExecute.AddTask(sqlTask);
}
public void PrecedenceConstraint(LibCF.Sequence seq, Lib.ConnectionManager connection)
{
LibCF.SQLTask sql1 = new LibCF.SQLTask("sql task", connection)
.AddComponent(seq)
.AddDirectInput("SQL");
LibCF.SQLTask sql2 = new LibCF.SQLTask("sql task", connection)
.AddComponent(seq)
.AddDirectInput("SQL");
new LibCF.PrecedenceConstraint(sql1, sql2, "condition, e.g. 1 > 0")
.AddComponent(seq);
}