René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SqlBulkAsync throws error System.ArgumentException: Value does not fall within the expected range.","articleBody":"This test case throws an exception.\r\n   ```\r\npublic async Task BulkNotWorking()\r\n    {\r\n        var data = new List\u003cScenario\u003e()\r\n        {\r\n            new Scenario { Id = -3, Name = \"test1\", PeriodYear = 2023,  },\r\n            new Scenario { Id = -4, Name = \"test1\", PeriodYear = 2023,  },\r\n        };\r\n\r\n        var query = @\"insert into XXDM.ST_SCENARIO (ID, NAME, PERIOD_YEAR)\r\n                      values (:ID, :NAME, :PERIOD_YEAR)\";\r\n        var mapping = new BulkMapping\u003cScenario\u003e[]\r\n        {\r\n            new BulkMapping\u003cScenario\u003e(\"ID\", x =\u003e x.Id.Value),\r\n            new BulkMapping\u003cScenario\u003e(\"NAME\", x =\u003e x.Name),\r\n            new BulkMapping\u003cScenario\u003e(\"PERIOD_YEAR\", x =\u003e x.PeriodYear),\r\n        };\r\n\r\n        using var connection = client.GetConnection();\r\n        await connection.SqlBulkAsync(query, data, mapping).ConfigureAwait(false);\r\n    }\r\n\r\n```\r\n\r\nIf I add appropriate OracleMappingType.xxxx to each of the mappings, like this, it works:\r\n\r\n\u003e new BulkMapping\u003cScenario\u003e(\"ID\", x =\u003e x.Id.Value, OracleMappingType.Int32),\r\n\r\nThe exception is:\r\n\r\n\u003e System.ArgumentException: Value does not fall within the expected range.\r\n\u003e \r\n\u003e   Stack Trace: \r\n\u003e OracleParameter.set_Value(Object value)\r\n\u003e OracleDynamicParameters.AddParameters(IDbCommand command, Identity identity)\r\n\u003e IDynamicParameters.AddParameters(IDbCommand command, Identity identity)\r\n\u003e \u003c\u003ec__DisplayClass165_0.\u003cGetCacheInfo\u003eb__0(IDbCommand cmd, Object obj) line 1738\r\n\u003e CommandDefinition.SetupCommand(IDbConnection cnn, Action`2 paramReader) line 128\r\n\u003e SqlMapper.TrySetupAsyncCommand(CommandDefinition command, IDbConnection cnn, Action`2 paramReader) line 396\r\n\u003e SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) line 642\r\n\u003e BulkOperation.SqlBulkAsync[T](IDbConnection connection, String sql, IEnumerable`1 objects, IEnumerable`1 mapping, Nullable`1 cmdType, IDbTransaction transaction)\r\n\u003e OracleScenarioRepository.BulkNotWorking() line 114\r\n\u003e BulkTester.TestBulkInsert() line 18\r\n\u003e ThreadOperations.ExecuteWithAbortSafety(Action action)\r\n\r\n\r\nFinally, this issue was mentioned in [https://github.com/DIPSAS/Dapper.Oracle/issues/49](url), but no suggestions or resolution was provided.","author":{"url":"https://github.com/dev-jlb","@type":"Person","name":"dev-jlb"},"datePublished":"2023-03-09T22:14:31.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/61/Dapper.Oracle/issues/61"}