Walter.Web.FireWall.SqlLogger 2020.10.14.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.10.14.1                
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.10.14.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.10.14.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.10.14.1                
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.10.14.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.10.14.1

// Install Walter.Web.FireWall.SqlLogger as a Cake Tool
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.10.14.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.  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. 
.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.3.13.1323 91 3/13/2025
2025.2.26.1642 99 2/26/2025
2025.2.25.1033 91 2/26/2025
2025.2.24.1556 86 2/25/2025
2025.2.16.1149 104 2/19/2025
2025.2.15.1316 102 2/15/2025
2025.1.16.1410 83 1/16/2025
2025.1.4.1941 112 1/4/2025
2025.1.2.1544 124 1/3/2025
2024.12.14.838 86 12/14/2024
2024.12.13.1227 85 12/13/2024
2024.11.28.1632 86 11/28/2024
2024.11.20.644 111 11/21/2024
2024.11.15.421 100 11/15/2024
2024.11.11.1334 87 11/14/2024
2024.11.6.1222 108 11/6/2024
2024.10.28.1605 94 10/28/2024
2024.10.28.1335 93 10/28/2024
2024.10.19.1525 97 10/20/2024
2024.10.18.1315 118 10/18/2024
2024.9.27.1406 105 9/27/2024
2024.9.17.1417 133 9/17/2024
2024.9.12.1923 111 9/12/2024
2024.9.6.1352 116 9/7/2024
2024.9.1.1159 121 9/1/2024
2024.8.26.1150 139 8/26/2024
2024.8.19.1411 157 8/19/2024
2024.8.17.1000 124 8/17/2024
2024.8.12.1622 134 8/13/2024
2024.8.5.1010 98 8/5/2024
2024.8.1.1545 130 8/16/2024
2024.7.28.629 80 7/28/2024
2024.7.26.1512 83 7/26/2024
2024.7.26.828 83 7/26/2024
2024.7.11.1604 126 7/11/2024
2024.7.9.1520 115 7/9/2024
2024.7.4.1425 99 7/4/2024
2024.7.3.1249 99 7/3/2024
2024.7.2.1536 123 7/2/2024
2024.6.28.953 110 6/28/2024
2023.11.13.1117 644 11/13/2023
2023.10.26.1502 591 10/29/2023
2023.10.12.1926 602 10/12/2023
2023.9.14.812 695 9/14/2023
2023.9.7.1748 682 9/7/2023
2023.9.7.1241 675 9/7/2023
2023.9.6.1001 650 9/6/2023
2023.9.5.1246 672 9/5/2023
2023.9.5.1032 667 9/5/2023
2023.8.31.1522 648 8/31/2023
2023.8.29.1040 677 8/29/2023
2023.8.17.901 746 8/17/2023
2023.8.9.1314 776 8/9/2023
2023.8.2.750 771 8/2/2023
2023.7.12.830 785 7/12/2023
2023.7.5.1419 777 7/6/2023
2023.6.14.1628 840 6/14/2023
2023.6.11.1304 819 6/11/2023
2023.5.30.1640 811 5/30/2023
2023.5.4.1552 845 5/4/2023
2023.4.29.910 856 4/29/2023
2023.4.12.1236 917 4/12/2023
2023.3.22.1456 948 3/22/2023
2023.3.14.1356 949 3/14/2023
2023.3.1.810 889 3/1/2023
2023.2.25.11857 911 2/25/2023
2023.2.22.27 974 2/22/2023
2023.2.15.1413 951 2/15/2023
2023.2.11.1628 940 2/11/2023
2023.1.11.534 1,012 1/11/2023
2022.12.30.711 1,025 12/30/2022
2022.12.15.1108 1,028 12/15/2022
2022.12.14.648 986 12/14/2022
2022.11.27.1059 1,065 11/27/2022
2022.11.21.338 1,028 11/21/2022
2022.11.14.1819 1,105 11/14/2022
2022.11.13.917 1,033 11/13/2022
2022.10.31.740 1,106 11/1/2022
2022.10.15.652 1,216 10/15/2022
2022.10.1.810 1,199 10/1/2022
2022.9.26.1444 1,216 9/26/2022
2022.9.14.1508 1,233 9/14/2022
2022.9.14.809 1,288 9/14/2022
2022.9.8.1009 1,295 9/8/2022
2022.8.20.1007 1,249 8/20/2022
2022.8.1.1 1,224 7/31/2022
2022.7.1300 1,266 7/1/2022
2022.7.31.1016 1,194 7/31/2022
2022.7.15.841 1,282 7/15/2022
2022.6.21.647 1,269 6/21/2022
2022.5.18.638 1,278 5/19/2022
2022.5.16.853 1,271 5/19/2022
2022.5.16.816 1,296 5/16/2022
2022.5.4.1010 1,245 5/4/2022
2022.4.10.947 1,397 4/10/2022
2022.4.10.925 1,315 4/10/2022
2022.4.10.828 1,321 4/10/2022
2022.4.1.1545 1,362 4/1/2022
2022.3.26.1103 1,343 3/26/2022
2022.3.26.820 1,289 3/26/2022
2022.3.25.840 1,287 3/26/2022
2022.2.16.1131 1,331 2/17/2022
2022.2.16.834 1,332 2/17/2022
2022.2.5.1114 1,400 2/5/2022
2022.1.17.1158 1,367 1/17/2022
2022.1.10.1505 1,463 1/10/2022
2022.1.10.537 1,322 1/10/2022
2022.1.5.1139 1,154 1/8/2022
2021.12.28.1452 1,170 12/28/2021
2021.12.16.812 1,256 12/16/2021
2021.11.23.1528 7,443 11/24/2021
2021.11.21.925 1,309 11/22/2021
2021.11.19.1503 1,292 11/22/2021
2021.11.19.847 1,325 11/19/2021
2021.11.18.1824 1,298 11/16/2021
2021.11.10.852 1,264 11/10/2021
2021.11.9.2021 1,418 11/9/2021
2021.11.8.2109 1,255 11/9/2021
2021.11.8.1612 1,277 11/8/2021
2021.11.7.1021 1,312 11/8/2021
2021.11.3.1612 1,416 11/4/2021
2021.11.1.1102 1,289 11/1/2021
2021.10.25.1206 1,328 10/25/2021
2021.10.23.1310 1,331 10/25/2021
2021.10.19.1522 1,311 10/19/2021
2021.10.16.1325 1,221 10/18/2021
2021.10.9.1119 94 10/9/2024
2021.10.6.1546 1,305 10/6/2021
2021.10.5.1450 1,345 10/5/2021
2021.10.4.1155 1,360 10/5/2021
2021.10.1.753 1,425 10/1/2021
2021.9.27.1005 1,325 9/28/2021
2021.9.26.1913 1,330 9/26/2021
2021.9.19.1015 1,392 9/19/2021
2021.9.17.1702 1,268 9/17/2021
2021.9.17.1449 1,302 9/17/2021
2021.9.13.1600 1,394 9/13/2021
2021.9.9.1110 1,342 9/9/2021
2021.9.7.1901 1,220 9/8/2021
2021.9.7.1121 1,377 9/7/2021
2021.9.6.1518 1,267 9/7/2021
2021.9.4.1124 1,417 9/4/2021
2021.9.2.708 1,285 9/4/2021
2021.9.0.1259 1,264 9/2/2021
2021.8.2200 1,281 8/23/2021
2021.8.2100 1,367 8/23/2021
2021.8.22.900 1,393 8/22/2021
2021.8.18.1500 1,300 8/18/2021
2021.8.18.930 1,261 8/18/2021
2021.8.14.1600 1,283 8/16/2021
2021.8.9.1105 1,264 8/9/2021
2021.8.8.1612 1,236 8/8/2021
2021.8.8.1138 1,368 8/8/2021
2021.8.6.1044 1,394 8/6/2021
2021.8.4.1355 1,348 8/5/2021
2021.7.30.2118 1,353 7/31/2021
2021.7.27.926 1,336 7/28/2021
2021.7.23.931 1,302 7/26/2021
2021.7.22.1456 1,397 7/23/2021
2021.7.15.1547 1,373 7/15/2021
2021.7.13.812 1,367 7/13/2021
2021.7.8.1527 1,520 7/10/2021
2021.7.5.1649 1,380 7/5/2021
2021.6.29.1453 1,380 6/30/2021
2021.6.26.1753 1,496 6/27/2021
2021.6.25.1849 1,334 6/25/2021
2021.6.24.1518 1,392 6/24/2021
2021.6.20.729 1,297 6/20/2021
2021.6.15.2006 1,342 6/15/2021
2021.6.14.2025 1,407 6/15/2021
2021.6.13.2035 1,303 6/14/2021
2021.6.12.1154 1,249 6/13/2021
2021.6.9.1120 1,336 6/9/2021
2021.6.3.1509 1,332 6/3/2021
2021.5.31.1533 1,347 5/31/2021
2021.5.31.1415 1,400 5/31/2021
2021.5.25.1732 1,344 5/25/2021
2021.5.24.1128 1,336 5/24/2021
2021.5.24.1019 1,272 5/24/2021
2021.5.12.1054 1,274 5/12/2021
2021.5.12.637 1,243 5/12/2021
2021.5.10.1442 1,359 5/11/2021
2021.5.8.1226 1,276 5/8/2021
2021.5.6.2037 1,321 5/6/2021
2021.5.5.1901 1,365 5/6/2021
2021.5.3.1621 1,292 5/4/2021
2021.5.1.905 1,244 5/1/2021
2021.4.28.1511 1,323 4/28/2021
2021.4.20.1520 1,264 4/21/2021
2021.4.16.738 1,295 4/21/2021
2021.4.14.1216 1,307 4/16/2021
2021.4.9.1538 1,284 4/13/2021
2021.4.8.947 1,334 4/13/2021
2021.4.6.1235 1,326 4/6/2021
2021.4.5.1653 1,293 4/5/2021
2021.4.1.913 1,284 4/1/2021
2021.3.31.2003 1,274 4/1/2021
2021.3.18.1622 1,364 3/18/2021
2021.3.3.1259 1,444 3/3/2021
2021.3.2.1415 1,423 3/2/2021
2021.3.1.11 1,387 2/28/2021
2021.3.1.1 1,426 2/27/2021
2021.3.1 1,392 2/27/2021
2021.2.23.6 1,363 2/23/2021
2021.2.21.1 1,287 2/21/2021
2021.2.20.1 1,309 2/20/2021
2021.2.19.2 1,286 2/19/2021
2021.2.18.6 1,356 2/19/2021
2021.2.17.1 1,450 2/17/2021
2021.2.16.1 1,467 2/16/2021
2021.2.15.3 1,452 2/15/2021
2021.2.15.1 1,407 2/14/2021
2021.2.14.3 1,423 2/14/2021
2021.2.12.6 1,360 2/12/2021
2021.2.12.2 1,414 2/12/2021
2021.2.11.1 1,401 2/11/2021
2021.2.10.1 1,497 2/10/2021
2021.2.8.1 1,492 2/9/2021
2021.2.7.2 1,500 2/7/2021
2021.2.7.1 1,356 2/6/2021
2020.12.27.6 1,510 12/27/2020
2020.12.27.1 1,393 12/27/2020
2020.12.26.7 1,396 12/27/2020
2020.12.26.5 1,430 12/27/2020
2020.12.26.3 1,369 12/27/2020
2020.12.19.1 1,640 12/19/2020
2020.12.16.1 1,421 12/16/2020
2020.12.15.1 1,356 12/15/2020
2020.12.14.5 1,391 12/14/2020
2020.12.14.4 1,484 12/14/2020
2020.12.14.3 1,476 12/14/2020
2020.12.4.4 1,473 12/4/2020
2020.12.4.3 1,477 12/4/2020
2020.12.3.1 1,469 12/3/2020
2020.12.2.4 1,409 12/2/2020
2020.12.2.3 1,527 12/2/2020
2020.12.1.1 1,482 12/1/2020
2020.11.28.1 1,531 11/28/2020
2020.11.27.2 1,489 11/27/2020
2020.11.27.1 1,438 11/27/2020
2020.11.25.1 1,406 11/25/2020
2020.11.22.3 1,468 11/23/2020
2020.11.20.1 1,566 11/21/2020
2020.11.19.3 1,539 11/19/2020
2020.11.19.1 1,532 11/19/2020
2020.11.18.2 1,515 11/18/2020
2020.11.17.2 1,537 11/17/2020
2020.11.17.1 1,500 11/17/2020
2020.11.15.1 1,435 11/15/2020
2020.11.14.1 1,624 11/14/2020
2020.11.13.3 1,682 11/14/2020
2020.11.13.2 1,370 11/13/2020
2020.11.13.1 1,476 11/13/2020
2020.11.12.1 1,516 11/12/2020
2020.11.11.1 1,512 11/11/2020
2020.11.8.1 1,578 11/8/2020
2020.11.7.1 1,456 11/7/2020
2020.11.5.1 1,522 11/5/2020
2020.11.3.1 1,473 11/3/2020
2020.11.1.3 1,491 11/1/2020
2020.11.1.2 1,527 11/1/2020
2020.11.1.1 1,529 11/1/2020
2020.10.30.1 1,481 11/1/2020
2020.10.15.3 1,441 10/15/2020
2020.10.15.2 1,557 10/15/2020
2020.10.14.1 1,504 10/14/2020
2020.10.13.1 1,497 10/13/2020
2020.10.12.2 1,491 10/12/2020
2020.10.12.1 1,492 10/12/2020
2020.10.10.1 1,623 10/10/2020
2020.10.9.6 1,399 10/9/2020
2020.10.9.2 1,466 10/9/2020
2020.10.9.1 1,497 10/9/2020
2020.10.8.1 1,492 10/8/2020
2020.10.6.8 1,596 10/7/2020
2020.10.6.6 1,565 10/7/2020
2020.10.6.5 1,469 10/7/2020
2020.10.6.4 1,450 10/7/2020
2020.10.6.3 1,480 10/7/2020
2020.10.6.2 1,384 10/7/2020
2020.10.6.1 1,487 10/7/2020
2020.10.5.1 1,600 10/6/2020
2020.10.1.3 1,397 10/1/2020
2020.10.1.2 1,440 10/1/2020
2020.10.1.1 1,536 10/1/2020
2020.9.29.10 1,578 9/29/2020
2020.9.29.9 1,517 9/29/2020
2020.9.28.2 1,430 9/28/2020
2020.9.28.1 1,474 9/28/2020
2020.9.25.1 1,664 9/26/2020
2020.9.24.2 1,421 9/24/2020
2020.9.24 1,479 9/24/2020
2020.9.23.2 1,465 9/23/2020
2020.9.23.1 1,471 9/23/2020
2020.9.22.1 1,413 9/22/2020
2020.9.21.1 1,538 9/21/2020
2020.9.17.2 1,475 9/17/2020
2020.9.16 1,513 9/16/2020
2020.9.15 1,522 9/15/2020
2020.9.9.2 1,455 9/9/2020
2020.9.8.1 1,450 9/8/2020
2020.9.6.5 1,556 9/6/2020
2020.9.4.2 1,461 9/4/2020
2020.9.4.1 1,508 9/4/2020
2020.9.4 1,469 9/4/2020
2020.9.3.1 1,442 9/3/2020

14 October 2020
     - Update to .net core 3.1.4
     
     12 October 2020
     - Implement changed database reporting interface

     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