/// <summary> /// Shows how to get all records based on Search Parameters. /// </summary> private void SelectAllDynamicWhere() { // search parameters, everything is nullable, only items being searched for should be filled // note: fields with String type uses a LIKE search, everything else uses an exact match // also, every field you're searching for uses the AND operator // e.g. int? productID = 1; string productName = "ch"; // will translate to: SELECT....WHERE productID = 1 AND productName LIKE '%ch%' int? roleId = null; string roleDescription = null; DateTime?createdOn = null; string createdBy = null; DateTime?modifiedOn = null; string modifiedBy = null; List <RoleMaster> objRoleMasterCol = RoleMaster.SelectAllDynamicWhere(roleId, roleDescription, createdOn, createdBy, modifiedOn, modifiedBy); }