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

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

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.9.17.1417 61 9/17/2024
2024.9.12.1923 69 9/12/2024
2024.9.6.1352 74 9/7/2024
2024.9.1.1159 79 9/1/2024
2024.8.26.1150 91 8/26/2024
2024.8.19.1411 107 8/19/2024
2024.8.17.1000 93 8/17/2024
2024.8.12.1622 106 8/13/2024
2024.8.5.1010 68 8/5/2024
2024.8.1.1545 98 8/16/2024
2024.7.28.629 50 7/28/2024
2024.7.26.1512 58 7/26/2024
2024.7.26.828 50 7/26/2024
2024.7.11.1604 74 7/11/2024
2024.7.9.1520 81 7/9/2024
2024.7.4.1425 68 7/4/2024
2024.7.3.1249 75 7/3/2024
2024.7.2.1536 96 7/2/2024
2024.6.28.953 77 6/28/2024
2023.11.13.1117 617 11/13/2023
2023.10.26.1502 545 10/29/2023
2023.10.12.1926 574 10/12/2023
2023.9.14.812 663 9/14/2023
2023.9.7.1748 652 9/7/2023
2023.9.7.1241 653 9/7/2023
2023.9.6.1001 620 9/6/2023
2023.9.5.1246 648 9/5/2023
2023.9.5.1032 637 9/5/2023
2023.8.31.1522 624 8/31/2023
2023.8.29.1040 651 8/29/2023
2023.8.17.901 724 8/17/2023
2023.8.9.1314 749 8/9/2023
2023.8.2.750 745 8/2/2023
2023.7.12.830 753 7/12/2023
2023.7.5.1419 742 7/6/2023
2023.6.14.1628 801 6/14/2023
2023.6.11.1304 793 6/11/2023
2023.5.30.1640 778 5/30/2023
2023.5.4.1552 809 5/4/2023
2023.4.29.910 830 4/29/2023
2023.4.12.1236 882 4/12/2023
2023.3.22.1456 917 3/22/2023
2023.3.14.1356 918 3/14/2023
2023.3.1.810 848 3/1/2023
2023.2.25.11857 879 2/25/2023
2023.2.22.27 939 2/22/2023
2023.2.15.1413 911 2/15/2023
2023.2.11.1628 905 2/11/2023
2023.1.11.534 977 1/11/2023
2022.12.30.711 997 12/30/2022
2022.12.15.1108 993 12/15/2022
2022.12.14.648 940 12/14/2022
2022.11.27.1059 1,029 11/27/2022
2022.11.21.338 993 11/21/2022
2022.11.14.1819 1,069 11/14/2022
2022.11.13.917 1,000 11/13/2022
2022.10.31.740 1,070 11/1/2022
2022.10.15.652 1,182 10/15/2022
2022.10.1.810 1,136 10/1/2022
2022.9.26.1444 1,179 9/26/2022
2022.9.14.1508 1,198 9/14/2022
2022.9.14.809 1,253 9/14/2022
2022.9.8.1009 1,255 9/8/2022
2022.8.20.1007 1,211 8/20/2022
2022.8.1.1 1,189 7/31/2022
2022.7.1300 1,231 7/1/2022
2022.7.31.1016 1,164 7/31/2022
2022.7.15.841 1,252 7/15/2022
2022.6.21.647 1,212 6/21/2022
2022.5.18.638 1,215 5/19/2022
2022.5.16.853 1,217 5/19/2022
2022.5.16.816 1,260 5/16/2022
2022.5.4.1010 1,207 5/4/2022
2022.4.10.947 1,350 4/10/2022
2022.4.10.925 1,279 4/10/2022
2022.4.10.828 1,288 4/10/2022
2022.4.1.1545 1,320 4/1/2022
2022.3.26.1103 1,280 3/26/2022
2022.3.26.820 1,257 3/26/2022
2022.3.25.840 1,254 3/26/2022
2022.2.16.1131 1,282 2/17/2022
2022.2.16.834 1,291 2/17/2022
2022.2.5.1114 1,358 2/5/2022
2022.1.17.1158 1,321 1/17/2022
2022.1.10.1505 1,426 1/10/2022
2022.1.10.537 1,266 1/10/2022
2022.1.5.1139 1,115 1/8/2022
2021.12.28.1452 1,136 12/28/2021
2021.12.16.812 1,218 12/16/2021
2021.11.23.1528 7,402 11/24/2021
2021.11.21.925 1,221 11/22/2021
2021.11.19.1503 1,251 11/22/2021
2021.11.19.847 1,290 11/19/2021
2021.11.18.1824 1,262 11/16/2021
2021.11.10.852 1,231 11/10/2021
2021.11.9.2021 1,384 11/9/2021
2021.11.8.2109 1,194 11/9/2021
2021.11.8.1612 1,237 11/8/2021
2021.11.7.1021 1,278 11/8/2021
2021.11.3.1612 1,374 11/4/2021
2021.11.1.1102 1,227 11/1/2021
2021.10.25.1206 1,272 10/25/2021
2021.10.23.1310 1,291 10/25/2021
2021.10.19.1522 1,262 10/19/2021
2021.10.16.1325 1,182 10/18/2021
2021.10.6.1546 1,242 10/6/2021
2021.10.5.1450 1,291 10/5/2021
2021.10.4.1155 1,323 10/5/2021
2021.10.1.753 1,391 10/1/2021
2021.9.27.1005 1,285 9/28/2021
2021.9.26.1913 1,287 9/26/2021
2021.9.19.1015 1,349 9/19/2021
2021.9.17.1702 1,229 9/17/2021
2021.9.17.1449 1,260 9/17/2021
2021.9.13.1600 1,355 9/13/2021
2021.9.9.1110 1,308 9/9/2021
2021.9.7.1901 1,179 9/8/2021
2021.9.7.1121 1,329 9/7/2021
2021.9.6.1518 1,219 9/7/2021
2021.9.4.1124 1,349 9/4/2021
2021.9.2.708 1,250 9/4/2021
2021.9.0.1259 1,220 9/2/2021
2021.8.2200 1,224 8/23/2021
2021.8.2100 1,286 8/23/2021
2021.8.22.900 1,342 8/22/2021
2021.8.18.1500 1,261 8/18/2021
2021.8.18.930 1,217 8/18/2021
2021.8.14.1600 1,241 8/16/2021
2021.8.9.1105 1,215 8/9/2021
2021.8.8.1612 1,173 8/8/2021
2021.8.8.1138 1,328 8/8/2021
2021.8.6.1044 1,354 8/6/2021
2021.8.4.1355 1,314 8/5/2021
2021.7.30.2118 1,297 7/31/2021
2021.7.27.926 1,302 7/28/2021
2021.7.23.931 1,238 7/26/2021
2021.7.22.1456 1,339 7/23/2021
2021.7.15.1547 1,333 7/15/2021
2021.7.13.812 1,329 7/13/2021
2021.7.8.1527 1,477 7/10/2021
2021.7.5.1649 1,344 7/5/2021
2021.6.29.1453 1,337 6/30/2021
2021.6.26.1753 1,459 6/27/2021
2021.6.25.1849 1,293 6/25/2021
2021.6.24.1518 1,346 6/24/2021
2021.6.20.729 1,263 6/20/2021
2021.6.15.2006 1,301 6/15/2021
2021.6.14.2025 1,372 6/15/2021
2021.6.13.2035 1,261 6/14/2021
2021.6.12.1154 1,210 6/13/2021
2021.6.9.1120 1,293 6/9/2021
2021.6.3.1509 1,290 6/3/2021
2021.5.31.1533 1,310 5/31/2021
2021.5.31.1415 1,357 5/31/2021
2021.5.25.1732 1,300 5/25/2021
2021.5.24.1128 1,302 5/24/2021
2021.5.24.1019 1,231 5/24/2021
2021.5.12.1054 1,231 5/12/2021
2021.5.12.637 1,209 5/12/2021
2021.5.10.1442 1,325 5/11/2021
2021.5.8.1226 1,234 5/8/2021
2021.5.6.2037 1,281 5/6/2021
2021.5.5.1901 1,327 5/6/2021
2021.5.3.1621 1,243 5/4/2021
2021.5.1.905 1,195 5/1/2021
2021.4.28.1511 1,238 4/28/2021
2021.4.20.1520 1,215 4/21/2021
2021.4.16.738 1,260 4/21/2021
2021.4.14.1216 1,272 4/16/2021
2021.4.9.1538 1,224 4/13/2021
2021.4.8.947 1,294 4/13/2021
2021.4.6.1235 1,278 4/6/2021
2021.4.5.1653 1,250 4/5/2021
2021.4.1.913 1,248 4/1/2021
2021.3.31.2003 1,225 4/1/2021
2021.3.18.1622 1,319 3/18/2021
2021.3.3.1259 1,392 3/3/2021
2021.3.2.1415 1,364 3/2/2021
2021.3.1.11 1,332 2/28/2021
2021.3.1.1 1,384 2/27/2021
2021.3.1 1,356 2/27/2021
2021.2.23.6 1,326 2/23/2021
2021.2.21.1 1,246 2/21/2021
2021.2.20.1 1,273 2/20/2021
2021.2.19.2 1,250 2/19/2021
2021.2.18.6 1,316 2/19/2021
2021.2.17.1 1,414 2/17/2021
2021.2.16.1 1,427 2/16/2021
2021.2.15.3 1,398 2/15/2021
2021.2.15.1 1,363 2/14/2021
2021.2.14.3 1,380 2/14/2021
2021.2.12.6 1,296 2/12/2021
2021.2.12.2 1,364 2/12/2021
2021.2.11.1 1,365 2/11/2021
2021.2.10.1 1,447 2/10/2021
2021.2.8.1 1,452 2/9/2021
2021.2.7.2 1,445 2/7/2021
2021.2.7.1 1,318 2/6/2021
2020.12.27.6 1,467 12/27/2020
2020.12.27.1 1,359 12/27/2020
2020.12.26.7 1,360 12/27/2020
2020.12.26.5 1,394 12/27/2020
2020.12.26.3 1,332 12/27/2020
2020.12.19.1 1,600 12/19/2020
2020.12.16.1 1,381 12/16/2020
2020.12.15.1 1,311 12/15/2020
2020.12.14.5 1,347 12/14/2020
2020.12.14.4 1,442 12/14/2020
2020.12.14.3 1,440 12/14/2020
2020.12.4.4 1,437 12/4/2020
2020.12.4.3 1,437 12/4/2020
2020.12.3.1 1,433 12/3/2020
2020.12.2.4 1,367 12/2/2020
2020.12.2.3 1,475 12/2/2020
2020.12.1.1 1,441 12/1/2020
2020.11.28.1 1,486 11/28/2020
2020.11.27.2 1,445 11/27/2020
2020.11.27.1 1,398 11/27/2020
2020.11.25.1 1,362 11/25/2020
2020.11.22.3 1,430 11/23/2020
2020.11.20.1 1,517 11/21/2020
2020.11.19.3 1,477 11/19/2020
2020.11.19.1 1,496 11/19/2020
2020.11.18.2 1,473 11/18/2020
2020.11.17.2 1,487 11/17/2020
2020.11.17.1 1,455 11/17/2020
2020.11.15.1 1,391 11/15/2020
2020.11.14.1 1,588 11/14/2020
2020.11.13.3 1,614 11/14/2020
2020.11.13.2 1,318 11/13/2020
2020.11.13.1 1,431 11/13/2020
2020.11.12.1 1,470 11/12/2020
2020.11.11.1 1,459 11/11/2020
2020.11.8.1 1,536 11/8/2020
2020.11.7.1 1,412 11/7/2020
2020.11.5.1 1,473 11/5/2020
2020.11.3.1 1,409 11/3/2020
2020.11.1.3 1,410 11/1/2020
2020.11.1.2 1,471 11/1/2020
2020.11.1.1 1,478 11/1/2020
2020.10.30.1 1,421 11/1/2020
2020.10.15.3 1,399 10/15/2020
2020.10.15.2 1,493 10/15/2020
2020.10.14.1 1,450 10/14/2020
2020.10.13.1 1,461 10/13/2020
2020.10.12.2 1,445 10/12/2020
2020.10.12.1 1,405 10/12/2020
2020.10.10.1 1,581 10/10/2020
2020.10.9.6 1,364 10/9/2020
2020.10.9.2 1,423 10/9/2020
2020.10.9.1 1,456 10/9/2020
2020.10.8.1 1,458 10/8/2020
2020.10.6.8 1,541 10/7/2020
2020.10.6.6 1,520 10/7/2020
2020.10.6.5 1,433 10/7/2020
2020.10.6.4 1,409 10/7/2020
2020.10.6.3 1,446 10/7/2020
2020.10.6.2 1,344 10/7/2020
2020.10.6.1 1,446 10/7/2020
2020.10.5.1 1,553 10/6/2020
2020.10.1.3 1,340 10/1/2020
2020.10.1.2 1,397 10/1/2020
2020.10.1.1 1,498 10/1/2020
2020.9.29.10 1,523 9/29/2020
2020.9.29.9 1,484 9/29/2020
2020.9.28.2 1,395 9/28/2020
2020.9.28.1 1,436 9/28/2020
2020.9.25.1 1,600 9/26/2020
2020.9.24.2 1,371 9/24/2020
2020.9.24 1,433 9/24/2020
2020.9.23.2 1,422 9/23/2020
2020.9.23.1 1,418 9/23/2020
2020.9.22.1 1,365 9/22/2020
2020.9.21.1 1,481 9/21/2020
2020.9.17.2 1,409 9/17/2020
2020.9.16 1,459 9/16/2020
2020.9.15 1,488 9/15/2020
2020.9.9.2 1,415 9/9/2020
2020.9.8.1 1,407 9/8/2020
2020.9.6.5 1,515 9/6/2020
2020.9.4.2 1,421 9/4/2020
2020.9.4.1 1,413 9/4/2020
2020.9.4 1,387 9/4/2020
2020.9.3.1 1,395 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