private void ReadInvoiceRows(Connection connection, SPCSInvoice invoice, int invoiceId) { using (TypedDataReader reader = connection.GetInvoiceRowReader(invoiceId)) { SPCSInvoiceRow invoiceRow = null; // For each invoice-row while (reader.Read()) { invoiceRow = new SPCSInvoiceRow(); { invoiceRow.InvoiceRowArticleText = reader.GetString(DataBase.InvoiceRowColumnNameArticleText); invoiceRow.InvoiceRowPriceEach = reader.GetDouble(DataBase.InvoiceRowColumnNamePriceEach); invoiceRow.InvoiceRowQuantity = reader.GetDouble(DataBase.InvoiceRowColumnNameQuantity); invoiceRow.InvoiceRowUnit = "TimAnt"; } invoice.InvoiceRows.Add(invoiceRow); } } }