public List <InterTableDAL> GetIntertables(int skip, int take) { List <InterTableDAL> rv = new List <InterTableDAL>(); try { EnsureConnected(); using (SqlCommand command = new SqlCommand("GetInterTable", Con)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@skip", skip); command.Parameters.AddWithValue("@take", take); using (SqlDataReader reader = command.ExecuteReader()) { InterTableMapper mapper = new InterTableMapper(reader); while (reader.Read()) { InterTableDAL c = mapper.ToInterTable(reader); rv.Add(c); } } } } catch (Exception ex) { Log(ex); throw; } return(rv); }
public InterTableDAL ToInterTable(SqlDataReader r) { InterTableDAL rv = new InterTableDAL(); rv.GeckoID = GetInt32OrZero(r, GeckoIDOrdinal); rv.MorphID = GetInt32OrZero(r, MorphIDOrdinal); return(rv); }