public static async Task BulkInserterDemo()
{
string connStr;
//initialize table
using (var conn = LocalDB.GetLocalDB("BulkInserterDemo"))
{
var cmd = new SqlCommand(@"
IF OBJECT_id('dbo.People', 'U') IS NOT NULL
DROP TABLE dbo.People;
CREATE TABLE dbo.People
(
Id INT IDENTITY(1,1) NOT NULL,
NameCol nvarchar(50) NOT NULL,
AgeCol INT NOT NULL
)
", conn);
cmd.ExecuteNonQuery();
connStr = conn.ConnectionString;
}
var f = new PeopleFlow(DataflowOptions.Default);
var dbInserter = new DbBulkInserter <Person>(connStr, "dbo.People", DataflowOptions.Default, "PersonTarget");
f.LinkTo(dbInserter);
f.Post("{Name: 'aaron', Age: 20}");
f.Post("{Name: 'bob', Age: 30}");
f.Post("{Age: 80}"); //Name will be default value: "N/A"
f.Post("{Name: 'neo' }"); // Age will be default value: -1
await f.SignalAndWaitForCompletionAsync();
await dbInserter.CompletionTask;
}
public static async Task RecorderDemo()
{
var f = new PeopleFlow(DataflowOptions.Default);
var sayHello = new ActionBlock <Person>(p => Console.WriteLine("Hello, I am {0}, {1}", p.Name, p.Age)).ToDataflow(name: "sayHello");
f.LinkTo(sayHello, p => p.Age > 0);
f.LinkLeftToNull(); //object flowing here will be recorded by GarbageRecorder
f.Post("{Name: 'aaron', Age: 20}");
f.Post("{Name: 'bob', Age: 30}");
f.Post("{Name: 'carmen', Age: 80}");
f.Post("{Name: 'neo', Age: -1}");
await f.SignalAndWaitForCompletionAsync();
await sayHello.CompletionTask;
Console.WriteLine("Total people count: " + f.PeopleRecorder[typeof(Person)]);
Console.WriteLine(f.PeopleRecorder.DumpStatistics());
Console.WriteLine(f.GarbageRecorder.DumpStatistics());
}
