daleholborow / iayos.dappercrud Goto Github PK

something like:

class SimpleTreeNode { childidfield, parentidfield, primaryid }

class Staff { childidfield, parentidfield, primaryid }

// return a simple tree of
var simpleTreeNodes = db.GetSimpleTree(x => x.childIdfield, x => x.parentIdfield);

var staff = db.GetTree(x => x.childidfield, x => x.parentidfield, params[] x => x.otherdynamicfieldstoselect // by default, select *);

similar to the you-know-what project where softdeletes are required, but add the ability to optionally configure this to specify which interface the user wants to use? or do they just have to use whatever i want

E.g. allow user to store static reference to some interface that defines timestamped records, e.g.
"interface ITimeStamped { }", or better yet, a new attribute that can be added to a timestamp column for concurrency checks, e.g.

then when performing an update, scan obejct for property with ConcurrencyCheckAttrribute, then if exists, append "and where RowVersion = @RowVersion", and throw error if no row updated (ie. we know row was modified in the meantime)

Had this idea to add dynamic multiparam classes, something like:

public class IaYoSMulti<TField1, TField2>
{
public TField1 Field1 {get;set;}
public TField2 Field2 {get;set;}
}

and

public class IaYoSMulti<TField1, TField2, TField3, etc>
{
public TField1 Field1 {get;set;}
public TField2 Field2 {get;set;}
public TField3 Field3 {get;set;}
etc
}

and a select that switches the WhereIn logic like:

db.GetFieldsWhereIn<TableToSelectFrom, int, string, DateTime>(
table => table.Id, idsToSelectFromList, table => table.Id, table => table.FirstName, table => table.DateOfBirth, etc
);

and extension method would look something like:

public static IaYoSMulti<T1, T2, T3> GetFieldsWhereIn<TargetTable, T1, T2, T3>(this IDbConnection db, params[] Func<TargetTable, obj> fieldsToSelect) {
--- do the select of the columns, add them in order to the IaYoSMulti<> selector
}