/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override County LoadFromReader(System.Data.IDataReader dr) { return(new County { Name = dr.Guard <string>("NAME"), CountyFIPS = dr.Guard <string>("GEOID").PadLeft(5, '0'), CountySSA = dr.ColumnExists("SSA") ? !string.IsNullOrEmpty(dr.Guard <string>("SSA")) ? dr.Guard <string>("SSA").PadLeft(3, '0') : null : null, State = dr.Guard <string>("USPS") }); }
public static T GetNoCachingAs <T>(this System.Data.IDataReader reader) { // Create a new Object var newObjectToReturn = Activator.CreateInstance <T>(); // Get all the properties in our Object var props = typeof(T).GetProperties(); // For each property get the data from the reader to the object foreach (var t in props) { if (reader.ColumnExists(t.Name) && reader[t.Name] != DBNull.Value) { typeof(T).InvokeMember(t.Name, BindingFlags.SetProperty, null, newObjectToReturn, new[] { reader[t.Name] }); } } return(newObjectToReturn); }