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.
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.
// Install Walter.Web.FireWall.SqlLogger as a Cake Addin
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.25.1

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

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
2024.12.14.838 64 12/14/2024
2024.12.13.1227 60 12/13/2024
2024.11.28.1632 73 11/28/2024
2024.11.20.644 95 11/21/2024
2024.11.15.421 87 11/15/2024
2024.11.11.1334 76 11/14/2024
2024.11.6.1222 97 11/6/2024
2024.10.28.1605 84 10/28/2024
2024.10.28.1335 82 10/28/2024
2024.10.19.1525 90 10/20/2024
2024.10.18.1315 108 10/18/2024
2024.9.27.1406 97 9/27/2024
2024.9.17.1417 107 9/17/2024
2024.9.12.1923 103 9/12/2024
2024.9.6.1352 112 9/7/2024
2024.9.1.1159 117 9/1/2024
2024.8.26.1150 115 8/26/2024
2024.8.19.1411 140 8/19/2024
2024.8.17.1000 120 8/17/2024
2024.8.12.1622 130 8/13/2024
2024.8.5.1010 92 8/5/2024
2024.8.1.1545 125 8/16/2024
2024.7.28.629 76 7/28/2024
2024.7.26.1512 77 7/26/2024
2024.7.26.828 79 7/26/2024
2024.7.11.1604 114 7/11/2024
2024.7.9.1520 110 7/9/2024
2024.7.4.1425 94 7/4/2024
2024.7.3.1249 92 7/3/2024
2024.7.2.1536 118 7/2/2024
2024.6.28.953 102 6/28/2024
2023.11.13.1117 636 11/13/2023
2023.10.26.1502 565 10/29/2023
2023.10.12.1926 597 10/12/2023
2023.9.14.812 689 9/14/2023
2023.9.7.1748 677 9/7/2023
2023.9.7.1241 670 9/7/2023
2023.9.6.1001 645 9/6/2023
2023.9.5.1246 667 9/5/2023
2023.9.5.1032 662 9/5/2023
2023.8.31.1522 643 8/31/2023
2023.8.29.1040 672 8/29/2023
2023.8.17.901 741 8/17/2023
2023.8.9.1314 771 8/9/2023
2023.8.2.750 764 8/2/2023
2023.7.12.830 780 7/12/2023
2023.7.5.1419 772 7/6/2023
2023.6.14.1628 833 6/14/2023
2023.6.11.1304 812 6/11/2023
2023.5.30.1640 802 5/30/2023
2023.5.4.1552 834 5/4/2023
2023.4.29.910 847 4/29/2023
2023.4.12.1236 908 4/12/2023
2023.3.22.1456 939 3/22/2023
2023.3.14.1356 939 3/14/2023
2023.3.1.810 881 3/1/2023
2023.2.25.11857 901 2/25/2023
2023.2.22.27 964 2/22/2023
2023.2.15.1413 941 2/15/2023
2023.2.11.1628 930 2/11/2023
2023.1.11.534 1,001 1/11/2023
2022.12.30.711 1,014 12/30/2022
2022.12.15.1108 1,011 12/15/2022
2022.12.14.648 975 12/14/2022
2022.11.27.1059 1,052 11/27/2022
2022.11.21.338 1,015 11/21/2022
2022.11.14.1819 1,092 11/14/2022
2022.11.13.917 1,020 11/13/2022
2022.10.31.740 1,093 11/1/2022
2022.10.15.652 1,203 10/15/2022
2022.10.1.810 1,187 10/1/2022
2022.9.26.1444 1,204 9/26/2022
2022.9.14.1508 1,221 9/14/2022
2022.9.14.809 1,276 9/14/2022
2022.9.8.1009 1,283 9/8/2022
2022.8.20.1007 1,237 8/20/2022
2022.8.1.1 1,212 7/31/2022
2022.7.1300 1,254 7/1/2022
2022.7.31.1016 1,182 7/31/2022
2022.7.15.841 1,270 7/15/2022
2022.6.21.647 1,240 6/21/2022
2022.5.18.638 1,266 5/19/2022
2022.5.16.853 1,240 5/19/2022
2022.5.16.816 1,283 5/16/2022
2022.5.4.1010 1,230 5/4/2022
2022.4.10.947 1,382 4/10/2022
2022.4.10.925 1,300 4/10/2022
2022.4.10.828 1,306 4/10/2022
2022.4.1.1545 1,349 4/1/2022
2022.3.26.1103 1,298 3/26/2022
2022.3.26.820 1,274 3/26/2022
2022.3.25.840 1,272 3/26/2022
2022.2.16.1131 1,317 2/17/2022
2022.2.16.834 1,315 2/17/2022
2022.2.5.1114 1,384 2/5/2022
2022.1.17.1158 1,351 1/17/2022
2022.1.10.1505 1,447 1/10/2022
2022.1.10.537 1,306 1/10/2022
2022.1.5.1139 1,137 1/8/2022
2021.12.28.1452 1,153 12/28/2021
2021.12.16.812 1,242 12/16/2021
2021.11.23.1528 7,426 11/24/2021
2021.11.21.925 1,293 11/22/2021
2021.11.19.1503 1,276 11/22/2021
2021.11.19.847 1,308 11/19/2021
2021.11.18.1824 1,284 11/16/2021
2021.11.10.852 1,248 11/10/2021
2021.11.9.2021 1,402 11/9/2021
2021.11.8.2109 1,221 11/9/2021
2021.11.8.1612 1,261 11/8/2021
2021.11.7.1021 1,296 11/8/2021
2021.11.3.1612 1,400 11/4/2021
2021.11.1.1102 1,273 11/1/2021
2021.10.25.1206 1,311 10/25/2021
2021.10.23.1310 1,317 10/25/2021
2021.10.19.1522 1,297 10/19/2021
2021.10.16.1325 1,207 10/18/2021
2021.10.9.1119 88 10/9/2024
2021.10.6.1546 1,289 10/6/2021
2021.10.5.1450 1,329 10/5/2021
2021.10.4.1155 1,346 10/5/2021
2021.10.1.753 1,410 10/1/2021
2021.9.27.1005 1,311 9/28/2021
2021.9.26.1913 1,316 9/26/2021
2021.9.19.1015 1,378 9/19/2021
2021.9.17.1702 1,252 9/17/2021
2021.9.17.1449 1,286 9/17/2021
2021.9.13.1600 1,378 9/13/2021
2021.9.9.1110 1,326 9/9/2021
2021.9.7.1901 1,204 9/8/2021
2021.9.7.1121 1,361 9/7/2021
2021.9.6.1518 1,251 9/7/2021
2021.9.4.1124 1,403 9/4/2021
2021.9.2.708 1,269 9/4/2021
2021.9.0.1259 1,248 9/2/2021
2021.8.2200 1,265 8/23/2021
2021.8.2100 1,352 8/23/2021
2021.8.22.900 1,377 8/22/2021
2021.8.18.1500 1,284 8/18/2021
2021.8.18.930 1,247 8/18/2021
2021.8.14.1600 1,269 8/16/2021
2021.8.9.1105 1,251 8/9/2021
2021.8.8.1612 1,223 8/8/2021
2021.8.8.1138 1,353 8/8/2021
2021.8.6.1044 1,380 8/6/2021
2021.8.4.1355 1,333 8/5/2021
2021.7.30.2118 1,337 7/31/2021
2021.7.27.926 1,323 7/28/2021
2021.7.23.931 1,287 7/26/2021
2021.7.22.1456 1,382 7/23/2021
2021.7.15.1547 1,358 7/15/2021
2021.7.13.812 1,351 7/13/2021
2021.7.8.1527 1,507 7/10/2021
2021.7.5.1649 1,365 7/5/2021
2021.6.29.1453 1,365 6/30/2021
2021.6.26.1753 1,481 6/27/2021
2021.6.25.1849 1,319 6/25/2021
2021.6.24.1518 1,377 6/24/2021
2021.6.20.729 1,282 6/20/2021
2021.6.15.2006 1,329 6/15/2021
2021.6.14.2025 1,391 6/15/2021
2021.6.13.2035 1,290 6/14/2021
2021.6.12.1154 1,236 6/13/2021
2021.6.9.1120 1,321 6/9/2021
2021.6.3.1509 1,319 6/3/2021
2021.5.31.1533 1,332 5/31/2021
2021.5.31.1415 1,385 5/31/2021
2021.5.25.1732 1,328 5/25/2021
2021.5.24.1128 1,321 5/24/2021
2021.5.24.1019 1,256 5/24/2021
2021.5.12.1054 1,261 5/12/2021
2021.5.12.637 1,228 5/12/2021
2021.5.10.1442 1,344 5/11/2021
2021.5.8.1226 1,259 5/8/2021
2021.5.6.2037 1,305 5/6/2021
2021.5.5.1901 1,349 5/6/2021
2021.5.3.1621 1,278 5/4/2021
2021.5.1.905 1,228 5/1/2021
2021.4.28.1511 1,309 4/28/2021
2021.4.20.1520 1,242 4/21/2021
2021.4.16.738 1,279 4/21/2021
2021.4.14.1216 1,291 4/16/2021
2021.4.9.1538 1,270 4/13/2021
2021.4.8.947 1,318 4/13/2021
2021.4.6.1235 1,310 4/6/2021
2021.4.5.1653 1,276 4/5/2021
2021.4.1.913 1,267 4/1/2021
2021.3.31.2003 1,259 4/1/2021
2021.3.18.1622 1,348 3/18/2021
2021.3.3.1259 1,427 3/3/2021
2021.3.2.1415 1,406 3/2/2021
2021.3.1.11 1,351 2/28/2021
2021.3.1.1 1,409 2/27/2021
2021.3.1 1,375 2/27/2021
2021.2.23.6 1,345 2/23/2021
2021.2.21.1 1,270 2/21/2021
2021.2.20.1 1,292 2/20/2021
2021.2.19.2 1,271 2/19/2021
2021.2.18.6 1,339 2/19/2021
2021.2.17.1 1,433 2/17/2021
2021.2.16.1 1,450 2/16/2021
2021.2.15.3 1,417 2/15/2021
2021.2.15.1 1,392 2/14/2021
2021.2.14.3 1,408 2/14/2021
2021.2.12.6 1,324 2/12/2021
2021.2.12.2 1,399 2/12/2021
2021.2.11.1 1,384 2/11/2021
2021.2.10.1 1,480 2/10/2021
2021.2.8.1 1,477 2/9/2021
2021.2.7.2 1,483 2/7/2021
2021.2.7.1 1,341 2/6/2021
2020.12.27.6 1,493 12/27/2020
2020.12.27.1 1,378 12/27/2020
2020.12.26.7 1,379 12/27/2020
2020.12.26.5 1,413 12/27/2020
2020.12.26.3 1,351 12/27/2020
2020.12.19.1 1,624 12/19/2020
2020.12.16.1 1,405 12/16/2020
2020.12.15.1 1,335 12/15/2020
2020.12.14.5 1,376 12/14/2020
2020.12.14.4 1,469 12/14/2020
2020.12.14.3 1,459 12/14/2020
2020.12.4.4 1,458 12/4/2020
2020.12.4.3 1,462 12/4/2020
2020.12.3.1 1,452 12/3/2020
2020.12.2.4 1,392 12/2/2020
2020.12.2.3 1,510 12/2/2020
2020.12.1.1 1,465 12/1/2020
2020.11.28.1 1,514 11/28/2020
2020.11.27.2 1,474 11/27/2020
2020.11.27.1 1,421 11/27/2020
2020.11.25.1 1,388 11/25/2020
2020.11.22.3 1,453 11/23/2020
2020.11.20.1 1,551 11/21/2020
2020.11.19.3 1,523 11/19/2020
2020.11.19.1 1,515 11/19/2020
2020.11.18.2 1,497 11/18/2020
2020.11.17.2 1,518 11/17/2020
2020.11.17.1 1,483 11/17/2020
2020.11.15.1 1,417 11/15/2020
2020.11.14.1 1,609 11/14/2020
2020.11.13.3 1,666 11/14/2020
2020.11.13.2 1,353 11/13/2020
2020.11.13.1 1,458 11/13/2020
2020.11.12.1 1,500 11/12/2020
2020.11.11.1 1,495 11/11/2020
2020.11.8.1 1,563 11/8/2020
2020.11.7.1 1,440 11/7/2020
2020.11.5.1 1,504 11/5/2020
2020.11.3.1 1,456 11/3/2020
2020.11.1.3 1,464 11/1/2020
2020.11.1.2 1,501 11/1/2020
2020.11.1.1 1,511 11/1/2020
2020.10.30.1 1,464 11/1/2020
2020.10.15.3 1,426 10/15/2020
2020.10.15.2 1,542 10/15/2020
2020.10.14.1 1,486 10/14/2020
2020.10.13.1 1,481 10/13/2020
2020.10.12.2 1,475 10/12/2020
2020.10.12.1 1,475 10/12/2020
2020.10.10.1 1,607 10/10/2020
2020.10.9.6 1,383 10/9/2020
2020.10.9.2 1,451 10/9/2020
2020.10.9.1 1,482 10/9/2020
2020.10.8.1 1,476 10/8/2020
2020.10.6.8 1,581 10/7/2020
2020.10.6.6 1,550 10/7/2020
2020.10.6.5 1,454 10/7/2020
2020.10.6.4 1,435 10/7/2020
2020.10.6.3 1,465 10/7/2020
2020.10.6.2 1,369 10/7/2020
2020.10.6.1 1,471 10/7/2020
2020.10.5.1 1,584 10/6/2020
2020.10.1.3 1,381 10/1/2020
2020.10.1.2 1,424 10/1/2020
2020.10.1.1 1,521 10/1/2020
2020.9.29.10 1,562 9/29/2020
2020.9.29.9 1,502 9/29/2020
2020.9.28.2 1,414 9/28/2020
2020.9.28.1 1,458 9/28/2020
2020.9.25.1 1,648 9/26/2020
2020.9.24.2 1,406 9/24/2020
2020.9.24 1,463 9/24/2020
2020.9.23.2 1,450 9/23/2020
2020.9.23.1 1,454 9/23/2020
2020.9.22.1 1,398 9/22/2020
2020.9.21.1 1,522 9/21/2020
2020.9.17.2 1,460 9/17/2020
2020.9.16 1,498 9/16/2020
2020.9.15 1,507 9/15/2020
2020.9.9.2 1,440 9/9/2020
2020.9.8.1 1,434 9/8/2020
2020.9.6.5 1,540 9/6/2020
2020.9.4.2 1,445 9/4/2020
2020.9.4.1 1,460 9/4/2020
2020.9.4 1,415 9/4/2020
2020.9.3.1 1,427 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