private static LookUp3Col MapLookUp3Col(IDataReader reader) { LookUp3Col lookUp = new LookUp3Col(); int idx = 0; lookUp.Id = reader.GetSafeInt32(idx++); lookUp.Code = reader.GetSafeString(idx++); lookUp.Name = reader.GetSafeString(idx++); return(lookUp); }
public List <LookUp3Col> GetLookUp3Col(string tableName) { List <LookUp3Col> list = null; string procName = $"[dbo].[{tableName}_SelectAll]"; _data.ExecuteCmd(procName, inputParamMapper : null, singleRecordMapper : delegate(IDataReader reader, short set) { LookUp3Col lookUp = MapLookUp3Col(reader); if (list == null) { list = new List <LookUp3Col>(); } list.Add(lookUp); }); return(list); }