Walter.Web.FireWall.SqlLogger 2020.9.9.2

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package Walter.Web.FireWall.SqlLogger --version 2020.9.9.2
                    
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.9.9.2
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Walter.Web.FireWall.SqlLogger" Version="2020.9.9.2" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Walter.Web.FireWall.SqlLogger" Version="2020.9.9.2" />
                    
Directory.Packages.props
<PackageReference Include="Walter.Web.FireWall.SqlLogger" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Walter.Web.FireWall.SqlLogger --version 2020.9.9.2
                    
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.9.9.2"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.9.2
                    
Install Walter.Web.FireWall.SqlLogger as a Cake Addin
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.9.2
                    
Install Walter.Web.FireWall.SqlLogger as a Cake Tool

This package allows you to protect your firewall using annotations and pre-specified rules. A full getting started document is available at www.asp-waf.com in form of a PDF, compiled help and simple instructions

The bellow sample shows how you integrate and enable the firewall in your project and a database for reporting data.

services.AddFireWall(FireWallTrail.License, FireWallTrail.DomainKey
    , domainName: new Uri("https://www.your-domain.com", UriKind.Absolute)
    , options =>
    {
        options.Cypher.ApplicationPassword = "123456$even";
        options.ApplicationName = "Name as used for reporting";
        options.ApplicationTag = "ITIL Tag";
        options.Rules.BlockRequest.BlockDuration.SlideExpiration = true;
        options.Rules.BlockRequest.BlockDuration.Expires = TimeSpan.FromSeconds(10);

        //used by JavaScript in the browser
        options.WebServices.IsUserApiUrl = new Uri(Links.IsUserEndpoint, UriKind.Relative);
        options.WebServices.RegisterLinksApiUrl = new Uri(Links.SiteMapEndPoint, UriKind.Relative);
        options.WebServices.BeaconApiUrl = new Uri(Links.BeaconPoint, UriKind.Relative);

}).UseDatabase(ConfigurationManager.ConnectionStrings["FireWall"].ConnectionString);
//protect each MVC controller
services.AddMvc(options =>
    options.Filters.Add<Walter.Web.FireWall.Filters.FireWallFilter>()
);

The firewall is fully configurable and has quite a few options that allow you to protect against fishing, scrubbing, cross-site attach and much more.

There are a ton of configuration options available using the many annotations

   namespace MyProject.Controllers
   {
       using Walter.Web.FireWall;
       using Walter.Web.FireWall.Annotations;
       using Walter.BOM.Geo;

       [Geo(blockLocation: GeoLocation.AFRICA | GeoLocation.LATIN_AMERICA | GeoLocation.Netherlands)]
       [Users(users: UserTypes.IsHuman | UserTypes.IsSearchEngine)]
       [BlockDuration(duration: 60, sliding: true, doubleDurationPerIncedent: true)]
       public sealed class MembersController : Controller
       {
           private readonly ILogger<MembersController> _logger;
            private readonly IPageRequest _page;
           public HomeController(ILogger<MembersController> logger,IPageRequest page)
           {
               _logger = logger;
               _page=page;
           }

           public IActionResult Index()
           {
               return View();
           }


           [Ignore]
           [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
           public IActionResult Error()
           {
               //the page field will contain all the errors the user ran into
               return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });
           }
       }
   }

This is just a small set of options of what's possible

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp3.0 is compatible.  netcoreapp3.1 is compatible. 
.NET Standard netstandard2.1 is compatible. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2025.4.17.1816 179 4/17/2025
2025.3.13.1323 139 3/13/2025
2025.2.26.1642 106 2/26/2025
2025.2.25.1033 99 2/26/2025
2025.2.24.1556 93 2/25/2025
2025.2.16.1149 112 2/19/2025
2025.2.15.1316 107 2/15/2025
2025.1.16.1410 85 1/16/2025
2025.1.4.1941 115 1/4/2025
2025.1.2.1544 127 1/3/2025
2024.12.14.838 93 12/14/2024
2024.12.13.1227 92 12/13/2024
2024.11.28.1632 88 11/28/2024
2024.11.20.644 113 11/21/2024
2024.11.15.421 102 11/15/2024
2024.11.11.1334 88 11/14/2024
2024.11.6.1222 109 11/6/2024
2024.10.28.1605 96 10/28/2024
2024.10.28.1335 96 10/28/2024
2024.10.19.1525 98 10/20/2024
2024.10.18.1315 119 10/18/2024
2024.9.27.1406 108 9/27/2024
2024.9.17.1417 136 9/17/2024
2024.9.12.1923 114 9/12/2024
2024.9.6.1352 119 9/7/2024
2024.9.1.1159 124 9/1/2024
2024.8.26.1150 141 8/26/2024
2024.8.19.1411 160 8/19/2024
2024.8.17.1000 126 8/17/2024
2024.8.12.1622 136 8/13/2024
2024.8.5.1010 100 8/5/2024
2024.8.1.1545 134 8/16/2024
2024.7.28.629 82 7/28/2024
2024.7.26.1512 86 7/26/2024
2024.7.26.828 85 7/26/2024
2024.7.11.1604 136 7/11/2024
2024.7.9.1520 117 7/9/2024
2024.7.4.1425 101 7/4/2024
2024.7.3.1249 101 7/3/2024
2024.7.2.1536 125 7/2/2024
2024.6.28.953 112 6/28/2024
2023.11.13.1117 646 11/13/2023
2023.10.26.1502 592 10/29/2023
2023.10.12.1926 602 10/12/2023
2023.9.14.812 696 9/14/2023
2023.9.7.1748 685 9/7/2023
2023.9.7.1241 679 9/7/2023
2023.9.6.1001 653 9/6/2023
2023.9.5.1246 675 9/5/2023
2023.9.5.1032 670 9/5/2023
2023.8.31.1522 651 8/31/2023
2023.8.29.1040 680 8/29/2023
2023.8.17.901 752 8/17/2023
2023.8.9.1314 782 8/9/2023
2023.8.2.750 775 8/2/2023
2023.7.12.830 791 7/12/2023
2023.7.5.1419 782 7/6/2023
2023.6.14.1628 849 6/14/2023
2023.6.11.1304 827 6/11/2023
2023.5.30.1640 819 5/30/2023
2023.5.4.1552 853 5/4/2023
2023.4.29.910 866 4/29/2023
2023.4.12.1236 926 4/12/2023
2023.3.22.1456 956 3/22/2023
2023.3.14.1356 974 3/14/2023
2023.3.1.810 898 3/1/2023
2023.2.25.11857 936 2/25/2023
2023.2.22.27 983 2/22/2023
2023.2.15.1413 960 2/15/2023
2023.2.11.1628 948 2/11/2023
2023.1.11.534 1,022 1/11/2023
2022.12.30.711 1,035 12/30/2022
2022.12.15.1108 1,037 12/15/2022
2022.12.14.648 997 12/14/2022
2022.11.27.1059 1,074 11/27/2022
2022.11.21.338 1,038 11/21/2022
2022.11.14.1819 1,114 11/14/2022
2022.11.13.917 1,043 11/13/2022
2022.10.31.740 1,115 11/1/2022
2022.10.15.652 1,226 10/15/2022
2022.10.1.810 1,210 10/1/2022
2022.9.26.1444 1,226 9/26/2022
2022.9.14.1508 1,243 9/14/2022
2022.9.14.809 1,299 9/14/2022
2022.9.8.1009 1,306 9/8/2022
2022.8.20.1007 1,259 8/20/2022
2022.8.1.1 1,236 7/31/2022
2022.7.1300 1,279 7/1/2022
2022.7.31.1016 1,206 7/31/2022
2022.7.15.841 1,293 7/15/2022
2022.6.21.647 1,281 6/21/2022
2022.5.18.638 1,292 5/19/2022
2022.5.16.853 1,284 5/19/2022
2022.5.16.816 1,309 5/16/2022
2022.5.4.1010 1,258 5/4/2022
2022.4.10.947 1,410 4/10/2022
2022.4.10.925 1,329 4/10/2022
2022.4.10.828 1,335 4/10/2022
2022.4.1.1545 1,376 4/1/2022
2022.3.26.1103 1,357 3/26/2022
2022.3.26.820 1,303 3/26/2022
2022.3.25.840 1,300 3/26/2022
2022.2.16.1131 1,346 2/17/2022
2022.2.16.834 1,347 2/17/2022
2022.2.5.1114 1,416 2/5/2022
2022.1.17.1158 1,384 1/17/2022
2022.1.10.1505 1,479 1/10/2022
2022.1.10.537 1,339 1/10/2022
2022.1.5.1139 1,170 1/8/2022
2021.12.28.1452 1,186 12/28/2021
2021.12.16.812 1,273 12/16/2021
2021.11.23.1528 7,460 11/24/2021
2021.11.21.925 1,326 11/22/2021
2021.11.19.1503 1,310 11/22/2021
2021.11.19.847 1,343 11/19/2021
2021.11.18.1824 1,315 11/16/2021
2021.11.10.852 1,281 11/10/2021
2021.11.9.2021 1,437 11/9/2021
2021.11.8.2109 1,273 11/9/2021
2021.11.8.1612 1,294 11/8/2021
2021.11.7.1021 1,330 11/8/2021
2021.11.3.1612 1,433 11/4/2021
2021.11.1.1102 1,307 11/1/2021
2021.10.25.1206 1,346 10/25/2021
2021.10.23.1310 1,350 10/25/2021
2021.10.19.1522 1,329 10/19/2021
2021.10.16.1325 1,238 10/18/2021
2021.10.9.1119 97 10/9/2024
2021.10.6.1546 1,323 10/6/2021
2021.10.5.1450 1,363 10/5/2021
2021.10.4.1155 1,377 10/5/2021
2021.10.1.753 1,442 10/1/2021
2021.9.27.1005 1,343 9/28/2021
2021.9.26.1913 1,348 9/26/2021
2021.9.19.1015 1,410 9/19/2021
2021.9.17.1702 1,287 9/17/2021
2021.9.17.1449 1,320 9/17/2021
2021.9.13.1600 1,413 9/13/2021
2021.9.9.1110 1,370 9/9/2021
2021.9.7.1901 1,239 9/8/2021
2021.9.7.1121 1,395 9/7/2021
2021.9.6.1518 1,285 9/7/2021
2021.9.4.1124 1,436 9/4/2021
2021.9.2.708 1,303 9/4/2021
2021.9.0.1259 1,283 9/2/2021
2021.8.2200 1,300 8/23/2021
2021.8.2100 1,386 8/23/2021
2021.8.22.900 1,412 8/22/2021
2021.8.18.1500 1,318 8/18/2021
2021.8.18.930 1,279 8/18/2021
2021.8.14.1600 1,301 8/16/2021
2021.8.9.1105 1,283 8/9/2021
2021.8.8.1612 1,254 8/8/2021
2021.8.8.1138 1,387 8/8/2021
2021.8.6.1044 1,413 8/6/2021
2021.8.4.1355 1,366 8/5/2021
2021.7.30.2118 1,371 7/31/2021
2021.7.27.926 1,355 7/28/2021
2021.7.23.931 1,320 7/26/2021
2021.7.22.1456 1,417 7/23/2021
2021.7.15.1547 1,391 7/15/2021
2021.7.13.812 1,385 7/13/2021
2021.7.8.1527 1,538 7/10/2021
2021.7.5.1649 1,399 7/5/2021
2021.6.29.1453 1,399 6/30/2021
2021.6.26.1753 1,514 6/27/2021
2021.6.25.1849 1,353 6/25/2021
2021.6.24.1518 1,410 6/24/2021
2021.6.20.729 1,315 6/20/2021
2021.6.15.2006 1,360 6/15/2021
2021.6.14.2025 1,426 6/15/2021
2021.6.13.2035 1,322 6/14/2021
2021.6.12.1154 1,268 6/13/2021
2021.6.9.1120 1,354 6/9/2021
2021.6.3.1509 1,352 6/3/2021
2021.5.31.1533 1,372 5/31/2021
2021.5.31.1415 1,419 5/31/2021
2021.5.25.1732 1,363 5/25/2021
2021.5.24.1128 1,354 5/24/2021
2021.5.24.1019 1,290 5/24/2021
2021.5.12.1054 1,293 5/12/2021
2021.5.12.637 1,262 5/12/2021
2021.5.10.1442 1,379 5/11/2021
2021.5.8.1226 1,296 5/8/2021
2021.5.6.2037 1,342 5/6/2021
2021.5.5.1901 1,387 5/6/2021
2021.5.3.1621 1,314 5/4/2021
2021.5.1.905 1,265 5/1/2021
2021.4.28.1511 1,344 4/28/2021
2021.4.20.1520 1,285 4/21/2021
2021.4.16.738 1,316 4/21/2021
2021.4.14.1216 1,329 4/16/2021
2021.4.9.1538 1,306 4/13/2021
2021.4.8.947 1,356 4/13/2021
2021.4.6.1235 1,347 4/6/2021
2021.4.5.1653 1,314 4/5/2021
2021.4.1.913 1,306 4/1/2021
2021.3.31.2003 1,296 4/1/2021
2021.3.18.1622 1,386 3/18/2021
2021.3.3.1259 1,468 3/3/2021
2021.3.2.1415 1,464 3/2/2021
2021.3.1.11 1,412 2/28/2021
2021.3.1.1 1,451 2/27/2021
2021.3.1 1,417 2/27/2021
2021.2.23.6 1,388 2/23/2021
2021.2.21.1 1,313 2/21/2021
2021.2.20.1 1,334 2/20/2021
2021.2.19.2 1,311 2/19/2021
2021.2.18.6 1,380 2/19/2021
2021.2.17.1 1,476 2/17/2021
2021.2.16.1 1,492 2/16/2021
2021.2.15.3 1,476 2/15/2021
2021.2.15.1 1,431 2/14/2021
2021.2.14.3 1,447 2/14/2021
2021.2.12.6 1,386 2/12/2021
2021.2.12.2 1,438 2/12/2021
2021.2.11.1 1,426 2/11/2021
2021.2.10.1 1,521 2/10/2021
2021.2.8.1 1,517 2/9/2021
2021.2.7.2 1,525 2/7/2021
2021.2.7.1 1,380 2/6/2021
2020.12.27.6 1,535 12/27/2020
2020.12.27.1 1,418 12/27/2020
2020.12.26.7 1,421 12/27/2020
2020.12.26.5 1,455 12/27/2020
2020.12.26.3 1,395 12/27/2020
2020.12.19.1 1,664 12/19/2020
2020.12.16.1 1,446 12/16/2020
2020.12.15.1 1,381 12/15/2020
2020.12.14.5 1,416 12/14/2020
2020.12.14.4 1,508 12/14/2020
2020.12.14.3 1,501 12/14/2020
2020.12.4.4 1,498 12/4/2020
2020.12.4.3 1,503 12/4/2020
2020.12.3.1 1,493 12/3/2020
2020.12.2.4 1,434 12/2/2020
2020.12.2.3 1,551 12/2/2020
2020.12.1.1 1,507 12/1/2020
2020.11.28.1 1,555 11/28/2020
2020.11.27.2 1,513 11/27/2020
2020.11.27.1 1,462 11/27/2020
2020.11.25.1 1,431 11/25/2020
2020.11.22.3 1,492 11/23/2020
2020.11.20.1 1,591 11/21/2020
2020.11.19.3 1,563 11/19/2020
2020.11.19.1 1,556 11/19/2020
2020.11.18.2 1,539 11/18/2020
2020.11.17.2 1,561 11/17/2020
2020.11.17.1 1,524 11/17/2020
2020.11.15.1 1,460 11/15/2020
2020.11.14.1 1,648 11/14/2020
2020.11.13.3 1,706 11/14/2020
2020.11.13.2 1,394 11/13/2020
2020.11.13.1 1,500 11/13/2020
2020.11.12.1 1,540 11/12/2020
2020.11.11.1 1,537 11/11/2020
2020.11.8.1 1,602 11/8/2020
2020.11.7.1 1,480 11/7/2020
2020.11.5.1 1,546 11/5/2020
2020.11.3.1 1,497 11/3/2020
2020.11.1.3 1,516 11/1/2020
2020.11.1.2 1,551 11/1/2020
2020.11.1.1 1,553 11/1/2020
2020.10.30.1 1,505 11/1/2020
2020.10.15.3 1,465 10/15/2020
2020.10.15.2 1,581 10/15/2020
2020.10.14.1 1,529 10/14/2020
2020.10.13.1 1,521 10/13/2020
2020.10.12.2 1,515 10/12/2020
2020.10.12.1 1,517 10/12/2020
2020.10.10.1 1,647 10/10/2020
2020.10.9.6 1,423 10/9/2020
2020.10.9.2 1,490 10/9/2020
2020.10.9.1 1,521 10/9/2020
2020.10.8.1 1,516 10/8/2020
2020.10.6.8 1,620 10/7/2020
2020.10.6.6 1,590 10/7/2020
2020.10.6.5 1,493 10/7/2020
2020.10.6.4 1,474 10/7/2020
2020.10.6.3 1,504 10/7/2020
2020.10.6.2 1,408 10/7/2020
2020.10.6.1 1,511 10/7/2020
2020.10.5.1 1,624 10/6/2020
2020.10.1.3 1,421 10/1/2020
2020.10.1.2 1,464 10/1/2020
2020.10.1.1 1,560 10/1/2020
2020.9.29.10 1,602 9/29/2020
2020.9.29.9 1,542 9/29/2020
2020.9.28.2 1,454 9/28/2020
2020.9.28.1 1,498 9/28/2020
2020.9.25.1 1,688 9/26/2020
2020.9.24.2 1,445 9/24/2020
2020.9.24 1,503 9/24/2020
2020.9.23.2 1,489 9/23/2020
2020.9.23.1 1,504 9/23/2020
2020.9.22.1 1,437 9/22/2020
2020.9.21.1 1,563 9/21/2020
2020.9.17.2 1,499 9/17/2020
2020.9.16 1,537 9/16/2020
2020.9.15 1,546 9/15/2020
2020.9.9.2 1,479 9/9/2020
2020.9.8.1 1,474 9/8/2020
2020.9.6.5 1,580 9/6/2020
2020.9.4.2 1,485 9/4/2020
2020.9.4.1 1,538 9/4/2020
2020.9.4 1,497 9/4/2020
2020.9.3.1 1,467 9/3/2020

09 September 2020
     - update NuGet package references
     
     08 September 2020
     - Update NuGet package references

     04 September 2020
     - Update package reference to firewall package

     26 August 2020
     - Write TSQL update log for assembly and update only if previously failed of needs updated

     22 August 2020
     - Update SQL update statement for database reporting

     21 August 2020
     - Update Extension method to register database plug-in with firewall

     11 June 2020 release
     - Add support for Ticket service for incident reporting when the Walter.TicketService.ExceptionReporting is set to true (default false)

     28 May 2020:  Changes in 1.0.0.4 release
     - Updated fluent API for registration with dependency framework

     21 Dec 2019
     - Initial release uploaded for development. Still in beta release