SqlFu3 in action

sfu3-in-action.cs

 //selecting related assets from a view then processing each row 
 //into a RelatedItem which gets added to a result
 
//generated sql is 
//select [Id],[Type],[Name],[ContextId] from [AssetUsagesView]
//where ((([AssetId] = @0) and ([ProjectId] = @1)) and [Category] in (@3,@4))
 using (var db = await _db.CreateAsync(cancel))
{
                await db.QueryAndProcessAsync(
                    q =>
                        q.From<AssetUsagesViewRow>()
                        .Where(d=>d.AssetId==input.AssetId && d.ProjectId==input.ProjectId.Value 
                        && new[] {LinkCategory.CmdTriggers.ToString(),LinkCategory.TriggerEvents.ToString()}.Contains(d.Category))
                        .Select(d=>new AssetBasicInfo())
                        , a =>
                            {
                                rez.Add(new RelatedItem(a));
                                return true;
                            },cancel);
}