Help with Custom AutoQuery

[mythz]

@brownm

 .Select<Product, CustomerProductMap>((p, m) =>
                new CustomerProductAssignment
                {
                    ProductId = p.Id,
                    ProductName = p.Name,
                    CustomerId = m.CustomerId,
                    IsAssigned = m.CustomerId != 0
                });

Your custom selects need to use an anonymous type, see:

Performing Join on two tables

I am currently joining two tables to retrieve the data as follows var query = Db.From<DbCore.Table1>() .Join<DbCore.Table2>((t1, t2) => t1.Id== t2.Id) .SelectDistinct<DbCore.Table1, DbCore.Table2>( (t1, t2) => new CombineSet { Id= t2.Id, Party = t1.Party }) .Where<DbCore.Table1, DbCore.Table2>( (t1, t2) => t1.Id== reqId && reqMainId.Contains(t1.MainId) && (t1.MainId== mainId||…