Walter.Web.FireWall.SqlLogger 2020.9.9.2

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

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

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. 
.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.11.20.644 44 11/21/2024
2024.11.15.421 77 11/15/2024
2024.11.11.1334 66 11/14/2024
2024.11.6.1222 87 11/6/2024
2024.10.28.1605 79 10/28/2024
2024.10.28.1335 78 10/28/2024
2024.10.19.1525 84 10/20/2024
2024.10.18.1315 102 10/18/2024
2024.9.27.1406 91 9/27/2024
2024.9.17.1417 103 9/17/2024
2024.9.12.1923 99 9/12/2024
2024.9.6.1352 102 9/7/2024
2024.9.1.1159 112 9/1/2024
2024.8.26.1150 111 8/26/2024
2024.8.19.1411 132 8/19/2024
2024.8.17.1000 114 8/17/2024
2024.8.12.1622 123 8/13/2024
2024.8.5.1010 83 8/5/2024
2024.8.1.1545 121 8/16/2024
2024.7.28.629 70 7/28/2024
2024.7.26.1512 73 7/26/2024
2024.7.26.828 71 7/26/2024
2024.7.11.1604 110 7/11/2024
2024.7.9.1520 104 7/9/2024
2024.7.4.1425 86 7/4/2024
2024.7.3.1249 88 7/3/2024
2024.7.2.1536 112 7/2/2024
2024.6.28.953 96 6/28/2024
2023.11.13.1117 634 11/13/2023
2023.10.26.1502 563 10/29/2023
2023.10.12.1926 593 10/12/2023
2023.9.14.812 687 9/14/2023
2023.9.7.1748 675 9/7/2023
2023.9.7.1241 668 9/7/2023
2023.9.6.1001 643 9/6/2023
2023.9.5.1246 665 9/5/2023
2023.9.5.1032 660 9/5/2023
2023.8.31.1522 641 8/31/2023
2023.8.29.1040 670 8/29/2023
2023.8.17.901 739 8/17/2023
2023.8.9.1314 769 8/9/2023
2023.8.2.750 762 8/2/2023
2023.7.12.830 779 7/12/2023
2023.7.5.1419 770 7/6/2023
2023.6.14.1628 831 6/14/2023
2023.6.11.1304 810 6/11/2023
2023.5.30.1640 800 5/30/2023
2023.5.4.1552 830 5/4/2023
2023.4.29.910 845 4/29/2023
2023.4.12.1236 906 4/12/2023
2023.3.22.1456 937 3/22/2023
2023.3.14.1356 937 3/14/2023
2023.3.1.810 862 3/1/2023
2023.2.25.11857 899 2/25/2023
2023.2.22.27 962 2/22/2023
2023.2.15.1413 939 2/15/2023
2023.2.11.1628 929 2/11/2023
2023.1.11.534 999 1/11/2023
2022.12.30.711 1,012 12/30/2022
2022.12.15.1108 1,009 12/15/2022
2022.12.14.648 973 12/14/2022
2022.11.27.1059 1,050 11/27/2022
2022.11.21.338 1,013 11/21/2022
2022.11.14.1819 1,090 11/14/2022
2022.11.13.917 1,019 11/13/2022
2022.10.31.740 1,091 11/1/2022
2022.10.15.652 1,201 10/15/2022
2022.10.1.810 1,184 10/1/2022
2022.9.26.1444 1,200 9/26/2022
2022.9.14.1508 1,217 9/14/2022
2022.9.14.809 1,272 9/14/2022
2022.9.8.1009 1,279 9/8/2022
2022.8.20.1007 1,233 8/20/2022
2022.8.1.1 1,206 7/31/2022
2022.7.1300 1,250 7/1/2022
2022.7.31.1016 1,178 7/31/2022
2022.7.15.841 1,266 7/15/2022
2022.6.21.647 1,236 6/21/2022
2022.5.18.638 1,256 5/19/2022
2022.5.16.853 1,236 5/19/2022
2022.5.16.816 1,280 5/16/2022
2022.5.4.1010 1,226 5/4/2022
2022.4.10.947 1,378 4/10/2022
2022.4.10.925 1,296 4/10/2022
2022.4.10.828 1,302 4/10/2022
2022.4.1.1545 1,342 4/1/2022
2022.3.26.1103 1,294 3/26/2022
2022.3.26.820 1,271 3/26/2022
2022.3.25.840 1,268 3/26/2022
2022.2.16.1131 1,311 2/17/2022
2022.2.16.834 1,311 2/17/2022
2022.2.5.1114 1,380 2/5/2022
2022.1.17.1158 1,347 1/17/2022
2022.1.10.1505 1,443 1/10/2022
2022.1.10.537 1,302 1/10/2022
2022.1.5.1139 1,133 1/8/2022
2021.12.28.1452 1,150 12/28/2021
2021.12.16.812 1,236 12/16/2021
2021.11.23.1528 7,422 11/24/2021
2021.11.21.925 1,289 11/22/2021
2021.11.19.1503 1,272 11/22/2021
2021.11.19.847 1,304 11/19/2021
2021.11.18.1824 1,276 11/16/2021
2021.11.10.852 1,245 11/10/2021
2021.11.9.2021 1,398 11/9/2021
2021.11.8.2109 1,217 11/9/2021
2021.11.8.1612 1,258 11/8/2021
2021.11.7.1021 1,292 11/8/2021
2021.11.3.1612 1,396 11/4/2021
2021.11.1.1102 1,269 11/1/2021
2021.10.25.1206 1,307 10/25/2021
2021.10.23.1310 1,311 10/25/2021
2021.10.19.1522 1,291 10/19/2021
2021.10.16.1325 1,199 10/18/2021
2021.10.9.1119 82 10/9/2024
2021.10.6.1546 1,285 10/6/2021
2021.10.5.1450 1,323 10/5/2021
2021.10.4.1155 1,338 10/5/2021
2021.10.1.753 1,406 10/1/2021
2021.9.27.1005 1,305 9/28/2021
2021.9.26.1913 1,310 9/26/2021
2021.9.19.1015 1,372 9/19/2021
2021.9.17.1702 1,249 9/17/2021
2021.9.17.1449 1,282 9/17/2021
2021.9.13.1600 1,374 9/13/2021
2021.9.9.1110 1,323 9/9/2021
2021.9.7.1901 1,200 9/8/2021
2021.9.7.1121 1,357 9/7/2021
2021.9.6.1518 1,247 9/7/2021
2021.9.4.1124 1,396 9/4/2021
2021.9.2.708 1,265 9/4/2021
2021.9.0.1259 1,244 9/2/2021
2021.8.2200 1,261 8/23/2021
2021.8.2100 1,346 8/23/2021
2021.8.22.900 1,373 8/22/2021
2021.8.18.1500 1,281 8/18/2021
2021.8.18.930 1,241 8/18/2021
2021.8.14.1600 1,264 8/16/2021
2021.8.9.1105 1,243 8/9/2021
2021.8.8.1612 1,217 8/8/2021
2021.8.8.1138 1,349 8/8/2021
2021.8.6.1044 1,376 8/6/2021
2021.8.4.1355 1,329 8/5/2021
2021.7.30.2118 1,333 7/31/2021
2021.7.27.926 1,317 7/28/2021
2021.7.23.931 1,283 7/26/2021
2021.7.22.1456 1,378 7/23/2021
2021.7.15.1547 1,354 7/15/2021
2021.7.13.812 1,347 7/13/2021
2021.7.8.1527 1,501 7/10/2021
2021.7.5.1649 1,361 7/5/2021
2021.6.29.1453 1,361 6/30/2021
2021.6.26.1753 1,477 6/27/2021
2021.6.25.1849 1,315 6/25/2021
2021.6.24.1518 1,373 6/24/2021
2021.6.20.729 1,278 6/20/2021
2021.6.15.2006 1,325 6/15/2021
2021.6.14.2025 1,387 6/15/2021
2021.6.13.2035 1,284 6/14/2021
2021.6.12.1154 1,230 6/13/2021
2021.6.9.1120 1,317 6/9/2021
2021.6.3.1509 1,313 6/3/2021
2021.5.31.1533 1,328 5/31/2021
2021.5.31.1415 1,381 5/31/2021
2021.5.25.1732 1,324 5/25/2021
2021.5.24.1128 1,317 5/24/2021
2021.5.24.1019 1,252 5/24/2021
2021.5.12.1054 1,255 5/12/2021
2021.5.12.637 1,224 5/12/2021
2021.5.10.1442 1,340 5/11/2021
2021.5.8.1226 1,255 5/8/2021
2021.5.6.2037 1,301 5/6/2021
2021.5.5.1901 1,345 5/6/2021
2021.5.3.1621 1,272 5/4/2021
2021.5.1.905 1,224 5/1/2021
2021.4.28.1511 1,302 4/28/2021
2021.4.20.1520 1,238 4/21/2021
2021.4.16.738 1,275 4/21/2021
2021.4.14.1216 1,287 4/16/2021
2021.4.9.1538 1,264 4/13/2021
2021.4.8.947 1,314 4/13/2021
2021.4.6.1235 1,304 4/6/2021
2021.4.5.1653 1,271 4/5/2021
2021.4.1.913 1,263 4/1/2021
2021.3.31.2003 1,251 4/1/2021
2021.3.18.1622 1,344 3/18/2021
2021.3.3.1259 1,423 3/3/2021
2021.3.2.1415 1,402 3/2/2021
2021.3.1.11 1,347 2/28/2021
2021.3.1.1 1,405 2/27/2021
2021.3.1 1,371 2/27/2021
2021.2.23.6 1,341 2/23/2021
2021.2.21.1 1,266 2/21/2021
2021.2.20.1 1,288 2/20/2021
2021.2.19.2 1,265 2/19/2021
2021.2.18.6 1,335 2/19/2021
2021.2.17.1 1,429 2/17/2021
2021.2.16.1 1,447 2/16/2021
2021.2.15.3 1,413 2/15/2021
2021.2.15.1 1,386 2/14/2021
2021.2.14.3 1,402 2/14/2021
2021.2.12.6 1,320 2/12/2021
2021.2.12.2 1,393 2/12/2021
2021.2.11.1 1,380 2/11/2021
2021.2.10.1 1,476 2/10/2021
2021.2.8.1 1,471 2/9/2021
2021.2.7.2 1,479 2/7/2021
2021.2.7.1 1,333 2/6/2021
2020.12.27.6 1,489 12/27/2020
2020.12.27.1 1,374 12/27/2020
2020.12.26.7 1,375 12/27/2020
2020.12.26.5 1,409 12/27/2020
2020.12.26.3 1,347 12/27/2020
2020.12.19.1 1,620 12/19/2020
2020.12.16.1 1,401 12/16/2020
2020.12.15.1 1,331 12/15/2020
2020.12.14.5 1,370 12/14/2020
2020.12.14.4 1,463 12/14/2020
2020.12.14.3 1,455 12/14/2020
2020.12.4.4 1,452 12/4/2020
2020.12.4.3 1,456 12/4/2020
2020.12.3.1 1,448 12/3/2020
2020.12.2.4 1,388 12/2/2020
2020.12.2.3 1,506 12/2/2020
2020.12.1.1 1,461 12/1/2020
2020.11.28.1 1,510 11/28/2020
2020.11.27.2 1,468 11/27/2020
2020.11.27.1 1,417 11/27/2020
2020.11.25.1 1,384 11/25/2020
2020.11.22.3 1,445 11/23/2020
2020.11.20.1 1,545 11/21/2020
2020.11.19.3 1,518 11/19/2020
2020.11.19.1 1,511 11/19/2020
2020.11.18.2 1,493 11/18/2020
2020.11.17.2 1,514 11/17/2020
2020.11.17.1 1,479 11/17/2020
2020.11.15.1 1,413 11/15/2020
2020.11.14.1 1,603 11/14/2020
2020.11.13.3 1,663 11/14/2020
2020.11.13.2 1,349 11/13/2020
2020.11.13.1 1,454 11/13/2020
2020.11.12.1 1,494 11/12/2020
2020.11.11.1 1,491 11/11/2020
2020.11.8.1 1,557 11/8/2020
2020.11.7.1 1,434 11/7/2020
2020.11.5.1 1,500 11/5/2020
2020.11.3.1 1,452 11/3/2020
2020.11.1.3 1,460 11/1/2020
2020.11.1.2 1,497 11/1/2020
2020.11.1.1 1,507 11/1/2020
2020.10.30.1 1,460 11/1/2020
2020.10.15.3 1,422 10/15/2020
2020.10.15.2 1,538 10/15/2020
2020.10.14.1 1,482 10/14/2020
2020.10.13.1 1,477 10/13/2020
2020.10.12.2 1,471 10/12/2020
2020.10.12.1 1,471 10/12/2020
2020.10.10.1 1,603 10/10/2020
2020.10.9.6 1,379 10/9/2020
2020.10.9.2 1,445 10/9/2020
2020.10.9.1 1,478 10/9/2020
2020.10.8.1 1,473 10/8/2020
2020.10.6.8 1,577 10/7/2020
2020.10.6.6 1,546 10/7/2020
2020.10.6.5 1,450 10/7/2020
2020.10.6.4 1,431 10/7/2020
2020.10.6.3 1,461 10/7/2020
2020.10.6.2 1,365 10/7/2020
2020.10.6.1 1,467 10/7/2020
2020.10.5.1 1,581 10/6/2020
2020.10.1.3 1,377 10/1/2020
2020.10.1.2 1,420 10/1/2020
2020.10.1.1 1,517 10/1/2020
2020.9.29.10 1,558 9/29/2020
2020.9.29.9 1,499 9/29/2020
2020.9.28.2 1,410 9/28/2020
2020.9.28.1 1,454 9/28/2020
2020.9.25.1 1,644 9/26/2020
2020.9.24.2 1,402 9/24/2020
2020.9.24 1,459 9/24/2020
2020.9.23.2 1,446 9/23/2020
2020.9.23.1 1,450 9/23/2020
2020.9.22.1 1,394 9/22/2020
2020.9.21.1 1,518 9/21/2020
2020.9.17.2 1,456 9/17/2020
2020.9.16 1,494 9/16/2020
2020.9.15 1,503 9/15/2020
2020.9.9.2 1,435 9/9/2020
2020.9.8.1 1,430 9/8/2020
2020.9.6.5 1,537 9/6/2020
2020.9.4.2 1,441 9/4/2020
2020.9.4.1 1,456 9/4/2020
2020.9.4 1,411 9/4/2020
2020.9.3.1 1,423 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