'SqlException' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlParameter' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlConnection' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlCommand' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlParameter' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlException' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlParameter' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

'SqlCommand' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'

The behavior of 'StringBuilder.AppendLine(ref StringBuilder.AppendInterpolatedStringHandler)' could vary based on the current user's locale settings. Replace this call in 'HierarchySerializer.ToString(StringBuilder, IHierarchy<object>)' with a call to 'StringBuilder.AppendLine(IFormatProvider, ref StringBuilder.AppendInterpolatedStringHandler)'. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1305)

The behavior of 'StringBuilder.AppendLine(ref StringBuilder.AppendInterpolatedStringHandler)' could vary based on the current user's locale settings. Replace this call in 'HierarchySerializer.ToString(StringBuilder, IHierarchy<object>)' with a call to 'StringBuilder.AppendLine(IFormatProvider, ref StringBuilder.AppendInterpolatedStringHandler)'. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1305)

Unable to validate code scanning workflow: MissingPushHook

1 issue was detected with this workflow: Please specify an on.push hook to analyze and see code scanning alerts from the default branch on the Security tab.

Do not check floating point equality with exact values, use a range instead. (https://rules.sonarsource.com/csharp/RSPEC-1244)

Do not check floating point equality with exact values, use a range instead. (https://rules.sonarsource.com/csharp/RSPEC-1244)

This loop's stop condition tests 'nextWeek' and 'totalDays' but the incrementer updates 'weeks'. (https://rules.sonarsource.com/csharp/RSPEC-1994)

Use a comparison to 'default(TKey)' instead or add a constraint to 'TKey' so that it can't be a value type. (https://rules.sonarsource.com/csharp/RSPEC-2955)

Use a comparison to 'default(TKey)' instead or add a constraint to 'TKey' so that it can't be a value type. (https://rules.sonarsource.com/csharp/RSPEC-2955)

Make sure that using this pseudorandom number generator is safe here. (https://rules.sonarsource.com/csharp/RSPEC-2245)

Define a constant instead of using this literal 'Value is not in a valid state.' 4 times. (https://rules.sonarsource.com/csharp/RSPEC-1192)

Define a constant instead of using this literal 'Cannot apply assignment operator '***0***' (x >> y) to operands of type '***1***'.' 6 times. (https://rules.sonarsource.com/csharp/RSPEC-1192)

Define a constant instead of using this literal 'Cannot apply assignment operator '***0***' (x << y) to operands of type '***1***'.' 6 times. (https://rules.sonarsource.com/csharp/RSPEC-1192)