Executes a SQL statement and creates an object list using Reflection.
Not very efficient but provides an easy way to retrieve object lists from queries
public virtual IEnumerable<T> QueryWithExclusions<T>(string sql, string propertiesToExclude, Object[] parameters)
Return Value
List of objects
Parameters
sql
Sql string to execute
propertiesToExclude
Comma delimited list of properties that are not to be updated
parameters
DbParameters (CreateParameter()) for named parameters
or use @0,@1 parms in SQL and plain values
Overloads:
See also:
Class DataAccessBase© West Wind Technologies, 1996-2023 • Updated: 07/15/20
Comment or report problem with topic