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

// Install Walter.Web.FireWall.SqlLogger as a Cake Tool
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.28.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 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.11.6.1222 49 11/6/2024
2024.10.28.1605 72 10/28/2024
2024.10.28.1335 71 10/28/2024
2024.10.19.1525 78 10/20/2024
2024.10.18.1315 96 10/18/2024
2024.9.27.1406 88 9/27/2024
2024.9.17.1417 101 9/17/2024
2024.9.12.1923 97 9/12/2024
2024.9.6.1352 98 9/7/2024
2024.9.1.1159 110 9/1/2024
2024.8.26.1150 109 8/26/2024
2024.8.19.1411 130 8/19/2024
2024.8.17.1000 112 8/17/2024
2024.8.12.1622 121 8/13/2024
2024.8.5.1010 80 8/5/2024
2024.8.1.1545 119 8/16/2024
2024.7.28.629 68 7/28/2024
2024.7.26.1512 71 7/26/2024
2024.7.26.828 69 7/26/2024
2024.7.11.1604 108 7/11/2024
2024.7.9.1520 102 7/9/2024
2024.7.4.1425 84 7/4/2024
2024.7.3.1249 86 7/3/2024
2024.7.2.1536 110 7/2/2024
2024.6.28.953 93 6/28/2024
2023.11.13.1117 632 11/13/2023
2023.10.26.1502 561 10/29/2023
2023.10.12.1926 591 10/12/2023
2023.9.14.812 683 9/14/2023
2023.9.7.1748 673 9/7/2023
2023.9.7.1241 665 9/7/2023
2023.9.6.1001 641 9/6/2023
2023.9.5.1246 663 9/5/2023
2023.9.5.1032 658 9/5/2023
2023.8.31.1522 637 8/31/2023
2023.8.29.1040 668 8/29/2023
2023.8.17.901 737 8/17/2023
2023.8.9.1314 767 8/9/2023
2023.8.2.750 760 8/2/2023
2023.7.12.830 777 7/12/2023
2023.7.5.1419 768 7/6/2023
2023.6.14.1628 828 6/14/2023
2023.6.11.1304 808 6/11/2023
2023.5.30.1640 797 5/30/2023
2023.5.4.1552 828 5/4/2023
2023.4.29.910 842 4/29/2023
2023.4.12.1236 902 4/12/2023
2023.3.22.1456 935 3/22/2023
2023.3.14.1356 934 3/14/2023
2023.3.1.810 860 3/1/2023
2023.2.25.11857 897 2/25/2023
2023.2.22.27 960 2/22/2023
2023.2.15.1413 935 2/15/2023
2023.2.11.1628 927 2/11/2023
2023.1.11.534 997 1/11/2023
2022.12.30.711 1,010 12/30/2022
2022.12.15.1108 1,007 12/15/2022
2022.12.14.648 971 12/14/2022
2022.11.27.1059 1,048 11/27/2022
2022.11.21.338 1,011 11/21/2022
2022.11.14.1819 1,088 11/14/2022
2022.11.13.917 1,017 11/13/2022
2022.10.31.740 1,089 11/1/2022
2022.10.15.652 1,199 10/15/2022
2022.10.1.810 1,182 10/1/2022
2022.9.26.1444 1,198 9/26/2022
2022.9.14.1508 1,215 9/14/2022
2022.9.14.809 1,268 9/14/2022
2022.9.8.1009 1,277 9/8/2022
2022.8.20.1007 1,231 8/20/2022
2022.8.1.1 1,204 7/31/2022
2022.7.1300 1,248 7/1/2022
2022.7.31.1016 1,176 7/31/2022
2022.7.15.841 1,264 7/15/2022
2022.6.21.647 1,234 6/21/2022
2022.5.18.638 1,254 5/19/2022
2022.5.16.853 1,234 5/19/2022
2022.5.16.816 1,278 5/16/2022
2022.5.4.1010 1,224 5/4/2022
2022.4.10.947 1,376 4/10/2022
2022.4.10.925 1,294 4/10/2022
2022.4.10.828 1,300 4/10/2022
2022.4.1.1545 1,339 4/1/2022
2022.3.26.1103 1,292 3/26/2022
2022.3.26.820 1,269 3/26/2022
2022.3.25.840 1,266 3/26/2022
2022.2.16.1131 1,308 2/17/2022
2022.2.16.834 1,309 2/17/2022
2022.2.5.1114 1,378 2/5/2022
2022.1.17.1158 1,345 1/17/2022
2022.1.10.1505 1,441 1/10/2022
2022.1.10.537 1,300 1/10/2022
2022.1.5.1139 1,130 1/8/2022
2021.12.28.1452 1,148 12/28/2021
2021.12.16.812 1,234 12/16/2021
2021.11.23.1528 7,420 11/24/2021
2021.11.21.925 1,287 11/22/2021
2021.11.19.1503 1,269 11/22/2021
2021.11.19.847 1,302 11/19/2021
2021.11.18.1824 1,274 11/16/2021
2021.11.10.852 1,242 11/10/2021
2021.11.9.2021 1,395 11/9/2021
2021.11.8.2109 1,215 11/9/2021
2021.11.8.1612 1,256 11/8/2021
2021.11.7.1021 1,290 11/8/2021
2021.11.3.1612 1,394 11/4/2021
2021.11.1.1102 1,267 11/1/2021
2021.10.25.1206 1,305 10/25/2021
2021.10.23.1310 1,309 10/25/2021
2021.10.19.1522 1,289 10/19/2021
2021.10.16.1325 1,196 10/18/2021
2021.10.9.1119 76 10/9/2024
2021.10.6.1546 1,282 10/6/2021
2021.10.5.1450 1,321 10/5/2021
2021.10.4.1155 1,336 10/5/2021
2021.10.1.753 1,404 10/1/2021
2021.9.27.1005 1,302 9/28/2021
2021.9.26.1913 1,307 9/26/2021
2021.9.19.1015 1,370 9/19/2021
2021.9.17.1702 1,247 9/17/2021
2021.9.17.1449 1,279 9/17/2021
2021.9.13.1600 1,371 9/13/2021
2021.9.9.1110 1,320 9/9/2021
2021.9.7.1901 1,197 9/8/2021
2021.9.7.1121 1,355 9/7/2021
2021.9.6.1518 1,245 9/7/2021
2021.9.4.1124 1,376 9/4/2021
2021.9.2.708 1,263 9/4/2021
2021.9.0.1259 1,242 9/2/2021
2021.8.2200 1,240 8/23/2021
2021.8.2100 1,325 8/23/2021
2021.8.22.900 1,371 8/22/2021
2021.8.18.1500 1,279 8/18/2021
2021.8.18.930 1,239 8/18/2021
2021.8.14.1600 1,262 8/16/2021
2021.8.9.1105 1,240 8/9/2021
2021.8.8.1612 1,215 8/8/2021
2021.8.8.1138 1,347 8/8/2021
2021.8.6.1044 1,374 8/6/2021
2021.8.4.1355 1,327 8/5/2021
2021.7.30.2118 1,331 7/31/2021
2021.7.27.926 1,314 7/28/2021
2021.7.23.931 1,281 7/26/2021
2021.7.22.1456 1,376 7/23/2021
2021.7.15.1547 1,352 7/15/2021
2021.7.13.812 1,345 7/13/2021
2021.7.8.1527 1,499 7/10/2021
2021.7.5.1649 1,359 7/5/2021
2021.6.29.1453 1,359 6/30/2021
2021.6.26.1753 1,474 6/27/2021
2021.6.25.1849 1,313 6/25/2021
2021.6.24.1518 1,370 6/24/2021
2021.6.20.729 1,276 6/20/2021
2021.6.15.2006 1,323 6/15/2021
2021.6.14.2025 1,385 6/15/2021
2021.6.13.2035 1,282 6/14/2021
2021.6.12.1154 1,228 6/13/2021
2021.6.9.1120 1,315 6/9/2021
2021.6.3.1509 1,311 6/3/2021
2021.5.31.1533 1,325 5/31/2021
2021.5.31.1415 1,379 5/31/2021
2021.5.25.1732 1,322 5/25/2021
2021.5.24.1128 1,315 5/24/2021
2021.5.24.1019 1,250 5/24/2021
2021.5.12.1054 1,253 5/12/2021
2021.5.12.637 1,222 5/12/2021
2021.5.10.1442 1,338 5/11/2021
2021.5.8.1226 1,252 5/8/2021
2021.5.6.2037 1,298 5/6/2021
2021.5.5.1901 1,343 5/6/2021
2021.5.3.1621 1,270 5/4/2021
2021.5.1.905 1,222 5/1/2021
2021.4.28.1511 1,300 4/28/2021
2021.4.20.1520 1,236 4/21/2021
2021.4.16.738 1,273 4/21/2021
2021.4.14.1216 1,285 4/16/2021
2021.4.9.1538 1,262 4/13/2021
2021.4.8.947 1,311 4/13/2021
2021.4.6.1235 1,302 4/6/2021
2021.4.5.1653 1,268 4/5/2021
2021.4.1.913 1,260 4/1/2021
2021.3.31.2003 1,249 4/1/2021
2021.3.18.1622 1,342 3/18/2021
2021.3.3.1259 1,421 3/3/2021
2021.3.2.1415 1,400 3/2/2021
2021.3.1.11 1,345 2/28/2021
2021.3.1.1 1,403 2/27/2021
2021.3.1 1,369 2/27/2021
2021.2.23.6 1,338 2/23/2021
2021.2.21.1 1,263 2/21/2021
2021.2.20.1 1,286 2/20/2021
2021.2.19.2 1,263 2/19/2021
2021.2.18.6 1,333 2/19/2021
2021.2.17.1 1,427 2/17/2021
2021.2.16.1 1,445 2/16/2021
2021.2.15.3 1,411 2/15/2021
2021.2.15.1 1,384 2/14/2021
2021.2.14.3 1,400 2/14/2021
2021.2.12.6 1,318 2/12/2021
2021.2.12.2 1,390 2/12/2021
2021.2.11.1 1,377 2/11/2021
2021.2.10.1 1,474 2/10/2021
2021.2.8.1 1,468 2/9/2021
2021.2.7.2 1,477 2/7/2021
2021.2.7.1 1,331 2/6/2021
2020.12.27.6 1,486 12/27/2020
2020.12.27.1 1,372 12/27/2020
2020.12.26.7 1,372 12/27/2020
2020.12.26.5 1,407 12/27/2020
2020.12.26.3 1,345 12/27/2020
2020.12.19.1 1,618 12/19/2020
2020.12.16.1 1,399 12/16/2020
2020.12.15.1 1,329 12/15/2020
2020.12.14.5 1,367 12/14/2020
2020.12.14.4 1,461 12/14/2020
2020.12.14.3 1,452 12/14/2020
2020.12.4.4 1,449 12/4/2020
2020.12.4.3 1,454 12/4/2020
2020.12.3.1 1,446 12/3/2020
2020.12.2.4 1,385 12/2/2020
2020.12.2.3 1,504 12/2/2020
2020.12.1.1 1,458 12/1/2020
2020.11.28.1 1,508 11/28/2020
2020.11.27.2 1,465 11/27/2020
2020.11.27.1 1,415 11/27/2020
2020.11.25.1 1,382 11/25/2020
2020.11.22.3 1,443 11/23/2020
2020.11.20.1 1,543 11/21/2020
2020.11.19.3 1,516 11/19/2020
2020.11.19.1 1,509 11/19/2020
2020.11.18.2 1,491 11/18/2020
2020.11.17.2 1,512 11/17/2020
2020.11.17.1 1,477 11/17/2020
2020.11.15.1 1,410 11/15/2020
2020.11.14.1 1,601 11/14/2020
2020.11.13.3 1,661 11/14/2020
2020.11.13.2 1,347 11/13/2020
2020.11.13.1 1,452 11/13/2020
2020.11.12.1 1,492 11/12/2020
2020.11.11.1 1,489 11/11/2020
2020.11.8.1 1,555 11/8/2020
2020.11.7.1 1,431 11/7/2020
2020.11.5.1 1,497 11/5/2020
2020.11.3.1 1,448 11/3/2020
2020.11.1.3 1,458 11/1/2020
2020.11.1.2 1,495 11/1/2020
2020.11.1.1 1,505 11/1/2020
2020.10.30.1 1,458 11/1/2020
2020.10.15.3 1,420 10/15/2020
2020.10.15.2 1,534 10/15/2020
2020.10.14.1 1,480 10/14/2020
2020.10.13.1 1,475 10/13/2020
2020.10.12.2 1,469 10/12/2020
2020.10.12.1 1,469 10/12/2020
2020.10.10.1 1,601 10/10/2020
2020.10.9.6 1,377 10/9/2020
2020.10.9.2 1,443 10/9/2020
2020.10.9.1 1,476 10/9/2020
2020.10.8.1 1,471 10/8/2020
2020.10.6.8 1,575 10/7/2020
2020.10.6.6 1,544 10/7/2020
2020.10.6.5 1,448 10/7/2020
2020.10.6.4 1,429 10/7/2020
2020.10.6.3 1,459 10/7/2020
2020.10.6.2 1,363 10/7/2020
2020.10.6.1 1,465 10/7/2020
2020.10.5.1 1,579 10/6/2020
2020.10.1.3 1,375 10/1/2020
2020.10.1.2 1,418 10/1/2020
2020.10.1.1 1,515 10/1/2020
2020.9.29.10 1,555 9/29/2020
2020.9.29.9 1,497 9/29/2020
2020.9.28.2 1,408 9/28/2020
2020.9.28.1 1,449 9/28/2020
2020.9.25.1 1,642 9/26/2020
2020.9.24.2 1,400 9/24/2020
2020.9.24 1,457 9/24/2020
2020.9.23.2 1,443 9/23/2020
2020.9.23.1 1,446 9/23/2020
2020.9.22.1 1,392 9/22/2020
2020.9.21.1 1,516 9/21/2020
2020.9.17.2 1,454 9/17/2020
2020.9.16 1,491 9/16/2020
2020.9.15 1,501 9/15/2020
2020.9.9.2 1,433 9/9/2020
2020.9.8.1 1,428 9/8/2020
2020.9.6.5 1,535 9/6/2020
2020.9.4.2 1,439 9/4/2020
2020.9.4.1 1,454 9/4/2020
2020.9.4 1,407 9/4/2020
2020.9.3.1 1,421 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