Code clean for main branch

[xuzhg]

Short summary (3-5 sentences) describing the issue.

Couple things to track on

1) We have lot of 'Backup' files created, for example
https://github.com/OData/odata.net/blob/main/test/FunctionalTests/Microsoft.OData.Core.Tests/Microsoft%20-%20Backup.OData.Core.Tests.csproj

https://github.com/OData/odata.net/blob/main/test/FunctionalTests/Tests/DataOData/Common/OData/Microsoft%20-%20Backup.Test.Taupo.OData.csproj

.... Fixed in #3142

They are added when creating the first version of ODL 8. I don't think we still need to keep them.

2) There's a lot of non active codes and setting. for example: Fixed in #3142

https://github.com/OData/odata.net/blob/main/src/Microsoft.OData.Core/ShippingAssemblyAttributes.cs#L24 (We don't have .NetCore version again)

or
https://github.com/OData/odata.net/blob/main/test/FunctionalTests/Microsoft.OData.Core.Tests/Microsoft.OData.Core.Tests.csproj#L74
(We don't target on .net48 again)

3. OData 8.x still use 'tt' and 'txt' file to generate the error message.
   For example: https://github.com/OData/odata.net/blob/main/src/Microsoft.OData.Edm/Microsoft.OData.Edm.txt

We should use the Resource (.resx) to replace them.

4. There's no public API test running. Since we have move to use the 'Microsoft.CodeAnalysis.PublicApiAnalyzers', maybe we don't need the old public api test???

5. For the 4 product libraries, 'Microsoft.CodeAnalysis.NetAnalyzers' is required to run 'FxCop' for code analysis. Fixed in #3142

6) Fix the nuget package vulnerable issues. Fixed in 29a1676

Reproduce steps

The simplest set of steps to reproduce the issue. If possible, reference a commit that demonstrates the issue.

Expected result

What would happen if there wasn't a bug.

Actual result

What is actually happening.

Additional detail

Optional, details of the root cause if known. Delete this section if you have no additional details to add.