public ICollection <T> SelectAll <T>() where T : class, new() { OrmMap map = mappingPool[typeof(T)]; string selectQuery = map.BuildSelectAllQuery(); using (DbConnection connection = GetOpenConnection()) { DbCommand command = connection.CreateCommand(); command.CommandText = map.BuildSelectAllQuery(); DbDataReader reader = command.ExecuteReader(); DbReaderAdapter adapter = new DbReaderAdapter(reader, map); return(adapter.GetMultipleResult <T>()); } }
public T SelectById <T>(object id) where T : class, new() { OrmMap map = mappingPool[typeof(T)]; string whereStatement = String.Format("{0}=@id", map.ID); string selectQuery = map.BuildSelectWhereQuery(whereStatement); using (DbConnection connection = GetOpenConnection()) { DbCommand command = connection.CreateCommand(); command.CommandText = selectQuery; DbParameter param = command.CreateParameter(); param.DbType = map.GetDbType(map.ID); param.ParameterName = "@id"; param.Value = id; command.Parameters.Add(param); DbDataReader reader = command.ExecuteReader(); DbReaderAdapter adapter = new DbReaderAdapter(reader, map); return(adapter.GetSingleResult <T>()); } }