This project is read-only.

WF ADO.NET Activity Pack CTP 1

Rating:        Based on 7 ratings
Reviewed:  7 reviews
Downloads: 9155
Released: Apr 21, 2010
Updated: Jan 19, 2011 by ronjacobs
Dev status: Beta Help Icon

Recommended Download

Application Microsoft_WF_ADO_NET_Activity_Pack_CTP_1_Setup.msi
application, 331K, uploaded Apr 15, 2010 - 3407 downloads

Other Available Downloads

Documentation Microsoft WF ADO.NET Activity Pack CTP 1 User Guide.doc
documentation, 307K, uploaded Apr 16, 2010 - 3571 downloads
Source Code Microsoft WF ADO.Net Activity Pack CTP 1
source code, 128K, uploaded Apr 16, 2010 - 2177 downloads

Release Notes

WF ADO.NET Activity Pack CTP 1

The Microsoft WF ADO.NET Activity Pack CTP 1 is the first community technology preview (CTP) release of ADO.NET activities implementation based on Windows Workflow Foundation in .NET Framework 4 (WF 4). The implementation contains a set of activities as well as designers based on ADO.NET Data Providers, which enable access to a database through SQL commands or stored procedures within a workflow.

The Microsoft WF ADO.NET Activity Pack CTP 1 includes the following three activities:
  • ExecuteSqlQuery activity allows you to query a database using SQL statement or stored procedure and process the query result.
  • ExecuteSqlQuery<T> activity allows you to get a collection of objects from the query result to be used in the workflow.
  • ExecuteSqlNonQuery activity allows you to modify database using SQL statement or stored procedure, such as INSERT, UPDATE and DELETE.

This is not a supported release and is intended to solicit feedback on this implementation for consideration in future releases.

Reviews for this release

These Activities look great, but they are always clearing out the Body activities that I drop on to them. Has anyone else seen this? I cannot use them if they always clear out when I re-open them.
by Zero_GT on May 16, 2012 at 5:59 PM
This is an excellent activity. It should be a standard activity with the workflow toolbox. I am using it for logging my workflow during execution.
by thxmike on May 14, 2012 at 6:06 PM
I LOVE this ... I want this released as an official product!!! Been having to write my own activities for each call to SQL for years. --05/02/2011 I take it this activity is not doing well and will not be put into the mainstream of the WF4 framework?
by ddudley3 on May 2, 2011 at 2:07 PM
I agree with it being a great start. The activity designers cause an InvalidOperationException in Workflow Designer when the MySQL Connector is installed. Even though I wasn't using the MySQL provider, I had to uninstall the connector to get things working.
by Bravoleader on Apr 24, 2011 at 3:51 PM
Great start. I am working in an application hosting the WF designer and get the same error as jlafay. Can't save row processing logic so now stuck.
by alatham on Aug 6, 2010 at 11:36 AM
To the prev reviewer, importing all the activity pack assemblies into a solution added the new activities twice for me, once under Microsoft.Data.Activities header and again under Microsoft.Data.Activities.Design.Factories header. Using activities from the first category recreates the issue he describes, but using activities from the second category seems to work fine.
by latish on Aug 3, 2010 at 11:18 PM
Not quite usable yet unfortunately. In the designer, intellisense does not work for record variable in an ExecuteSqlQuery activity block. All implementation inside of the ExecuteSqlQuery's activity block repeatedly clears itself. No trend evident for me yet, but after reopening VS 2010, it has cleared again.
by jlafay on Jun 23, 2010 at 1:59 PM