Skip to content

Microsoft.Data.SqlClient 6.1.0 not retrieving a specific encrypted string value correctly, that 6.0.2 is fine with. #3539

@ryanhalley

Description

@ryanhalley

Describe the bug

I am taking a Cisco device configuration dumped from a SHOW command, compressing it, then encrypting it down to 10K character.
To prove this process is fine for this test, I then decrypt it immediately, and then decompress it, and I see I am back to where I started.
Using 6.0.2, if I take the encrypted string and write to the db, then retrieve it immediately and repeat the above, it decrypts fine.
Using 6.1.0 , the decrypt fails because the source string is longer than it is in the db table.

This is only occurring for one specific record out of thousands, so the nature of the string being retrieved appears to be an issue.

If I look at the length of the string in the DB it is 10748 bytes before and after retrieval in 6.0.2, but in 6.1.0 it is written to the db as 10748 but retrieved as 10783, which is the entire issue, so no need to mess around with compression or encryption.

Here's logic to retrieve the records.

			var deviceDetails = await _dbContext
				.ViewBlah
				.AsNoTracking()
				.Where(d => d.TenantId == _tenantId
					&& d.CustomerId == ciscoCustomerId
					&& d.InventoryId == ciscoInventoryId
					&& d.IsActive
					&& d.ValidatedSerialNumber != null
					&& !d.IsExcluded
					&& d.ReportMonthUtc == reportMonthUtc
					)
				.OrderBy(d => d.ProductFamily)
				.ThenBy(d => d.ValidatedSerialNumber)
				.ToListAsync(cancellationToken)
				.ConfigureAwait(false);

which refers to this table

CREATE TABLE [dbo].[Blah](
[Id] [uniqueidentifier] NOT NULL,
[TenantId] [uniqueidentifier] NOT NULL,
[CustomerId] nvarchar NOT NULL,
[InventoryId] nvarchar NOT NULL,
[DeviceId] nvarchar NOT NULL,
[ValidatedSerialNumber] nvarchar NULL,
[ProductFamily] nvarchar NOT NULL,
[StartupConfig] nvarchar NULL,
[StartupConfigDate] datetime2 NULL,
[RunningConfig] nvarchar NULL,
[RunningConfigDate] datetime2 NULL,
[LastSyncDateUtc] datetime2 NOT NULL,
CONSTRAINT [PK_Blah] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Here is the problematic encrypted 'RunningConfig' string

j5a60tHEbpVfyFl8SkCWukyanX+QHt8Mr+6m9kdRLOSd6QhlA67RC86M7f4jRkN3rdSdk0X6tgtsqcd0fig3n3+/2lbFROGVmq8i4zm1PErsNOcJG18x/ooWJTTGmhbFKgbX9UDr2ys2Dybz1WiulxT8x2bJ2mOqb3BVvmSXLp7ruoKBK1y2VawP24ywnfs6CIHWUL9v17WakFK44dcC7w8lSpjZpau0neUNrLWxJMvXOJqDpSu1J3nrZXW3aq82PES+ARe1ELFqtQTRh1FdeFzBPsIcgAuxJhW0O/mrO4BeXnArXZZRXqszEo3DM7KUlwG4hPnPc7Abd5tP4bBX5Tpdr4btvFkxXSbFSb+87b2WXAWBz/wsmBuZdkO6LHrhoEKql0183o+K/z/+ui7kHPlKIpzFHTQ03NGbOYCExR52Mu0Mu3+8k+wCHQdYThqKtjdRh4+PeTSZJ+F63ineqE5+oYCoq3cwuWfvxDXEyMKNMPQL07iP2EPxZAmaUcJY4mODXeNfA6MGMV86pY8PGb/6XiGUhVZBjR7uMjI1zbWdv2WOZG8nQYJ/tM1HdTOnuMT1m6JSjf6Xsm/PrKxmL740HFRVcP66fApU2nX3OTYW7iGyfbDS7kqvk+o9XUFOHHoc7tqpvI6/p1uvTlwWqQF0jQP0TnfrN6ZrpJm7MIogWwqXFBxO74H7j1OXkzNbIfTQAVg2KkuB3+SsXROCt71c2s/v+/09CpZIkw8qWrfKgC6rpG6aCsexQWW/qnZgB+ZvMnZ7B1a28RfuV2NhMscBSksSo1s2DNrIkmM+06TJUPvf1m0GYQ/3+hqMYCC8cFt0m6O+ahTBZ+MABnfl0HpB+2qWPsWDG2qkXDCHC5/B6xooTY00KGQGuhCA90trwjLHQ/Im68dHGlH7Nf31eN9UnFc/pPnVomN2oBpmNkDbYQYRuchwTpHsH6eWR/nl3PHmtd7VybauLGEejIPhhqDKVqqoV0Q5u0Sx00zX6iZN7N29AT+0mHedbQ87b+KjjQ0JwNemYGKrMRRCmklPFE22TTT6QW6uOMoRMwTz3pf18OReDRc1yDI5luU+c1zC+zEgTik90JYYv4EBKPRorAUqoyVz5vhqE7AwI9w6ji50dbqva8fjcaMaCSkH0mKvE+g6BqBTE7y/F5DpqUkPhy+5ORjqC2s+ey08MCWSpEJ7ZQV4VAXSNypIWHM5A0CRnsTeW78NT4iPRoTERT740RvR01QtQBc2MLi4d3ilzsChHXIYnEyGbpho2xJXOQjeUmfAqDx8UhSoRA4L2alLXh1V6r9vdAFXsbI274xUlw2wYfb99CfB9EuF1gWXXKceRtb6R8heTyV5kWQfUqRdTAELMljH6YVD3M2uUsMdJC6kINcnNPKNNGQ+xGWWHnBua7zBIGiptKGnxmTx64eAVfT3CvX7hWjc8LzOAgRzq/ZcolCMiDbnDy8lzcJUd5NPZ2tXXftWERtAlJsl81peZniFpchvBjFNijLaZ3Epaa0DFdl1mJf9e0FfKJphC7V4zk9ic973u5wBPDc2r5rq0P5GxgnUFKiUuARHRDiH2NLgy4rhR5322snnCiRKY0hAZ7F3xL9QGbDTsbrX01Ah+VTLn2MMo7t5bun9etAtcxUVxqyTFER92HV6cdj5B3tdFgGKc4fQgmmW9UIuXkUOhrm2WI55zBGl3cn/HvM/ldPhOBad/vovCAFqVrYbwV1G4doJQcpJVwHASykHwGRAGteW43Nq/JrYQjCtOD0cX9qaxZL/ni8ttyrM2RHiiwTuL1iTDwA0CawP/K/YRwlYYrj9z/q6LazzqYcn1oiZjo9PiNk1P2OEMA0bTt2mzzieXYm6RsHNckKmUjQ+fDN2BVjh5RQbJztcEjT4n8tmZ/cxr1p3oYIrtPnQl8HhDi5/MzvUzG4963HXfUKV8PQLlO6torGjpBDY3Mey/ol1PdropjH77DYQY+x+RGCnOlnnsJsqEHi9BXII2xB4x8W57+JctZwRwbBHZIbYO4msqYIUpwX6MSLRZOJB1fEbgz6Jufij+rFZ2dpCnrgV4OUo1MRRQF+DzyFeolFdMEw2iUNSh7vBI/u1Oh36FsfX1bfIchEiZ4ZkpwJ/DdP6It2c9D3tqPoeDmjT1l8ZKdsFqQsiiSDJs7BuzO4oG4z5vcftSGlU+dex7jLqhMZ3qaR1J91SXNe41I68T+PU2mS/+EhhX+wq3PYic9bISOmKjp+FGeh9YezuEyUYiy4MhQ2r/s7dM26dTQCyBB28KV49L6sP8LogfUczH7VCaYJULcdfYFXh2JLUxZ1A5LBn1Hh+kVJ7iyyYkpqjarZUUQolz/3CfaZekxsHmRvQvtfJIFgGL/GCFWTNVuSwAcAb4LDhdOlz07SVYismXcJLXu+pYo/LEdOSpZuwDiA4kTqTG4AHakOHbQMj/YGD54FIkcQidXwoN9Vq4dGZ+44gd1EcPEkZSgTWh3ifsX0xf4DNsqVQ3uxL1MWiY3KbTMlKOCphI5TjpeRmePp9a+hJsnW+NQDQT4GH8++u43pNa320gss5zxDO0KvnRzSV4TkwpLtLLb38ord/cFnJm/E3K04utA724KTAMZToxN9umSeVOPp3CVToB6XWQWH59uRJKw9nh3KzXZldgPluOlqHz/WoQSojrIE9120kFykCp3K22FriexZ1HHbTYP1COVKg1NCoOgxvGeQ6veSX/oyjLIT9/Y6lHAnnDikz2oIZdDKB0OAlJMYSveObEbYO/qtW3FFiXTx31AUGJec8xqhZbAwc7Jy4ZUtdazPIDmlemQIXz7FynO/X+j7e9JGfDkmGRvIxx8Sne7Zwcri9KfBDKvYx51yxOCIdpp/G82cZEaebRx534ex6xVvd1HFKDOaM59jks6ZB69kzDwSYAk7QvEOAbRisvHklMFCuX4f1/wm+bOqRtELKFOzXb5CJko1OLuuhCGBHhSfKGmi+apChgeHOezdExfM9YwDtmDQTFpInatmJ8iz/ntAoaloLvvnvED4mXJmXgcaARt6Zantf8Ehbo9PDtmjpJ7lHh1gya7E4m3hU9QyybKMbVisI0nYdiraRoblR/jaTvNVeXglaZPAWf3foeucqLvCQVCuZtn7FiPN79Thoxwr7ZcQ6YXUHBEQ+6lJowyr6FN+Psnkj1uL8YX9xaybig6PZAUAo/bT+88/e9AKJEE7dBDTqFwBsZ+OMgllAucp/ng0/RlCyWMS718cDTjOX2RXlHPOLM6XYjdQdL/VvENyqrqzCpGLwbbd4DDLpKIFn9hR92WolPAVBgII6I6fpba81EEsQBU5ZXxbHNmr5LjQusQR/8Bxii7mnePIyixzwcOg1uxrZ378gKSkxTREjpHl9Vd522WDWqjdXGvfHjhWFz2ZzcRQQm9oXzQbQZBdEFXDexLyyQf8/+RQSu3SYdTFzsRhQuWDoPAF8UjiTsvOz+MU2CSAape/QiS0NtxxPEsrGRq3+bK75347E+nMzrJV4Tr709Y4hYMZAlDj9gTXNhjCsACDP9DeCJMG/GRRtPc/kljy5z3+ACt0+k/CaSUQuGJgtLsyPqCurvaMtLx4WINlTJdiNmxTWkk+a8B5cSx//l0y/k/+7cWn3dGY+Mlfp+P6fQnbXQHTR3p6o8PgPl68sGBx2eQDAlu7LCyTAsMEnXa/ooCGT/yp6l9HeBHZJlsc8RBU+CuFryS6xQSnRK8kW21puBf9j/nyoktd3p1nsxvlyYTaVSsKRke2PW0C4AppPFTOoiqNdIW+kTgAyWZbk9bOKHnoGIH298w/X1qlQQsFDdGdaECAH8YOKq/WB2CnXn4i4+7xPQ9VIYERogpet2Y+cAZJJry8I/naF+UGFjSDNDAdnJX77j80sc3gmKy3FfIyGeXH4MS8dfyRTkCFMxihXtGj4WeRNwRGCtqN8GBagcvsurMn+WTADTfkz5jCpn1A/89TCvrYjKZAZBGRctd9v4QygB2J6JuaVLv+wJuE4t7kELkD/gRhK+6SIKgSGI6NkTWxzjte6BtLZa3Yw+mDI40VCQzurbczLkn0nPiZBFoThUMbfz8/sxuMUaGsgXtfw2fz8efRb/4iPZQ8sK/5wK/MYh5uXrGpJ7omNwlOs2cZcD+SbXOV57DauoAPRKLi8E7MCwfg9QkmewphPFaDJwklKnrT1R82bKdxF/2V752UkF56uuKIA5lni0+yOFnKyA0mU9KNWBYqhYUK2EbWV0FWCZrYfh0uwYfifdeA3Ath7nCSGCs5zuzMUI7as28p4NcTKBreaunnirTHiz+hemeBjUNFFSJIaAsxCCVkBGtlg29f3EFxBN9K1h8uaaSQB2GN4ETxwhs9DkRBfMmmwdNGY9vUSXeE3IpD0m09NEViSF95VYddZ8R19uDeDYpqQn00y4+QTuQsIle74M6HOUUCo92ZIvRLUxGJMKxH//1IILmBV88GYZUp25q6fTtWQM4AAYb0/aiV8Zo3xIMzvjAURQ3pNj1SqzUzm14fnoC0NET4UmkZkky4ckmkWyzVapxAncSwWyV6f+wYwWEVvb5TL7zF5mf9wCZyR+7IBTJLbr4GUmqa9DwuiicFwZS1rJpBWL/eQMZFIMtm5yKrK+qznZI2iAolUMIh5G6fG2ShbJrTSUmCzLphKfvOsVycL1hOb2RnyyWM/oeYlXetIKMFApxFDOYk1BpHz2Hj1IEqTwvWe2VlX99RLD18YmqfWu2x095QbMeUzf3xRNRXjE7Aw5k8+OORCBvBiTs+xvcg1Rssw47HbatVgVVWDmE0ZNrVi4396MP/wOwhq8edjab0UgWSp4bsJYnFxzCfXj6qqfu2IKqWvuTCvl2lAo7ringyKO9U6eWS0jE9rrH1fGE5cc9ysDzjRP0K0wTXt7EbxY6Num4FrMSbZ0NV+x+JD1gJFg8DpBHwHS9Gz1uAfRSVJUG8Yu/4dKZFYngsNn9EmRbwfDNMu+KAUNYCwcO+hkb6mFENuot290Q+/b9r59RtHEwb4Up+riLTz0o7b7E5FYZkSPQh1rhPzV3ke9Hr+PM1NrYKPa6VBZP1JfF0qS21CSttKnqb6GoRulXNW104ozM4UuBJvdL8oEaMZ/Rhczu3lTHXaZYsRLCzUcwr0vLD3VMIDepnLSudSTMje+0ljPl2QZvz5OprQ+V1+nW1+tdIV7t4zn+TK//PCtU0pPbEUn2DR9jX5tZZnPk+qdsQycGNIj6qM9MaT7C0sUy8aHXACgKifV/SiluFcWTk7F18HuTQnotmXq7MbKNtuOFGkYk1p/doq64ns/QF6nbzJarhtxVWheAGu58GJs4LbeXHI0I3mGjeuXxEXb3OhkZcRBBa7zE3tvkkqhklHD4kTWwgEzDrylBaeyAAGsW5t5VQIl22PjW7+mYEEPW6LCaM5CmWgYMLAx+GHnRnunebBfVJgvhLRT7+tLJ4okTg0fJaNtUoHzs3Im50buJ++cuwRA/Rq0PQEDYUUS7UxBC7Ybr1tjztlTA1P8WovWOzZ+xm9v6ZtPVC5jCTyuB8kIMyXlPceMzDylgkCkadOTUWCVdQS30QGWNIt0omTQ1qt9zqMY0GwGCpQKdiz1y159HymHv6Q7JQcb8Et1FJKxDVZo3oUASOpu45V8VL/8h0vooY8TMRabisI+Ba9NgFot4LvLWdNmsz7YgcC3URUqRcs9HMGSGGHSAZ1YUWfDW5AK3NI6RviKp13JlBQWPZSj9sa1sjTk/3GF0Kuno6UJJiklrPOYAvGrf4wvWV8vk9cS3VPyAP5mqO2JsChLw1LnKzKJdlq0D2IK+zESzJbjf3mGFmeNOkCqX4j9O8oVVaykgmvLom4zMygJD2vgodnH0vL2BXl2ElVnpm3VGmmwvIJB2pba/Zdad/DEqNNHblPsDalQKGl8W/nPm8PUNpH/L6vjFjUY4P072csRaVhrSOAXpKPodcuAYCRdSD/qllvxDNZJ8xTb4jR1Kn5qr/MoZicb9RQCT1DGBgGxP+gczq1msqY3aqKN8QGn2k1S+lYrrImHmVuII/GothqXrDdiP44HWeBAcqKNSSQ3JhaKtCpXXflKOz7RkJnukPkfl0PIPDBQHMjArNZNNyBRY8j/WNVmJ0kxCwtuB/1ih+M3NpG20+1rtdM/2T8pxYd5fRtIjoaR4y8Whzbu4LTyHEsl5ZJMVuDFaL9b6UIT8eV2e3zeTWqlJ8NYgn6vV72KMUs56DXGAvnRMQ92IIVf+MZclojSnqDMuo5MaGtOPGY8yJsqRv9hgnXyeg7qfSGl1Uab4a3FUMDFz6HkNdKQFrrdHLhsorCq0c4LcXjCukic42AxS92abWjYMkC/dHMJcwdMlyNOgR1JTTNgeKNncmiVER/6pRDy8IAZU0vQOsjsTVETaTwrpIJIQU8M+Zp8Ypv+b5rz9NrlKPlUX/sgGt2Td4j+N3sf/dW1TFCIrYrImWyGlZKYoBFw4DvXbuzr4aZjTCBUBWt9goJLAbxaz0Lh/g35Y7prpwJeKItcyg3e8drQ14Wj/gBumceOSYTQiUsNTsBAtqZajILr6UT9Sty/GT6n/Y2jBogTcgNtHvFUbm8UhLmDr76ZxRFDEpMGaCS7XmGsFPBaRjGDCj1mPWX544imJGLzbq4t5owkJiaEIlg9r9Ml1NAgsscxZguFVw1uSn6kj5/zIwf8rOPNc7zhqEGe/xp3Of4qumQjDax1PMy8MYoB0ywF6GNl3K6zVv6YCjhWITN9Swf0aGA3JnuYit6L9My3+W5cGWf0WoTmZvfgRlO2iAzvD0M421M+Ot4wqpjj2Z7zJjMRBgGggti6awRfzutOI1vq+7s5RAsWoIH2AyIGUhKshDIPHk2IyORmY9JEX5wpy9gDWtLQtWB8j0WQVthkpcUUDxEBXMHyxnekmk8OiI4C9bgYC19ERaVodUEGzyIzhsyogws9enyra5FzYfVejdMLFdh5sO5LM4/jH9gvPudl3zekpAVGfyleQPO3R2VyxEDpKB/Rp9m0YDvQhJkOhxYtlpiJGvVQ5+VhOexJ9k0YS+uFkMn/dc10IyqKLtN31xsdGzpkJcWkiEnGNLh0FDaNZUqapJiFencjSO/h7CfvwahSnRcSC+foUVNiNWtze/DgNP17EuZK2mrFJFZdSD1vIRh1fDA8ZtgCrWO77osxRucuM9+Lp1C4l19zlkAP9RANeCTbOCTlkvcQf0cT+2yK1Sx8ydySNLIyY7FQUduZ6E0O/8hvotgT1DivNEx9EIKSLVLEa1xNy3/xdF1ncjxZCoAKDX2DKUQ5nnPE4gh/Ebymb29OciNNbfvSTSb5zMfmGRm5c1bBzsl3lvBlF8NO2BHAo5lWSQo30QxvkfjdzOiGDDVMM3AVFHatf3j3W6yfIkitcsvVbF2y0nAsZE4RAafsloP+OeDMDT8GxFYtZYVof+tq1fFPQCk+rajlD3mzizcc5V7lV10bPumZ7xVBf5Z1lWfhQNP9DanE0U7nmaIarhFbHs78EPa9GxCJX6StRoZ0NEkzJVtT2hkOkE2dFu6UTm8eYKr1tr7ORKQ9BfoCX9W/gTvjFK2/ZBA5S0sSCFfBRmyQL+Gx6l+PPM3kSowhtUKPM82atkoaVjA2MyXYMH2AXWbG2FbXsg3qwjvhOy9A/0dwiXDTWJfdqQ0ItWxGDJXuaTVq9mSBbn65QaQdB0hpqyq/4ktxIjiqPE65NtW42agIbd14+xZfah1xcytBPom+Fa4s8tfgy5SkKPfzgKwG6hCBpJBp3YJT90Wcmvu44Z8ZgOw5sVZRfwOQAUS2ttiEi8YvpW78Z48i11SxRCdrQhgYKpvxAUUwDfQUXN6pKSqnDQWJzb5oPFegpXNsXua0ekqe8er//A4nmcHTVmAzYk2xY8uxBL2nMo6cKDZ95Eg0Ryj/KjV9QoTQW55QS8P2oNjXhrwkx8jBBaQ5CGsWJOob8QAaOtip+tPzfGSne8G8MFbOh/UZ2iwsflsab64/HsnTV61UDDwNgs+O3gtw48ijPg140iIlabaY3bOL0xpW9fVqQgRbH2s5/hC9UVpEy2ZMbAqC5QXu9STfSzQGH70xq1a2wtED7gpulq4NK3JDrNYvpIaFSqIooT31M6+tIxUVrEQ0WkyINSnF6DFEKDb2ggbZlKi6qBVcJAJxehpeqGnmAvW7QMBj8Yoh7aMumLrA9uYUBGXcS74LNNywRVldM6U9AdwKXzUvPQeZ0uYE2Iy51XXHvqIrj7LDk5vj2UcY0JHSNEky98oggkJB0i5Jf1k0extx5jldQtTAal3oPpok+fMBF2FTcs3MH7Y84NYSpNCvKz2MCiILF2+N/gLQsQFNjGq06pwx4AsTVmlyMTxtCIioJsmWyoNEpHpblmPhb8HoeAJ8w5zWht31FREjRQOH1q8nBLEDj6rNkQXVqnufXCFDImJUHOW6fpNPigbv4tu7II5rWF8y66OlymHV8kGiTCPqBGjoLs2j3xgtoXZ87Sp4iA58KIK6a6ZLEJT3X5oAo2MFbHwu6E0DlA1J6tlYR3ZsnybTYtW/Y040Q8YNkuElq+0vReEK97kxiL7UMM7tkqpBLriPUU+R/CmBU2DHwgovV9SMlGRjsysKEm38xIKNBOTeMYXHe3Sv0+lM4mTLYDqINuIsQvLJARM+P7577/+QlzvO0psw7Bm4w7FUxyW7hmr+0/yOmxQdxERE0Gbur3lNKXJER2YJWGhBVjNXgvBQBKMA90lw4xEYQgSZiVyVI5JR1ClQWfD6v7eeq22Y5dsSDpiNu35TnQrOsNdST7tHkKyXxZ4Q9TX8hS1DMeTI5IUIq91oSkOVa5aqilDhmtz1J1jv94Mbe0WlcYoAw8jpOutWLO/ap8lsNLTH7qrNR7i9R5X7tr6mghFvCFrncRM/wEfOZFfWwE2wwNMK7hZp0Fs7C37bNGu8v1IMlrvXw4UDkz6p9Ds9TVRyiSpUDlKBeiBASEOyN1cna+uEHA/yUK55Cziia60KUcowazpeeE2qpw/U6BJEbdHlxnHoctGXJd5aq4RCL0s5c5XGQPQ27fk6gBHNwDYy4881dDpNNZC4E72U/3DaMzZHQzRMPXEMEimf4Lw5critmIu2pYvj/pkaLrkpkKf4g/yMVOyznjLRDEoVpgtp/9GZS5TFJ8y0pg1930N/OWKzj1S0uJKImqrIfexEVs+PFInWWn7PhNIHKM73StC5toEi2WUV8+NMPNzDE10hDw4TdJycY9fjG5CSr2gQ6nmrdrqLZI+1c53taDIOJpj+NMyg0SIP20YiJkT7AY0rKlW0HsXH8eigy1mWgq17LoFaMKxYNEPFkiQMgGtcLcNxB2xJ1TGtsZkcMh7bVoutow6zzpgzgTfWkMnzo09aeWhsaK6Ujp72kns4DzVj8mMa6VtkPJw5ADHf+Zx6dN378hd0UMzJ600oVFGJFgmQhXRrh5+kibFUHyh7S1dMlJ5Tc7/h2tN7PuYB3Xz+LCcHOvbNaWIzyCkfTd62GYyQm/rxMYKT3AbUn3gcb2Zq2uatL1ux3eyidREwkMcP8saui9axpaOhETbURLAnu6cNpK1aqUkMVUOMYBmjKX5s3BBc2ifc36r1HA+5b/fk/sywOQaTPyMP6L1HQuvpU/dRTMyR7hdA5zIBd9mFCBsjc3dJGELH62ZJ8SpfuhM/Ywmg6J2UF1pzRIQaPnPKGIwVIyK/Y1ARGfUVsirHVJCGNBKH863YA2TeC4XZOwsaQD9C7amlcqEXo85TdD369XhuVIxOFRxcEm49uN3yenPbdt6MAFIEIS9wHo8rfZUUaUnqiY6+cDPd7Z7YHUMyjn6gEUX6Mn30pZZbdryX3ZIbAcVpaIS+1rVx6bRTkyJCYJiOrJ2L8rS06d47ES1s7Gxh5FDu5SUWNlwhUFem7K88VezbM2tRlTS68p3KLMPmEaJcCZ52uCEf8Ow6iv6uEjLZ+r5363ees6RZlKISNbNQMd2Dqqx8/1WImTNQVSAV9qSqCOAVx+c67v08tux+oWq0RcIp7DfBdHbPsIuvMU6p/nLN4iQDvjaYkB//G+h9oyeo7+55/WMlJn77cbfbnZrZ4oxS95T+JIBHyDK9mu1OYVf6P+eox5FZ7kfWDAaAJYQkzj9q2yv3geK62aOyeYEE4pQ1xQ89FTQ6afmp2nDTMGdHgjcJ0uZXzdN0nADymNvqY6173SN6ItSMq1npUc84yU2txd86sx/DTKkx42k2h8n5ym0qxVjwRVJsbNEt8cpLtmsYBDnVRT+eJpJSRo1obis6ZpI72/mWBQgvUXVWkP+yK0QoNXcpulHa2oFhs8Up//t+KrM/+kY4GPAbYsbEKpjpkivEl/pJQaINffbwGgfXB7M/L/K4dVtIpHrCo3OlMkkcwhxaSKLTLxm7fgYdaEVf3P89EgHHRlEIhDFxKuUIwQylGaZY6N5Ok3z/zYbfgw7ETloBNNA5dy0peflTIa0sBjEQOAZD80urWb3+SYM+msPPhCAB8/CyXZ07+Mg022ea1nhVLw77rc3FA0ljEL4dl+kA6fxV2P12xDE3Mz7I75G0372hrwEvd51EAWnbpt08Wm4ONM7mcOLs+Zl0NmyccO1hq4hq7/HPGBS/jL1bIfvr5/qIN8H2h2/DfjFBs1wJIDjSFXxGlgfqXvyWpDiG8+bxrYu7/LOxF63ODwXi8nynVx8Os+ayBpHr3qKNu09qQBkAwPCWyIlZZC7yfZSOBX6dTRkOIiNoWL9Q/v2318=

A small oddity I didn't expect, is when I revert to my commit before 6.1.0, the code runs fine as expected and I then upgrade to 6.1.0, rerun in debug mode and it also runs fine initially. I then clean the solution, and it then starts failing, like the DLL was still on 6.0.2 which seems weird. If I go back to my 6.0.2 commit, it always runs fine immediately, before and after a clean, so I wonder if there's a Visual Studio bug there or I'm dense and this is normal behaviour after a NuGet update.

Finally, I have two other issues that appeared after this same update, which also involve retrieval from the db - one retrieved a JSON string that is now not parsing, and the other is a weird phantom hang that I haven't looked into yet, so I think these are probably the same issue because all was well until this change.

Exception message:

The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.'

Stack trace:

   at System.Convert.FromBase64CharPtr(Char* inputPtr, Int32 inputLength)
   at System.Convert.FromBase64String(String s)
   at Portal.Data.Services.SecurityService.DecryptStringFromBytes_Aes(String cipherTextString, Byte[] key, Byte[] initializationVector) in D:\code\portal\Portal.Data\Services\SecurityService.cs:line 163
   at Portal.Data.Services.SecurityService.Decrypt(String text) in D:\code\portal\Portal.Data\Services\SecurityService.cs:line 73
   at Portal.Agent.UploadHandlers.DeviceConfigDetailsUploadHandler.<CreateDeviceConfigZipAsync>d__9.MoveNext() in D:\code\portal\Portal.Agent\UploadHandlers\DeviceConfigDetailsUploadHandler.cs:line 295

To reproduce

Include a complete code listing (or project/solution) that we can run to reproduce the issue.

Partial code listings, or multiple fragments of code, will slow down our response or cause us to push the issue back to you to provide code to reproduce the issue.

Console.WriteLine("Hello World!");

Expected behavior

The data that comes back from the db, is the data that is in the table.

Further technical details

Microsoft.Data.SqlClient version: 6.1.0 and 6.0.2
.NET target: 9.0
SQL Server version: Azure SQL Server
Operating system: Windows 11 for my local dev but failing on the server too.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions