// Deletes a role from the database
static void DeleteRole()
{
Activity dbUpdate = new DbUpdate()
{
ProviderName = providerInvariantName,
ConnectionString = connectionString,
Sql = "DELETE FROM Roles WHERE code = @code",
Parameters =
{
{ "@code", new InArgument<string>("ARCH") }
}
};
IDictionary<string, object> results = WorkflowInvoker.Invoke(dbUpdate);
Console.WriteLine("Affected records: {0}", results["AffectedRecords"].ToString());
}
// Deletes a role from the database
static void DeleteRole()
{
Activity dbUpdate = new DbUpdate()
{
ProviderName = providerInvariantName,
ConnectionString = connectionString,
Sql = "DELETE FROM Roles WHERE code = @code",
Parameters =
{
{ "@code", new InArgument <string>("ARCH") }
}
};
IDictionary <string, object> results = WorkflowInvoker.Invoke(dbUpdate);
Console.WriteLine("Affected records: {0}", results["AffectedRecords"].ToString());
}
// Insert a new record using DbUpdate
static void InsertArchRole()
{
Activity dbUpdate = new DbUpdate()
{
ProviderName = providerInvariantName,
ConnectionString = connectionString,
Sql = "INSERT INTO Roles (Code,Name) VALUES (@code, @name)",
Parameters =
{
{ "@code", new InArgument <string>("ARCH") },
{ "@name", new InArgument <string>("Architect") }
}
};
IDictionary <string, object> results = WorkflowInvoker.Invoke(dbUpdate);
Console.WriteLine("Affected records: {0}", results["AffectedRecords"].ToString());
}
// Insert a new record using DbUpdate
static void InsertArchRole()
{
Activity dbUpdate = new DbUpdate()
{
ProviderName = providerInvariantName,
ConnectionString = connectionString,
Sql = "INSERT INTO Roles (Code,Name) VALUES (@code, @name)",
Parameters =
{
{ "@code", new InArgument<string>("ARCH") },
{ "@name", new InArgument<string>("Architect") }
}
};
IDictionary<string, object> results = WorkflowInvoker.Invoke(dbUpdate);
Console.WriteLine("Affected records: {0}", results["AffectedRecords"].ToString());
}