/// <summary> /// Returns the <c>ITEM.ITEM_ID</c> value from Mapping Store for <paramref name="artefactId"/> /// </summary> /// <param name="state"> /// The state. /// </param> /// <param name="sdmxStructure"> /// The SDMX Structure. /// </param> /// <param name="artefactId"> /// The artefact primary key. <c>ARTEFACT.ART_ID</c>. /// </param> /// <returns> /// The <c>ITEM.ITEM_ID</c> value from Mapping Store for <paramref name="artefactId"/> /// </returns> /// <exception cref="ArgumentNullException"> /// <paramref name="state"/> is null /// </exception> /// <exception cref="ArgumentException"> /// At <paramref name="sdmxStructure"/>, unsupported structure /// </exception> public static ItemStatusCollection GetId(DbTransactionState state, SdmxStructureEnumType sdmxStructure, long artefactId) { if (state == null) { throw new ArgumentNullException("state"); } var tableInfo = _tableInfoBuilder.Build(sdmxStructure); if (tableInfo == null) { throw new ArgumentException(string.Format(CultureInfo.InvariantCulture, Resources.ExceptionUnsupportedStructureReferenceFormat1, sdmxStructure), "sdmxStructure"); } var itemIdQueryBuilder = new ItemIdQueryBuilder(state.Database); var query = itemIdQueryBuilder.Build(tableInfo); return(new ItemStatusCollection(state.Connection.Query <ItemStatus>( query, new { id = artefactId }, state.Transaction, false))); }
/// <summary> /// Returns the <c>ITEM.ITEM_ID</c> value from Mapping Store for <paramref name="artefactId"/> /// </summary> /// <param name="state"> /// The state. /// </param> /// <param name="sdmxStructure"> /// The SDMX Structure. /// </param> /// <param name="artefactId"> /// The artefact primary key. <c>ARTEFACT.ART_ID</c>. /// </param> /// <returns> /// The <c>ITEM.ITEM_ID</c> value from Mapping Store for <paramref name="artefactId"/> /// </returns> /// <exception cref="ArgumentNullException"> /// <paramref name="state"/> is null /// </exception> /// <exception cref="ArgumentException"> /// At <paramref name="sdmxStructure"/>, unsupported structure /// </exception> public static ItemStatusCollection GetId(DbTransactionState state, SdmxStructureEnumType sdmxStructure, long artefactId) { if (state == null) { throw new ArgumentNullException("state"); } var tableInfo = _tableInfoBuilder.Build(sdmxStructure); if (tableInfo == null) { throw new ArgumentException(string.Format(CultureInfo.InvariantCulture, Resources.ExceptionUnsupportedStructureReferenceFormat1, sdmxStructure), "sdmxStructure"); } var itemIdQueryBuilder = new ItemIdQueryBuilder(state.Database); var query = itemIdQueryBuilder.Build(tableInfo); return new ItemStatusCollection(state.Connection.Query<ItemStatus>( query, new { id = artefactId }, state.Transaction, false)); }