MonkeyWrench.DB.GetWork C# (CSharp) Method

		public List<DBWorkView2> GetWork (DBRevisionWork revisionwork)
		{
			List<DBWorkView2> result = new List<DBWorkView2> ();

			using (IDbCommand cmd = CreateCommand ()) {
				cmd.CommandText = "SELECT * FROM WorkView2 WHERE revisionwork_id = @revisionwork_id ORDER BY sequence";
				DB.CreateParameter (cmd, "revisionwork_id", revisionwork.id);
				using (IDataReader reader = cmd.ExecuteReader ()) {
					while (reader.Read ())
						result.Add (new DBWorkView2 (reader));
				}
			}
			return result;
		}