internal IMarket LoadMarket(IInstrument i) { MarketMapper mm = new MarketMapper(mapperHelper.context); List <IDataParameter> parameters = new List <IDataParameter>(); parameters.Add(new SqlParameter("@id", i.mrktcode)); using (IDataReader rd = mapperHelper.ExecuteReader("select code, name, description from Market where mrktcode=@id", parameters)) { if (rd.Read()) { Market m = new Market { code = rd.IsDBNull(0) ? default : rd.GetInt32(0), name = rd.IsDBNull(1) ? default : rd.GetString(1), description = rd.IsDBNull(2) ? default : rd.GetString(2) }; return(new MarketProxy(m, mapperHelper.context)); } } return(null); }
public MarketRepository(IContext ctx) { context = ctx; mapper = new MarketMapper(ctx); }