Walter.Web.FireWall.SqlLogger 2020.9.28.1

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.28.1
                    
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.9.28.1
                    
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.28.1" />
                    
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.28.1" />
                    
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.28.1
                    
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.9.28.1"
                    
#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.
#:package Walter.Web.FireWall.SqlLogger@2020.9.28.1
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.28.1
                    
Install as a Cake Addin
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.28.1
                    
Install 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 for the database logger

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.8.13.1223 148 8/13/2025
2025.7.30.1003 103 7/30/2025
2025.7.10.1347 151 7/10/2025
2025.6.30.1407 146 7/1/2025
2025.6.12.1057 303 6/12/2025
2025.4.17.1816 219 4/17/2025
2025.3.13.1323 161 3/13/2025
2025.2.26.1642 126 2/26/2025
2025.2.25.1033 132 2/26/2025
2025.2.24.1556 128 2/25/2025
2025.2.16.1149 141 2/19/2025
2025.2.15.1316 128 2/15/2025
2025.1.16.1410 123 1/16/2025
2025.1.4.1941 136 1/4/2025
2025.1.2.1544 147 1/3/2025
2024.12.14.838 117 12/14/2024
2024.12.13.1227 113 12/13/2024
2024.11.28.1632 119 11/28/2024
2024.11.20.644 135 11/21/2024
2024.11.15.421 122 11/15/2024
2024.11.11.1334 116 11/14/2024
2024.11.6.1222 132 11/6/2024
2024.10.28.1605 123 10/28/2024
2024.10.28.1335 114 10/28/2024
2024.10.19.1525 128 10/20/2024
2024.10.18.1315 147 10/18/2024
2024.9.27.1406 135 9/27/2024
2024.9.17.1417 164 9/17/2024
2024.9.12.1923 141 9/12/2024
2024.9.6.1352 138 9/7/2024
2024.9.1.1159 146 9/1/2024
2024.8.26.1150 170 8/26/2024
2024.8.19.1411 192 8/19/2024
2024.8.17.1000 155 8/17/2024
2024.8.12.1622 155 8/13/2024
2024.8.5.1010 119 8/5/2024
2024.8.1.1545 162 8/16/2024
2024.7.28.629 107 7/28/2024
2024.7.26.1512 118 7/26/2024
2024.7.26.828 108 7/26/2024
2024.7.11.1604 167 7/11/2024
2024.7.9.1520 150 7/9/2024
2024.7.4.1425 122 7/4/2024
2024.7.3.1249 125 7/3/2024
2024.7.2.1536 156 7/2/2024
2024.6.28.953 139 6/28/2024
2023.11.13.1117 669 11/13/2023
2023.10.26.1502 617 10/29/2023
2023.10.12.1926 624 10/12/2023
2023.9.14.812 722 9/14/2023
2023.9.7.1748 719 9/7/2023
2023.9.7.1241 721 9/7/2023
2023.9.6.1001 685 9/6/2023
2023.9.5.1246 718 9/5/2023
2023.9.5.1032 717 9/5/2023
2023.8.31.1522 693 8/31/2023
2023.8.29.1040 732 8/29/2023
2023.8.17.901 793 8/17/2023
2023.8.9.1314 829 8/9/2023
2023.8.2.750 828 8/2/2023
2023.7.12.830 837 7/12/2023
2023.7.5.1419 823 7/6/2023
2023.6.14.1628 899 6/14/2023
2023.6.11.1304 882 6/11/2023
2023.5.30.1640 868 5/30/2023
2023.5.4.1552 901 5/4/2023
2023.4.29.910 909 4/29/2023
2023.4.12.1236 971 4/12/2023
2023.3.22.1456 1,008 3/22/2023
2023.3.14.1356 1,028 3/14/2023
2023.3.1.810 940 3/1/2023
2023.2.25.11857 990 2/25/2023
2023.2.22.27 1,039 2/22/2023
2023.2.15.1413 1,012 2/15/2023
2023.2.11.1628 992 2/11/2023
2023.1.11.534 1,073 1/11/2023
2022.12.30.711 1,089 12/30/2022
2022.12.15.1108 1,114 12/15/2022
2022.12.14.648 1,043 12/14/2022
2022.11.27.1059 1,116 11/27/2022
2022.11.21.338 1,082 11/21/2022
2022.11.14.1819 1,170 11/14/2022
2022.11.13.917 1,086 11/13/2022
2022.10.31.740 1,158 11/1/2022
2022.10.15.652 1,283 10/15/2022
2022.10.1.810 1,266 10/1/2022
2022.9.26.1444 1,281 9/26/2022
2022.9.14.1508 1,290 9/14/2022
2022.9.14.809 1,351 9/14/2022
2022.9.8.1009 1,363 9/8/2022
2022.8.20.1007 1,316 8/20/2022
2022.8.1.1 1,295 7/31/2022
2022.7.1300 1,326 7/1/2022
2022.7.31.1016 1,260 7/31/2022
2022.7.15.841 1,356 7/15/2022
2022.6.21.647 1,334 6/21/2022
2022.5.18.638 1,350 5/19/2022
2022.5.16.853 1,335 5/19/2022
2022.5.16.816 1,374 5/16/2022
2022.5.4.1010 1,316 5/4/2022
2022.4.10.947 1,464 4/10/2022
2022.4.10.925 1,383 4/10/2022
2022.4.10.828 1,401 4/10/2022
2022.4.1.1545 1,438 4/1/2022
2022.3.26.1103 1,418 3/26/2022
2022.3.26.820 1,364 3/26/2022
2022.3.25.840 1,362 3/26/2022
2022.2.16.1131 1,399 2/17/2022
2022.2.16.834 1,406 2/17/2022
2022.2.5.1114 1,475 2/5/2022
2022.1.17.1158 1,434 1/17/2022
2022.1.10.1505 1,540 1/10/2022
2022.1.10.537 1,397 1/10/2022
2022.1.5.1139 1,221 1/8/2022
2021.12.28.1452 1,251 12/28/2021
2021.12.16.812 1,327 12/16/2021
2021.11.23.1528 7,513 11/24/2021
2021.11.21.925 1,379 11/22/2021
2021.11.19.1503 1,367 11/22/2021
2021.11.19.847 1,394 11/19/2021
2021.11.18.1824 1,368 11/16/2021
2021.11.10.852 1,347 11/10/2021
2021.11.9.2021 1,494 11/9/2021
2021.11.8.2109 1,336 11/9/2021
2021.11.8.1612 1,361 11/8/2021
2021.11.7.1021 1,387 11/8/2021
2021.11.3.1612 1,486 11/4/2021
2021.11.1.1102 1,376 11/1/2021
2021.10.25.1206 1,398 10/25/2021
2021.10.23.1310 1,409 10/25/2021
2021.10.19.1522 1,381 10/19/2021
2021.10.16.1325 1,290 10/18/2021
2021.10.9.1119 127 10/9/2024
2021.10.6.1546 1,383 10/6/2021
2021.10.5.1450 1,421 10/5/2021
2021.10.4.1155 1,429 10/5/2021
2021.10.1.753 1,493 10/1/2021
2021.9.27.1005 1,396 9/28/2021
2021.9.26.1913 1,410 9/26/2021
2021.9.19.1015 1,472 9/19/2021
2021.9.17.1702 1,349 9/17/2021
2021.9.17.1449 1,380 9/17/2021
2021.9.13.1600 1,465 9/13/2021
2021.9.9.1110 1,431 9/9/2021
2021.9.7.1901 1,301 9/8/2021
2021.9.7.1121 1,455 9/7/2021
2021.9.6.1518 1,347 9/7/2021
2021.9.4.1124 1,500 9/4/2021
2021.9.2.708 1,362 9/4/2021
2021.9.0.1259 1,343 9/2/2021
2021.8.2200 1,360 8/23/2021
2021.8.2100 1,443 8/23/2021
2021.8.22.900 1,475 8/22/2021
2021.8.18.1500 1,380 8/18/2021
2021.8.18.930 1,343 8/18/2021
2021.8.14.1600 1,355 8/16/2021
2021.8.9.1105 1,333 8/9/2021
2021.8.8.1612 1,316 8/8/2021
2021.8.8.1138 1,446 8/8/2021
2021.8.6.1044 1,483 8/6/2021
2021.8.4.1355 1,430 8/5/2021
2021.7.30.2118 1,428 7/31/2021
2021.7.27.926 1,413 7/28/2021
2021.7.23.931 1,378 7/26/2021
2021.7.22.1456 1,476 7/23/2021
2021.7.15.1547 1,457 7/15/2021
2021.7.13.812 1,441 7/13/2021
2021.7.8.1527 1,593 7/10/2021
2021.7.5.1649 1,450 7/5/2021
2021.6.29.1453 1,461 6/30/2021
2021.6.26.1753 1,572 6/27/2021
2021.6.25.1849 1,405 6/25/2021
2021.6.24.1518 1,470 6/24/2021
2021.6.20.729 1,365 6/20/2021
2021.6.15.2006 1,412 6/15/2021
2021.6.14.2025 1,481 6/15/2021
2021.6.13.2035 1,385 6/14/2021
2021.6.12.1154 1,322 6/13/2021
2021.6.9.1120 1,412 6/9/2021
2021.6.3.1509 1,412 6/3/2021
2021.5.31.1533 1,426 5/31/2021
2021.5.31.1415 1,480 5/31/2021
2021.5.25.1732 1,421 5/25/2021
2021.5.24.1128 1,414 5/24/2021
2021.5.24.1019 1,348 5/24/2021
2021.5.12.1054 1,344 5/12/2021
2021.5.12.637 1,319 5/12/2021
2021.5.10.1442 1,439 5/11/2021
2021.5.8.1226 1,352 5/8/2021
2021.5.6.2037 1,394 5/6/2021
2021.5.5.1901 1,450 5/6/2021
2021.5.3.1621 1,367 5/4/2021
2021.5.1.905 1,331 5/1/2021
2021.4.28.1511 1,408 4/28/2021
2021.4.20.1520 1,349 4/21/2021
2021.4.16.738 1,378 4/21/2021
2021.4.14.1216 1,394 4/16/2021
2021.4.9.1538 1,372 4/13/2021
2021.4.8.947 1,414 4/13/2021
2021.4.6.1235 1,408 4/6/2021
2021.4.5.1653 1,379 4/5/2021
2021.4.1.913 1,359 4/1/2021
2021.3.31.2003 1,354 4/1/2021
2021.3.18.1622 1,447 3/18/2021
2021.3.3.1259 1,536 3/3/2021
2021.3.2.1415 1,529 3/2/2021
2021.3.1.11 1,481 2/28/2021
2021.3.1.1 1,513 2/27/2021
2021.3.1 1,485 2/27/2021
2021.2.23.6 1,441 2/23/2021
2021.2.21.1 1,376 2/21/2021
2021.2.20.1 1,394 2/20/2021
2021.2.19.2 1,365 2/19/2021
2021.2.18.6 1,444 2/19/2021
2021.2.17.1 1,538 2/17/2021
2021.2.16.1 1,565 2/16/2021
2021.2.15.3 1,537 2/15/2021
2021.2.15.1 1,502 2/14/2021
2021.2.14.3 1,518 2/14/2021
2021.2.12.6 1,447 2/12/2021
2021.2.12.2 1,491 2/12/2021
2021.2.11.1 1,481 2/11/2021
2021.2.10.1 1,583 2/10/2021
2021.2.8.1 1,576 2/9/2021
2021.2.7.2 1,596 2/7/2021
2021.2.7.1 1,443 2/6/2021
2020.12.27.6 1,604 12/27/2020
2020.12.27.1 1,484 12/27/2020
2020.12.26.7 1,486 12/27/2020
2020.12.26.5 1,523 12/27/2020
2020.12.26.3 1,461 12/27/2020
2020.12.19.1 1,734 12/19/2020
2020.12.16.1 1,515 12/16/2020
2020.12.15.1 1,446 12/15/2020
2020.12.14.5 1,490 12/14/2020
2020.12.14.4 1,567 12/14/2020
2020.12.14.3 1,558 12/14/2020
2020.12.4.4 1,568 12/4/2020
2020.12.4.3 1,570 12/4/2020
2020.12.3.1 1,563 12/3/2020
2020.12.2.4 1,499 12/2/2020
2020.12.2.3 1,610 12/2/2020
2020.12.1.1 1,574 12/1/2020
2020.11.28.1 1,613 11/28/2020
2020.11.27.2 1,572 11/27/2020
2020.11.27.1 1,535 11/27/2020
2020.11.25.1 1,495 11/25/2020
2020.11.22.3 1,550 11/23/2020
2020.11.20.1 1,651 11/21/2020
2020.11.19.3 1,629 11/19/2020
2020.11.19.1 1,628 11/19/2020
2020.11.18.2 1,605 11/18/2020
2020.11.17.2 1,619 11/17/2020
2020.11.17.1 1,597 11/17/2020
2020.11.15.1 1,524 11/15/2020
2020.11.14.1 1,709 11/14/2020
2020.11.13.3 1,778 11/14/2020
2020.11.13.2 1,462 11/13/2020
2020.11.13.1 1,574 11/13/2020
2020.11.12.1 1,598 11/12/2020
2020.11.11.1 1,595 11/11/2020
2020.11.8.1 1,670 11/8/2020
2020.11.7.1 1,538 11/7/2020
2020.11.5.1 1,604 11/5/2020
2020.11.3.1 1,560 11/3/2020
2020.11.1.3 1,582 11/1/2020
2020.11.1.2 1,610 11/1/2020
2020.11.1.1 1,611 11/1/2020
2020.10.30.1 1,571 11/1/2020
2020.10.15.3 1,528 10/15/2020
2020.10.15.2 1,652 10/15/2020
2020.10.14.1 1,587 10/14/2020
2020.10.13.1 1,586 10/13/2020
2020.10.12.2 1,587 10/12/2020
2020.10.12.1 1,583 10/12/2020
2020.10.10.1 1,712 10/10/2020
2020.10.9.6 1,483 10/9/2020
2020.10.9.2 1,557 10/9/2020
2020.10.9.1 1,579 10/9/2020
2020.10.8.1 1,590 10/8/2020
2020.10.6.8 1,683 10/7/2020
2020.10.6.6 1,657 10/7/2020
2020.10.6.5 1,562 10/7/2020
2020.10.6.4 1,531 10/7/2020
2020.10.6.3 1,577 10/7/2020
2020.10.6.2 1,474 10/7/2020
2020.10.6.1 1,579 10/7/2020
2020.10.5.1 1,690 10/6/2020
2020.10.1.3 1,480 10/1/2020
2020.10.1.2 1,528 10/1/2020
2020.10.1.1 1,628 10/1/2020
2020.9.29.10 1,672 9/29/2020
2020.9.29.9 1,600 9/29/2020
2020.9.28.2 1,521 9/28/2020
2020.9.28.1 1,564 9/28/2020
2020.9.25.1 1,753 9/26/2020
2020.9.24.2 1,514 9/24/2020
2020.9.24 1,560 9/24/2020
2020.9.23.2 1,559 9/23/2020
2020.9.23.1 1,570 9/23/2020
2020.9.22.1 1,498 9/22/2020
2020.9.21.1 1,628 9/21/2020
2020.9.17.2 1,570 9/17/2020
2020.9.16 1,608 9/16/2020
2020.9.15 1,603 9/15/2020
2020.9.9.2 1,545 9/9/2020
2020.9.8.1 1,533 9/8/2020
2020.9.6.5 1,649 9/6/2020
2020.9.4.2 1,544 9/4/2020
2020.9.4.1 1,621 9/4/2020
2020.9.4 1,585 9/4/2020
2020.9.3.1 1,534 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