public static IList <ContactInfoEntity> GetByVesteeId(string vesteeId) { var sql = string.Format("SELECT {0} FROM contact_info WHERE vestee_id=@p_vestee_id", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_vestee_id", DbType.String, vesteeId); var list = new List <ContactInfoEntity>(); using (IDataReader reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new ContactInfoEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
public static ContactInfoEntity Get(string id) { var sql = string.Format("SELECT {0} FROM contact_info WHERE id=@p_id", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, id); using (IDataReader reader = db.ExecuteReader(dc)) { if (reader.Read()) { var entity = new ContactInfoEntity(); entity.Init(reader); return(entity); } else { return(null); } } }