protected static string[] RetrieveAll(string sql, string catalogView, RowProjection FormatRow) { string[] result; var sqltoDistr = Kiss.GetTimeout(KissTimeout.DISTRIBUTION_SQL_RETRIEVE_ALL); using (var scope = new TransactionScope(TransactionScopeOption.Suppress)) using (var kiss = new SqlConnection(Kiss.GetConnection(sql))) using (var allIds = new SqlCommand(catalogView, kiss) { CommandTimeout = sqltoDistr, CommandType = CommandType.Text }) { kiss.Open(); using (var idsTable = new DataTable()) using (var idsAdapter = new SqlDataAdapter(allIds)) { idsAdapter.Fill(idsTable); result = new string[idsTable.Rows.Count]; for (var i = 0; i < idsTable.Rows.Count; i++) { result[i] = FormatRow(idsTable.Rows[i]); } } kiss.Close(); scope.Complete(); } return(result); }
public AddColumn(string columnName, RowProjection <TResult> valueFactory) { ColumnName = columnName; ValueFactory = valueFactory; }