Walter.Web.FireWall.SqlLogger 2020.9.22.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.22.1
                    
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.9.22.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.22.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.22.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.22.1
                    
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.9.22.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.
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.22.1
                    
Install as a Cake Addin
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.22.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

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.6.12.1057 276 6/12/2025
2025.4.17.1816 188 4/17/2025
2025.3.13.1323 146 3/13/2025
2025.2.26.1642 109 2/26/2025
2025.2.25.1033 105 2/26/2025
2025.2.24.1556 98 2/25/2025
2025.2.16.1149 120 2/19/2025
2025.2.15.1316 113 2/15/2025
2025.1.16.1410 91 1/16/2025
2025.1.4.1941 118 1/4/2025
2025.1.2.1544 131 1/3/2025
2024.12.14.838 97 12/14/2024
2024.12.13.1227 95 12/13/2024
2024.11.28.1632 93 11/28/2024
2024.11.20.644 119 11/21/2024
2024.11.15.421 105 11/15/2024
2024.11.11.1334 93 11/14/2024
2024.11.6.1222 113 11/6/2024
2024.10.28.1605 99 10/28/2024
2024.10.28.1335 99 10/28/2024
2024.10.19.1525 102 10/20/2024
2024.10.18.1315 122 10/18/2024
2024.9.27.1406 113 9/27/2024
2024.9.17.1417 140 9/17/2024
2024.9.12.1923 120 9/12/2024
2024.9.6.1352 124 9/7/2024
2024.9.1.1159 127 9/1/2024
2024.8.26.1150 147 8/26/2024
2024.8.19.1411 167 8/19/2024
2024.8.17.1000 132 8/17/2024
2024.8.12.1622 140 8/13/2024
2024.8.5.1010 105 8/5/2024
2024.8.1.1545 142 8/16/2024
2024.7.28.629 86 7/28/2024
2024.7.26.1512 89 7/26/2024
2024.7.26.828 92 7/26/2024
2024.7.11.1604 145 7/11/2024
2024.7.9.1520 125 7/9/2024
2024.7.4.1425 104 7/4/2024
2024.7.3.1249 105 7/3/2024
2024.7.2.1536 134 7/2/2024
2024.6.28.953 115 6/28/2024
2023.11.13.1117 650 11/13/2023
2023.10.26.1502 597 10/29/2023
2023.10.12.1926 606 10/12/2023
2023.9.14.812 701 9/14/2023
2023.9.7.1748 691 9/7/2023
2023.9.7.1241 683 9/7/2023
2023.9.6.1001 658 9/6/2023
2023.9.5.1246 683 9/5/2023
2023.9.5.1032 676 9/5/2023
2023.8.31.1522 658 8/31/2023
2023.8.29.1040 689 8/29/2023
2023.8.17.901 758 8/17/2023
2023.8.9.1314 786 8/9/2023
2023.8.2.750 784 8/2/2023
2023.7.12.830 795 7/12/2023
2023.7.5.1419 787 7/6/2023
2023.6.14.1628 858 6/14/2023
2023.6.11.1304 836 6/11/2023
2023.5.30.1640 823 5/30/2023
2023.5.4.1552 857 5/4/2023
2023.4.29.910 871 4/29/2023
2023.4.12.1236 934 4/12/2023
2023.3.22.1456 964 3/22/2023
2023.3.14.1356 982 3/14/2023
2023.3.1.810 904 3/1/2023
2023.2.25.11857 943 2/25/2023
2023.2.22.27 994 2/22/2023
2023.2.15.1413 965 2/15/2023
2023.2.11.1628 954 2/11/2023
2023.1.11.534 1,028 1/11/2023
2022.12.30.711 1,041 12/30/2022
2022.12.15.1108 1,069 12/15/2022
2022.12.14.648 1,002 12/14/2022
2022.11.27.1059 1,079 11/27/2022
2022.11.21.338 1,045 11/21/2022
2022.11.14.1819 1,122 11/14/2022
2022.11.13.917 1,049 11/13/2022
2022.10.31.740 1,121 11/1/2022
2022.10.15.652 1,235 10/15/2022
2022.10.1.810 1,218 10/1/2022
2022.9.26.1444 1,234 9/26/2022
2022.9.14.1508 1,250 9/14/2022
2022.9.14.809 1,305 9/14/2022
2022.9.8.1009 1,313 9/8/2022
2022.8.20.1007 1,269 8/20/2022
2022.8.1.1 1,245 7/31/2022
2022.7.1300 1,287 7/1/2022
2022.7.31.1016 1,214 7/31/2022
2022.7.15.841 1,303 7/15/2022
2022.6.21.647 1,291 6/21/2022
2022.5.18.638 1,302 5/19/2022
2022.5.16.853 1,294 5/19/2022
2022.5.16.816 1,322 5/16/2022
2022.5.4.1010 1,269 5/4/2022
2022.4.10.947 1,421 4/10/2022
2022.4.10.925 1,342 4/10/2022
2022.4.10.828 1,348 4/10/2022
2022.4.1.1545 1,388 4/1/2022
2022.3.26.1103 1,369 3/26/2022
2022.3.26.820 1,323 3/26/2022
2022.3.25.840 1,312 3/26/2022
2022.2.16.1131 1,358 2/17/2022
2022.2.16.834 1,358 2/17/2022
2022.2.5.1114 1,428 2/5/2022
2022.1.17.1158 1,395 1/17/2022
2022.1.10.1505 1,493 1/10/2022
2022.1.10.537 1,350 1/10/2022
2022.1.5.1139 1,181 1/8/2022
2021.12.28.1452 1,197 12/28/2021
2021.12.16.812 1,285 12/16/2021
2021.11.23.1528 7,472 11/24/2021
2021.11.21.925 1,338 11/22/2021
2021.11.19.1503 1,322 11/22/2021
2021.11.19.847 1,354 11/19/2021
2021.11.18.1824 1,327 11/16/2021
2021.11.10.852 1,292 11/10/2021
2021.11.9.2021 1,448 11/9/2021
2021.11.8.2109 1,287 11/9/2021
2021.11.8.1612 1,311 11/8/2021
2021.11.7.1021 1,341 11/8/2021
2021.11.3.1612 1,444 11/4/2021
2021.11.1.1102 1,320 11/1/2021
2021.10.25.1206 1,357 10/25/2021
2021.10.23.1310 1,362 10/25/2021
2021.10.19.1522 1,341 10/19/2021
2021.10.16.1325 1,249 10/18/2021
2021.10.9.1119 103 10/9/2024
2021.10.6.1546 1,335 10/6/2021
2021.10.5.1450 1,375 10/5/2021
2021.10.4.1155 1,388 10/5/2021
2021.10.1.753 1,454 10/1/2021
2021.9.27.1005 1,354 9/28/2021
2021.9.26.1913 1,358 9/26/2021
2021.9.19.1015 1,420 9/19/2021
2021.9.17.1702 1,298 9/17/2021
2021.9.17.1449 1,332 9/17/2021
2021.9.13.1600 1,423 9/13/2021
2021.9.9.1110 1,380 9/9/2021
2021.9.7.1901 1,252 9/8/2021
2021.9.7.1121 1,407 9/7/2021
2021.9.6.1518 1,299 9/7/2021
2021.9.4.1124 1,449 9/4/2021
2021.9.2.708 1,313 9/4/2021
2021.9.0.1259 1,293 9/2/2021
2021.8.2200 1,310 8/23/2021
2021.8.2100 1,397 8/23/2021
2021.8.22.900 1,424 8/22/2021
2021.8.18.1500 1,331 8/18/2021
2021.8.18.930 1,291 8/18/2021
2021.8.14.1600 1,312 8/16/2021
2021.8.9.1105 1,294 8/9/2021
2021.8.8.1612 1,267 8/8/2021
2021.8.8.1138 1,397 8/8/2021
2021.8.6.1044 1,425 8/6/2021
2021.8.4.1355 1,379 8/5/2021
2021.7.30.2118 1,382 7/31/2021
2021.7.27.926 1,366 7/28/2021
2021.7.23.931 1,330 7/26/2021
2021.7.22.1456 1,428 7/23/2021
2021.7.15.1547 1,404 7/15/2021
2021.7.13.812 1,396 7/13/2021
2021.7.8.1527 1,548 7/10/2021
2021.7.5.1649 1,409 7/5/2021
2021.6.29.1453 1,412 6/30/2021
2021.6.26.1753 1,524 6/27/2021
2021.6.25.1849 1,364 6/25/2021
2021.6.24.1518 1,422 6/24/2021
2021.6.20.729 1,325 6/20/2021
2021.6.15.2006 1,371 6/15/2021
2021.6.14.2025 1,438 6/15/2021
2021.6.13.2035 1,333 6/14/2021
2021.6.12.1154 1,280 6/13/2021
2021.6.9.1120 1,365 6/9/2021
2021.6.3.1509 1,363 6/3/2021
2021.5.31.1533 1,383 5/31/2021
2021.5.31.1415 1,430 5/31/2021
2021.5.25.1732 1,376 5/25/2021
2021.5.24.1128 1,365 5/24/2021
2021.5.24.1019 1,301 5/24/2021
2021.5.12.1054 1,304 5/12/2021
2021.5.12.637 1,273 5/12/2021
2021.5.10.1442 1,392 5/11/2021
2021.5.8.1226 1,307 5/8/2021
2021.5.6.2037 1,353 5/6/2021
2021.5.5.1901 1,399 5/6/2021
2021.5.3.1621 1,326 5/4/2021
2021.5.1.905 1,278 5/1/2021
2021.4.28.1511 1,358 4/28/2021
2021.4.20.1520 1,298 4/21/2021
2021.4.16.738 1,328 4/21/2021
2021.4.14.1216 1,341 4/16/2021
2021.4.9.1538 1,318 4/13/2021
2021.4.8.947 1,368 4/13/2021
2021.4.6.1235 1,359 4/6/2021
2021.4.5.1653 1,330 4/5/2021
2021.4.1.913 1,318 4/1/2021
2021.3.31.2003 1,308 4/1/2021
2021.3.18.1622 1,398 3/18/2021
2021.3.3.1259 1,484 3/3/2021
2021.3.2.1415 1,476 3/2/2021
2021.3.1.11 1,424 2/28/2021
2021.3.1.1 1,463 2/27/2021
2021.3.1 1,430 2/27/2021
2021.2.23.6 1,401 2/23/2021
2021.2.21.1 1,325 2/21/2021
2021.2.20.1 1,348 2/20/2021
2021.2.19.2 1,323 2/19/2021
2021.2.18.6 1,394 2/19/2021
2021.2.17.1 1,492 2/17/2021
2021.2.16.1 1,508 2/16/2021
2021.2.15.3 1,488 2/15/2021
2021.2.15.1 1,443 2/14/2021
2021.2.14.3 1,462 2/14/2021
2021.2.12.6 1,399 2/12/2021
2021.2.12.2 1,451 2/12/2021
2021.2.11.1 1,438 2/11/2021
2021.2.10.1 1,534 2/10/2021
2021.2.8.1 1,529 2/9/2021
2021.2.7.2 1,537 2/7/2021
2021.2.7.1 1,393 2/6/2021
2020.12.27.6 1,550 12/27/2020
2020.12.27.1 1,431 12/27/2020
2020.12.26.7 1,434 12/27/2020
2020.12.26.5 1,470 12/27/2020
2020.12.26.3 1,408 12/27/2020
2020.12.19.1 1,680 12/19/2020
2020.12.16.1 1,460 12/16/2020
2020.12.15.1 1,397 12/15/2020
2020.12.14.5 1,430 12/14/2020
2020.12.14.4 1,522 12/14/2020
2020.12.14.3 1,515 12/14/2020
2020.12.4.4 1,512 12/4/2020
2020.12.4.3 1,517 12/4/2020
2020.12.3.1 1,509 12/3/2020
2020.12.2.4 1,448 12/2/2020
2020.12.2.3 1,565 12/2/2020
2020.12.1.1 1,524 12/1/2020
2020.11.28.1 1,569 11/28/2020
2020.11.27.2 1,527 11/27/2020
2020.11.27.1 1,481 11/27/2020
2020.11.25.1 1,445 11/25/2020
2020.11.22.3 1,506 11/23/2020
2020.11.20.1 1,605 11/21/2020
2020.11.19.3 1,577 11/19/2020
2020.11.19.1 1,573 11/19/2020
2020.11.18.2 1,553 11/18/2020
2020.11.17.2 1,576 11/17/2020
2020.11.17.1 1,542 11/17/2020
2020.11.15.1 1,474 11/15/2020
2020.11.14.1 1,663 11/14/2020
2020.11.13.3 1,722 11/14/2020
2020.11.13.2 1,409 11/13/2020
2020.11.13.1 1,517 11/13/2020
2020.11.12.1 1,554 11/12/2020
2020.11.11.1 1,551 11/11/2020
2020.11.8.1 1,619 11/8/2020
2020.11.7.1 1,494 11/7/2020
2020.11.5.1 1,560 11/5/2020
2020.11.3.1 1,512 11/3/2020
2020.11.1.3 1,530 11/1/2020
2020.11.1.2 1,565 11/1/2020
2020.11.1.1 1,567 11/1/2020
2020.10.30.1 1,519 11/1/2020
2020.10.15.3 1,480 10/15/2020
2020.10.15.2 1,598 10/15/2020
2020.10.14.1 1,543 10/14/2020
2020.10.13.1 1,536 10/13/2020
2020.10.12.2 1,533 10/12/2020
2020.10.12.1 1,532 10/12/2020
2020.10.10.1 1,661 10/10/2020
2020.10.9.6 1,437 10/9/2020
2020.10.9.2 1,504 10/9/2020
2020.10.9.1 1,535 10/9/2020
2020.10.8.1 1,534 10/8/2020
2020.10.6.8 1,635 10/7/2020
2020.10.6.6 1,604 10/7/2020
2020.10.6.5 1,511 10/7/2020
2020.10.6.4 1,488 10/7/2020
2020.10.6.3 1,523 10/7/2020
2020.10.6.2 1,423 10/7/2020
2020.10.6.1 1,527 10/7/2020
2020.10.5.1 1,638 10/6/2020
2020.10.1.3 1,436 10/1/2020
2020.10.1.2 1,478 10/1/2020
2020.10.1.1 1,574 10/1/2020
2020.9.29.10 1,618 9/29/2020
2020.9.29.9 1,557 9/29/2020
2020.9.28.2 1,468 9/28/2020
2020.9.28.1 1,512 9/28/2020
2020.9.25.1 1,702 9/26/2020
2020.9.24.2 1,460 9/24/2020
2020.9.24 1,517 9/24/2020
2020.9.23.2 1,504 9/23/2020
2020.9.23.1 1,521 9/23/2020
2020.9.22.1 1,452 9/22/2020
2020.9.21.1 1,577 9/21/2020
2020.9.17.2 1,513 9/17/2020
2020.9.16 1,555 9/16/2020
2020.9.15 1,560 9/15/2020
2020.9.9.2 1,494 9/9/2020
2020.9.8.1 1,489 9/8/2020
2020.9.6.5 1,595 9/6/2020
2020.9.4.2 1,500 9/4/2020
2020.9.4.1 1,563 9/4/2020
2020.9.4 1,525 9/4/2020
2020.9.3.1 1,481 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