Walter.Web.FireWall.SqlLogger 2020.10.6.4

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
.NET Core 3.0 .NET Standard 2.1
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.10.6.4
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.10.6.4
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.10.6.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Walter.Web.FireWall.SqlLogger --version 2020.10.6.4
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.10.6.4"
#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. 
// Install Walter.Web.FireWall.SqlLogger as a Cake Addin
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.10.6.4

// Install Walter.Web.FireWall.SqlLogger as a Cake Tool
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.10.6.4

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. 
.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
2023.11.13.1117 587 11/13/2023
2023.10.26.1502 529 10/29/2023
2023.10.12.1926 562 10/12/2023
2023.9.14.812 652 9/14/2023
2023.9.7.1748 640 9/7/2023
2023.9.7.1241 642 9/7/2023
2023.9.6.1001 609 9/6/2023
2023.9.5.1246 637 9/5/2023
2023.9.5.1032 618 9/5/2023
2023.8.31.1522 609 8/31/2023
2023.8.29.1040 639 8/29/2023
2023.8.17.901 708 8/17/2023
2023.8.9.1314 740 8/9/2023
2023.8.2.750 731 8/2/2023
2023.7.12.830 744 7/12/2023
2023.7.5.1419 733 7/6/2023
2023.6.14.1628 790 6/14/2023
2023.6.11.1304 780 6/11/2023
2023.5.30.1640 768 5/30/2023
2023.5.4.1552 802 5/4/2023
2023.4.29.910 821 4/29/2023
2023.4.12.1236 872 4/12/2023
2023.3.22.1456 906 3/22/2023
2023.3.14.1356 912 3/14/2023
2023.3.1.810 840 3/1/2023
2023.2.25.11857 864 2/25/2023
2023.2.22.27 930 2/22/2023
2023.2.15.1413 889 2/15/2023
2023.2.11.1628 896 2/11/2023
2023.1.11.534 964 1/11/2023
2022.12.30.711 986 12/30/2022
2022.12.15.1108 983 12/15/2022
2022.12.14.648 932 12/14/2022
2022.11.27.1059 1,016 11/27/2022
2022.11.21.338 981 11/21/2022
2022.11.14.1819 1,061 11/14/2022
2022.11.13.917 992 11/13/2022
2022.10.31.740 1,062 11/1/2022
2022.10.15.652 1,170 10/15/2022
2022.10.1.810 1,126 10/1/2022
2022.9.26.1444 1,169 9/26/2022
2022.9.14.1508 1,190 9/14/2022
2022.9.14.809 1,241 9/14/2022
2022.9.8.1009 1,250 9/8/2022
2022.8.20.1007 1,202 8/20/2022
2022.8.1.1 1,181 7/31/2022
2022.7.1300 1,222 7/1/2022
2022.7.31.1016 1,157 7/31/2022
2022.7.15.841 1,236 7/15/2022
2022.6.21.647 1,204 6/21/2022
2022.5.18.638 1,207 5/19/2022
2022.5.16.853 1,212 5/19/2022
2022.5.16.816 1,246 5/16/2022
2022.5.4.1010 1,195 5/4/2022
2022.4.10.947 1,343 4/10/2022
2022.4.10.925 1,274 4/10/2022
2022.4.10.828 1,282 4/10/2022
2022.4.1.1545 1,314 4/1/2022
2022.3.26.1103 1,270 3/26/2022
2022.3.26.820 1,249 3/26/2022
2022.3.25.840 1,243 3/26/2022
2022.2.16.1131 1,272 2/17/2022
2022.2.16.834 1,285 2/17/2022
2022.2.5.1114 1,347 2/5/2022
2022.1.17.1158 1,310 1/17/2022
2022.1.10.1505 1,419 1/10/2022
2022.1.10.537 1,258 1/10/2022
2022.1.5.1139 1,110 1/8/2022
2021.12.28.1452 1,131 12/28/2021
2021.12.16.812 1,204 12/16/2021
2021.11.23.1528 7,393 11/24/2021
2021.11.21.925 1,212 11/22/2021
2021.11.19.1503 1,243 11/22/2021
2021.11.19.847 1,286 11/19/2021
2021.11.18.1824 1,249 11/16/2021
2021.11.10.852 1,228 11/10/2021
2021.11.9.2021 1,378 11/9/2021
2021.11.8.2109 1,187 11/9/2021
2021.11.8.1612 1,230 11/8/2021
2021.11.7.1021 1,273 11/8/2021
2021.11.3.1612 1,370 11/4/2021
2021.11.1.1102 1,220 11/1/2021
2021.10.25.1206 1,266 10/25/2021
2021.10.23.1310 1,284 10/25/2021
2021.10.19.1522 1,255 10/19/2021
2021.10.16.1325 1,174 10/18/2021
2021.10.6.1546 1,237 10/6/2021
2021.10.5.1450 1,286 10/5/2021
2021.10.4.1155 1,318 10/5/2021
2021.10.1.753 1,384 10/1/2021
2021.9.27.1005 1,280 9/28/2021
2021.9.26.1913 1,283 9/26/2021
2021.9.19.1015 1,335 9/19/2021
2021.9.17.1702 1,225 9/17/2021
2021.9.17.1449 1,253 9/17/2021
2021.9.13.1600 1,346 9/13/2021
2021.9.9.1110 1,301 9/9/2021
2021.9.7.1901 1,171 9/8/2021
2021.9.7.1121 1,321 9/7/2021
2021.9.6.1518 1,211 9/7/2021
2021.9.4.1124 1,344 9/4/2021
2021.9.2.708 1,243 9/4/2021
2021.9.0.1259 1,214 9/2/2021
2021.8.2200 1,217 8/23/2021
2021.8.2100 1,280 8/23/2021
2021.8.22.900 1,333 8/22/2021
2021.8.18.1500 1,255 8/18/2021
2021.8.18.930 1,211 8/18/2021
2021.8.14.1600 1,224 8/16/2021
2021.8.9.1105 1,210 8/9/2021
2021.8.8.1612 1,165 8/8/2021
2021.8.8.1138 1,322 8/8/2021
2021.8.6.1044 1,344 8/6/2021
2021.8.4.1355 1,282 8/5/2021
2021.7.30.2118 1,290 7/31/2021
2021.7.27.926 1,292 7/28/2021
2021.7.23.931 1,229 7/26/2021
2021.7.22.1456 1,328 7/23/2021
2021.7.15.1547 1,325 7/15/2021
2021.7.13.812 1,323 7/13/2021
2021.7.8.1527 1,468 7/10/2021
2021.7.5.1649 1,339 7/5/2021
2021.6.29.1453 1,319 6/30/2021
2021.6.26.1753 1,450 6/27/2021
2021.6.25.1849 1,265 6/25/2021
2021.6.24.1518 1,325 6/24/2021
2021.6.20.729 1,258 6/20/2021
2021.6.15.2006 1,296 6/15/2021
2021.6.14.2025 1,348 6/15/2021
2021.6.13.2035 1,255 6/14/2021
2021.6.12.1154 1,197 6/13/2021
2021.6.9.1120 1,284 6/9/2021
2021.6.3.1509 1,283 6/3/2021
2021.5.31.1533 1,303 5/31/2021
2021.5.31.1415 1,350 5/31/2021
2021.5.25.1732 1,287 5/25/2021
2021.5.24.1128 1,293 5/24/2021
2021.5.24.1019 1,224 5/24/2021
2021.5.12.1054 1,224 5/12/2021
2021.5.12.637 1,202 5/12/2021
2021.5.10.1442 1,312 5/11/2021
2021.5.8.1226 1,227 5/8/2021
2021.5.6.2037 1,273 5/6/2021
2021.5.5.1901 1,317 5/6/2021
2021.5.3.1621 1,233 5/4/2021
2021.5.1.905 1,188 5/1/2021
2021.4.28.1511 1,228 4/28/2021
2021.4.20.1520 1,203 4/21/2021
2021.4.16.738 1,243 4/21/2021
2021.4.14.1216 1,266 4/16/2021
2021.4.9.1538 1,218 4/13/2021
2021.4.8.947 1,256 4/13/2021
2021.4.6.1235 1,274 4/6/2021
2021.4.5.1653 1,243 4/5/2021
2021.4.1.913 1,240 4/1/2021
2021.3.31.2003 1,218 4/1/2021
2021.3.18.1622 1,313 3/18/2021
2021.3.3.1259 1,385 3/3/2021
2021.3.2.1415 1,357 3/2/2021
2021.3.1.11 1,326 2/28/2021
2021.3.1.1 1,364 2/27/2021
2021.3.1 1,332 2/27/2021
2021.2.23.6 1,320 2/23/2021
2021.2.21.1 1,238 2/21/2021
2021.2.20.1 1,264 2/20/2021
2021.2.19.2 1,238 2/19/2021
2021.2.18.6 1,310 2/19/2021
2021.2.17.1 1,408 2/17/2021
2021.2.16.1 1,415 2/16/2021
2021.2.15.3 1,393 2/15/2021
2021.2.15.1 1,358 2/14/2021
2021.2.14.3 1,377 2/14/2021
2021.2.12.6 1,289 2/12/2021
2021.2.12.2 1,358 2/12/2021
2021.2.11.1 1,357 2/11/2021
2021.2.10.1 1,438 2/10/2021
2021.2.8.1 1,444 2/9/2021
2021.2.7.2 1,440 2/7/2021
2021.2.7.1 1,309 2/6/2021
2020.12.27.6 1,454 12/27/2020
2020.12.27.1 1,352 12/27/2020
2020.12.26.7 1,352 12/27/2020
2020.12.26.5 1,383 12/27/2020
2020.12.26.3 1,324 12/27/2020
2020.12.19.1 1,595 12/19/2020
2020.12.16.1 1,375 12/16/2020
2020.12.15.1 1,305 12/15/2020
2020.12.14.5 1,338 12/14/2020
2020.12.14.4 1,436 12/14/2020
2020.12.14.3 1,436 12/14/2020
2020.12.4.4 1,430 12/4/2020
2020.12.4.3 1,432 12/4/2020
2020.12.3.1 1,428 12/3/2020
2020.12.2.4 1,361 12/2/2020
2020.12.2.3 1,468 12/2/2020
2020.12.1.1 1,435 12/1/2020
2020.11.28.1 1,479 11/28/2020
2020.11.27.2 1,439 11/27/2020
2020.11.27.1 1,390 11/27/2020
2020.11.25.1 1,354 11/25/2020
2020.11.22.3 1,418 11/23/2020
2020.11.20.1 1,510 11/21/2020
2020.11.19.3 1,470 11/19/2020
2020.11.19.1 1,472 11/19/2020
2020.11.18.2 1,466 11/18/2020
2020.11.17.2 1,482 11/17/2020
2020.11.17.1 1,450 11/17/2020
2020.11.15.1 1,379 11/15/2020
2020.11.14.1 1,583 11/14/2020
2020.11.13.3 1,601 11/14/2020
2020.11.13.2 1,313 11/13/2020
2020.11.13.1 1,424 11/13/2020
2020.11.12.1 1,465 11/12/2020
2020.11.11.1 1,454 11/11/2020
2020.11.8.1 1,529 11/8/2020
2020.11.7.1 1,399 11/7/2020
2020.11.5.1 1,466 11/5/2020
2020.11.3.1 1,397 11/3/2020
2020.11.1.3 1,402 11/1/2020
2020.11.1.2 1,448 11/1/2020
2020.11.1.1 1,472 11/1/2020
2020.10.30.1 1,414 11/1/2020
2020.10.15.3 1,391 10/15/2020
2020.10.15.2 1,487 10/15/2020
2020.10.14.1 1,436 10/14/2020
2020.10.13.1 1,454 10/13/2020
2020.10.12.2 1,425 10/12/2020
2020.10.12.1 1,397 10/12/2020
2020.10.10.1 1,566 10/10/2020
2020.10.9.6 1,356 10/9/2020
2020.10.9.2 1,414 10/9/2020
2020.10.9.1 1,442 10/9/2020
2020.10.8.1 1,452 10/8/2020
2020.10.6.8 1,533 10/7/2020
2020.10.6.6 1,508 10/7/2020
2020.10.6.5 1,428 10/7/2020
2020.10.6.4 1,404 10/7/2020
2020.10.6.3 1,440 10/7/2020
2020.10.6.2 1,335 10/7/2020
2020.10.6.1 1,437 10/7/2020
2020.10.5.1 1,541 10/6/2020
2020.10.1.3 1,334 10/1/2020
2020.10.1.2 1,388 10/1/2020
2020.10.1.1 1,489 10/1/2020
2020.9.29.10 1,510 9/29/2020
2020.9.29.9 1,471 9/29/2020
2020.9.28.2 1,386 9/28/2020
2020.9.28.1 1,427 9/28/2020
2020.9.25.1 1,588 9/26/2020
2020.9.24.2 1,364 9/24/2020
2020.9.24 1,418 9/24/2020
2020.9.23.2 1,414 9/23/2020
2020.9.23.1 1,410 9/23/2020
2020.9.22.1 1,355 9/22/2020
2020.9.21.1 1,469 9/21/2020
2020.9.17.2 1,400 9/17/2020
2020.9.16 1,450 9/16/2020
2020.9.15 1,481 9/15/2020
2020.9.9.2 1,408 9/9/2020
2020.9.8.1 1,398 9/8/2020
2020.9.6.5 1,505 9/6/2020
2020.9.4.2 1,413 9/4/2020
2020.9.4.1 1,405 9/4/2020
2020.9.4 1,380 9/4/2020
2020.9.3.1 1,385 9/3/2020

05 October 2020
     - Update terms
     - update NuGet package references
     
     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