Walter.Web.FireWall.SqlLogger 2020.9.25.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.25.1
                    
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.9.25.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.25.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.25.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.25.1
                    
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.9.25.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.25.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.25.1
                    
Install as a Cake Addin
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.25.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 145 8/13/2025
2025.7.30.1003 100 7/30/2025
2025.7.10.1347 148 7/10/2025
2025.6.30.1407 143 7/1/2025
2025.6.12.1057 299 6/12/2025
2025.4.17.1816 217 4/17/2025
2025.3.13.1323 159 3/13/2025
2025.2.26.1642 124 2/26/2025
2025.2.25.1033 128 2/26/2025
2025.2.24.1556 125 2/25/2025
2025.2.16.1149 138 2/19/2025
2025.2.15.1316 125 2/15/2025
2025.1.16.1410 120 1/16/2025
2025.1.4.1941 134 1/4/2025
2025.1.2.1544 144 1/3/2025
2024.12.14.838 115 12/14/2024
2024.12.13.1227 111 12/13/2024
2024.11.28.1632 117 11/28/2024
2024.11.20.644 132 11/21/2024
2024.11.15.421 119 11/15/2024
2024.11.11.1334 113 11/14/2024
2024.11.6.1222 130 11/6/2024
2024.10.28.1605 117 10/28/2024
2024.10.28.1335 112 10/28/2024
2024.10.19.1525 124 10/20/2024
2024.10.18.1315 145 10/18/2024
2024.9.27.1406 133 9/27/2024
2024.9.17.1417 160 9/17/2024
2024.9.12.1923 138 9/12/2024
2024.9.6.1352 136 9/7/2024
2024.9.1.1159 143 9/1/2024
2024.8.26.1150 167 8/26/2024
2024.8.19.1411 188 8/19/2024
2024.8.17.1000 151 8/17/2024
2024.8.12.1622 153 8/13/2024
2024.8.5.1010 117 8/5/2024
2024.8.1.1545 158 8/16/2024
2024.7.28.629 103 7/28/2024
2024.7.26.1512 114 7/26/2024
2024.7.26.828 105 7/26/2024
2024.7.11.1604 165 7/11/2024
2024.7.9.1520 148 7/9/2024
2024.7.4.1425 119 7/4/2024
2024.7.3.1249 123 7/3/2024
2024.7.2.1536 153 7/2/2024
2024.6.28.953 137 6/28/2024
2023.11.13.1117 668 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 717 9/7/2023
2023.9.7.1241 719 9/7/2023
2023.9.6.1001 683 9/6/2023
2023.9.5.1246 713 9/5/2023
2023.9.5.1032 714 9/5/2023
2023.8.31.1522 691 8/31/2023
2023.8.29.1040 730 8/29/2023
2023.8.17.901 788 8/17/2023
2023.8.9.1314 824 8/9/2023
2023.8.2.750 822 8/2/2023
2023.7.12.830 834 7/12/2023
2023.7.5.1419 820 7/6/2023
2023.6.14.1628 893 6/14/2023
2023.6.11.1304 878 6/11/2023
2023.5.30.1640 863 5/30/2023
2023.5.4.1552 897 5/4/2023
2023.4.29.910 904 4/29/2023
2023.4.12.1236 967 4/12/2023
2023.3.22.1456 1,002 3/22/2023
2023.3.14.1356 1,023 3/14/2023
2023.3.1.810 936 3/1/2023
2023.2.25.11857 985 2/25/2023
2023.2.22.27 1,033 2/22/2023
2023.2.15.1413 1,006 2/15/2023
2023.2.11.1628 988 2/11/2023
2023.1.11.534 1,068 1/11/2023
2022.12.30.711 1,085 12/30/2022
2022.12.15.1108 1,110 12/15/2022
2022.12.14.648 1,039 12/14/2022
2022.11.27.1059 1,112 11/27/2022
2022.11.21.338 1,078 11/21/2022
2022.11.14.1819 1,164 11/14/2022
2022.11.13.917 1,081 11/13/2022
2022.10.31.740 1,153 11/1/2022
2022.10.15.652 1,276 10/15/2022
2022.10.1.810 1,259 10/1/2022
2022.9.26.1444 1,276 9/26/2022
2022.9.14.1508 1,284 9/14/2022
2022.9.14.809 1,346 9/14/2022
2022.9.8.1009 1,357 9/8/2022
2022.8.20.1007 1,309 8/20/2022
2022.8.1.1 1,288 7/31/2022
2022.7.1300 1,321 7/1/2022
2022.7.31.1016 1,253 7/31/2022
2022.7.15.841 1,350 7/15/2022
2022.6.21.647 1,329 6/21/2022
2022.5.18.638 1,344 5/19/2022
2022.5.16.853 1,330 5/19/2022
2022.5.16.816 1,368 5/16/2022
2022.5.4.1010 1,311 5/4/2022
2022.4.10.947 1,459 4/10/2022
2022.4.10.925 1,378 4/10/2022
2022.4.10.828 1,393 4/10/2022
2022.4.1.1545 1,430 4/1/2022
2022.3.26.1103 1,413 3/26/2022
2022.3.26.820 1,358 3/26/2022
2022.3.25.840 1,357 3/26/2022
2022.2.16.1131 1,393 2/17/2022
2022.2.16.834 1,400 2/17/2022
2022.2.5.1114 1,470 2/5/2022
2022.1.17.1158 1,429 1/17/2022
2022.1.10.1505 1,534 1/10/2022
2022.1.10.537 1,390 1/10/2022
2022.1.5.1139 1,216 1/8/2022
2021.12.28.1452 1,244 12/28/2021
2021.12.16.812 1,322 12/16/2021
2021.11.23.1528 7,507 11/24/2021
2021.11.21.925 1,374 11/22/2021
2021.11.19.1503 1,360 11/22/2021
2021.11.19.847 1,389 11/19/2021
2021.11.18.1824 1,363 11/16/2021
2021.11.10.852 1,342 11/10/2021
2021.11.9.2021 1,489 11/9/2021
2021.11.8.2109 1,329 11/9/2021
2021.11.8.1612 1,355 11/8/2021
2021.11.7.1021 1,382 11/8/2021
2021.11.3.1612 1,481 11/4/2021
2021.11.1.1102 1,371 11/1/2021
2021.10.25.1206 1,393 10/25/2021
2021.10.23.1310 1,403 10/25/2021
2021.10.19.1522 1,376 10/19/2021
2021.10.16.1325 1,285 10/18/2021
2021.10.9.1119 125 10/9/2024
2021.10.6.1546 1,377 10/6/2021
2021.10.5.1450 1,416 10/5/2021
2021.10.4.1155 1,423 10/5/2021
2021.10.1.753 1,488 10/1/2021
2021.9.27.1005 1,391 9/28/2021
2021.9.26.1913 1,402 9/26/2021
2021.9.19.1015 1,466 9/19/2021
2021.9.17.1702 1,342 9/17/2021
2021.9.17.1449 1,373 9/17/2021
2021.9.13.1600 1,460 9/13/2021
2021.9.9.1110 1,423 9/9/2021
2021.9.7.1901 1,295 9/8/2021
2021.9.7.1121 1,450 9/7/2021
2021.9.6.1518 1,342 9/7/2021
2021.9.4.1124 1,493 9/4/2021
2021.9.2.708 1,356 9/4/2021
2021.9.0.1259 1,338 9/2/2021
2021.8.2200 1,355 8/23/2021
2021.8.2100 1,436 8/23/2021
2021.8.22.900 1,469 8/22/2021
2021.8.18.1500 1,375 8/18/2021
2021.8.18.930 1,337 8/18/2021
2021.8.14.1600 1,350 8/16/2021
2021.8.9.1105 1,328 8/9/2021
2021.8.8.1612 1,310 8/8/2021
2021.8.8.1138 1,441 8/8/2021
2021.8.6.1044 1,478 8/6/2021
2021.8.4.1355 1,424 8/5/2021
2021.7.30.2118 1,423 7/31/2021
2021.7.27.926 1,408 7/28/2021
2021.7.23.931 1,372 7/26/2021
2021.7.22.1456 1,469 7/23/2021
2021.7.15.1547 1,450 7/15/2021
2021.7.13.812 1,436 7/13/2021
2021.7.8.1527 1,587 7/10/2021
2021.7.5.1649 1,445 7/5/2021
2021.6.29.1453 1,456 6/30/2021
2021.6.26.1753 1,567 6/27/2021
2021.6.25.1849 1,400 6/25/2021
2021.6.24.1518 1,464 6/24/2021
2021.6.20.729 1,360 6/20/2021
2021.6.15.2006 1,407 6/15/2021
2021.6.14.2025 1,476 6/15/2021
2021.6.13.2035 1,377 6/14/2021
2021.6.12.1154 1,317 6/13/2021
2021.6.9.1120 1,406 6/9/2021
2021.6.3.1509 1,405 6/3/2021
2021.5.31.1533 1,421 5/31/2021
2021.5.31.1415 1,475 5/31/2021
2021.5.25.1732 1,416 5/25/2021
2021.5.24.1128 1,409 5/24/2021
2021.5.24.1019 1,343 5/24/2021
2021.5.12.1054 1,339 5/12/2021
2021.5.12.637 1,313 5/12/2021
2021.5.10.1442 1,433 5/11/2021
2021.5.8.1226 1,347 5/8/2021
2021.5.6.2037 1,389 5/6/2021
2021.5.5.1901 1,441 5/6/2021
2021.5.3.1621 1,361 5/4/2021
2021.5.1.905 1,323 5/1/2021
2021.4.28.1511 1,402 4/28/2021
2021.4.20.1520 1,341 4/21/2021
2021.4.16.738 1,373 4/21/2021
2021.4.14.1216 1,389 4/16/2021
2021.4.9.1538 1,364 4/13/2021
2021.4.8.947 1,408 4/13/2021
2021.4.6.1235 1,402 4/6/2021
2021.4.5.1653 1,374 4/5/2021
2021.4.1.913 1,354 4/1/2021
2021.3.31.2003 1,349 4/1/2021
2021.3.18.1622 1,442 3/18/2021
2021.3.3.1259 1,530 3/3/2021
2021.3.2.1415 1,522 3/2/2021
2021.3.1.11 1,474 2/28/2021
2021.3.1.1 1,507 2/27/2021
2021.3.1 1,480 2/27/2021
2021.2.23.6 1,437 2/23/2021
2021.2.21.1 1,371 2/21/2021
2021.2.20.1 1,389 2/20/2021
2021.2.19.2 1,360 2/19/2021
2021.2.18.6 1,439 2/19/2021
2021.2.17.1 1,533 2/17/2021
2021.2.16.1 1,558 2/16/2021
2021.2.15.3 1,532 2/15/2021
2021.2.15.1 1,497 2/14/2021
2021.2.14.3 1,511 2/14/2021
2021.2.12.6 1,442 2/12/2021
2021.2.12.2 1,486 2/12/2021
2021.2.11.1 1,476 2/11/2021
2021.2.10.1 1,578 2/10/2021
2021.2.8.1 1,570 2/9/2021
2021.2.7.2 1,589 2/7/2021
2021.2.7.1 1,438 2/6/2021
2020.12.27.6 1,597 12/27/2020
2020.12.27.1 1,478 12/27/2020
2020.12.26.7 1,481 12/27/2020
2020.12.26.5 1,518 12/27/2020
2020.12.26.3 1,456 12/27/2020
2020.12.19.1 1,726 12/19/2020
2020.12.16.1 1,510 12/16/2020
2020.12.15.1 1,439 12/15/2020
2020.12.14.5 1,484 12/14/2020
2020.12.14.4 1,562 12/14/2020
2020.12.14.3 1,553 12/14/2020
2020.12.4.4 1,562 12/4/2020
2020.12.4.3 1,563 12/4/2020
2020.12.3.1 1,557 12/3/2020
2020.12.2.4 1,492 12/2/2020
2020.12.2.3 1,605 12/2/2020
2020.12.1.1 1,567 12/1/2020
2020.11.28.1 1,608 11/28/2020
2020.11.27.2 1,567 11/27/2020
2020.11.27.1 1,527 11/27/2020
2020.11.25.1 1,490 11/25/2020
2020.11.22.3 1,545 11/23/2020
2020.11.20.1 1,646 11/21/2020
2020.11.19.3 1,623 11/19/2020
2020.11.19.1 1,623 11/19/2020
2020.11.18.2 1,600 11/18/2020
2020.11.17.2 1,614 11/17/2020
2020.11.17.1 1,590 11/17/2020
2020.11.15.1 1,517 11/15/2020
2020.11.14.1 1,703 11/14/2020
2020.11.13.3 1,769 11/14/2020
2020.11.13.2 1,455 11/13/2020
2020.11.13.1 1,568 11/13/2020
2020.11.12.1 1,593 11/12/2020
2020.11.11.1 1,590 11/11/2020
2020.11.8.1 1,664 11/8/2020
2020.11.7.1 1,533 11/7/2020
2020.11.5.1 1,598 11/5/2020
2020.11.3.1 1,554 11/3/2020
2020.11.1.3 1,574 11/1/2020
2020.11.1.2 1,605 11/1/2020
2020.11.1.1 1,606 11/1/2020
2020.10.30.1 1,564 11/1/2020
2020.10.15.3 1,522 10/15/2020
2020.10.15.2 1,644 10/15/2020
2020.10.14.1 1,582 10/14/2020
2020.10.13.1 1,577 10/13/2020
2020.10.12.2 1,581 10/12/2020
2020.10.12.1 1,575 10/12/2020
2020.10.10.1 1,706 10/10/2020
2020.10.9.6 1,478 10/9/2020
2020.10.9.2 1,552 10/9/2020
2020.10.9.1 1,574 10/9/2020
2020.10.8.1 1,584 10/8/2020
2020.10.6.8 1,677 10/7/2020
2020.10.6.6 1,650 10/7/2020
2020.10.6.5 1,557 10/7/2020
2020.10.6.4 1,526 10/7/2020
2020.10.6.3 1,570 10/7/2020
2020.10.6.2 1,466 10/7/2020
2020.10.6.1 1,572 10/7/2020
2020.10.5.1 1,685 10/6/2020
2020.10.1.3 1,475 10/1/2020
2020.10.1.2 1,523 10/1/2020
2020.10.1.1 1,623 10/1/2020
2020.9.29.10 1,666 9/29/2020
2020.9.29.9 1,595 9/29/2020
2020.9.28.2 1,514 9/28/2020
2020.9.28.1 1,558 9/28/2020
2020.9.25.1 1,748 9/26/2020
2020.9.24.2 1,509 9/24/2020
2020.9.24 1,555 9/24/2020
2020.9.23.2 1,553 9/23/2020
2020.9.23.1 1,561 9/23/2020
2020.9.22.1 1,493 9/22/2020
2020.9.21.1 1,620 9/21/2020
2020.9.17.2 1,564 9/17/2020
2020.9.16 1,603 9/16/2020
2020.9.15 1,598 9/15/2020
2020.9.9.2 1,540 9/9/2020
2020.9.8.1 1,528 9/8/2020
2020.9.6.5 1,643 9/6/2020
2020.9.4.2 1,539 9/4/2020
2020.9.4.1 1,619 9/4/2020
2020.9.4 1,582 9/4/2020
2020.9.3.1 1,527 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