Walter.Web.FireWall.SqlLogger 2020.9.16

Prefix Reserved
.NET Core 3.0 This package targets .NET Core 3.0. The package is compatible with this framework or higher. .NET Standard 2.1 This package targets .NET Standard 2.1. The package is compatible with this framework or higher.
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.16                

                    
                

            
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.9.16
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.16" />
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.16                

                    
                

            
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.9.16"
#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.16

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

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.7.11.1604 63 7/11/2024
2024.7.9.1520 73 7/9/2024
2024.7.4.1425 59 7/4/2024
2024.7.3.1249 68 7/3/2024
2024.7.2.1536 88 7/2/2024
2024.6.28.953 72 6/28/2024
2023.11.13.1117 609 11/13/2023
2023.10.26.1502 537 10/29/2023
2023.10.12.1926 567 10/12/2023
2023.9.14.812 658 9/14/2023
2023.9.7.1748 645 9/7/2023
2023.9.7.1241 647 9/7/2023
2023.9.6.1001 614 9/6/2023
2023.9.5.1246 642 9/5/2023
2023.9.5.1032 629 9/5/2023
2023.8.31.1522 620 8/31/2023
2023.8.29.1040 645 8/29/2023
2023.8.17.901 712 8/17/2023
2023.8.9.1314 744 8/9/2023
2023.8.2.750 735 8/2/2023
2023.7.12.830 749 7/12/2023
2023.7.5.1419 737 7/6/2023
2023.6.14.1628 795 6/14/2023
2023.6.11.1304 789 6/11/2023
2023.5.30.1640 773 5/30/2023
2023.5.4.1552 807 5/4/2023
2023.4.29.910 826 4/29/2023
2023.4.12.1236 876 4/12/2023
2023.3.22.1456 912 3/22/2023
2023.3.14.1356 917 3/14/2023
2023.3.1.810 845 3/1/2023
2023.2.25.11857 875 2/25/2023
2023.2.22.27 934 2/22/2023
2023.2.15.1413 908 2/15/2023
2023.2.11.1628 900 2/11/2023
2023.1.11.534 971 1/11/2023
2022.12.30.711 991 12/30/2022
2022.12.15.1108 987 12/15/2022
2022.12.14.648 936 12/14/2022
2022.11.27.1059 1,024 11/27/2022
2022.11.21.338 986 11/21/2022
2022.11.14.1819 1,064 11/14/2022
2022.11.13.917 994 11/13/2022
2022.10.31.740 1,066 11/1/2022
2022.10.15.652 1,178 10/15/2022
2022.10.1.810 1,133 10/1/2022
2022.9.26.1444 1,175 9/26/2022
2022.9.14.1508 1,192 9/14/2022
2022.9.14.809 1,249 9/14/2022
2022.9.8.1009 1,252 9/8/2022
2022.8.20.1007 1,206 8/20/2022
2022.8.1.1 1,184 7/31/2022
2022.7.1300 1,226 7/1/2022
2022.7.31.1016 1,159 7/31/2022
2022.7.15.841 1,246 7/15/2022
2022.6.21.647 1,207 6/21/2022
2022.5.18.638 1,210 5/19/2022
2022.5.16.853 1,214 5/19/2022
2022.5.16.816 1,256 5/16/2022
2022.5.4.1010 1,203 5/4/2022
2022.4.10.947 1,346 4/10/2022
2022.4.10.925 1,276 4/10/2022
2022.4.10.828 1,284 4/10/2022
2022.4.1.1545 1,318 4/1/2022
2022.3.26.1103 1,276 3/26/2022
2022.3.26.820 1,251 3/26/2022
2022.3.25.840 1,245 3/26/2022
2022.2.16.1131 1,275 2/17/2022
2022.2.16.834 1,287 2/17/2022
2022.2.5.1114 1,350 2/5/2022
2022.1.17.1158 1,313 1/17/2022
2022.1.10.1505 1,423 1/10/2022
2022.1.10.537 1,260 1/10/2022
2022.1.5.1139 1,112 1/8/2022
2021.12.28.1452 1,134 12/28/2021
2021.12.16.812 1,206 12/16/2021
2021.11.23.1528 7,399 11/24/2021
2021.11.21.925 1,215 11/22/2021
2021.11.19.1503 1,246 11/22/2021
2021.11.19.847 1,288 11/19/2021
2021.11.18.1824 1,251 11/16/2021
2021.11.10.852 1,230 11/10/2021
2021.11.9.2021 1,382 11/9/2021
2021.11.8.2109 1,189 11/9/2021
2021.11.8.1612 1,232 11/8/2021
2021.11.7.1021 1,276 11/8/2021
2021.11.3.1612 1,372 11/4/2021
2021.11.1.1102 1,222 11/1/2021
2021.10.25.1206 1,270 10/25/2021
2021.10.23.1310 1,286 10/25/2021
2021.10.19.1522 1,257 10/19/2021
2021.10.16.1325 1,176 10/18/2021
2021.10.6.1546 1,239 10/6/2021
2021.10.5.1450 1,288 10/5/2021
2021.10.4.1155 1,320 10/5/2021
2021.10.1.753 1,386 10/1/2021
2021.9.27.1005 1,283 9/28/2021
2021.9.26.1913 1,285 9/26/2021
2021.9.19.1015 1,338 9/19/2021
2021.9.17.1702 1,227 9/17/2021
2021.9.17.1449 1,255 9/17/2021
2021.9.13.1600 1,350 9/13/2021
2021.9.9.1110 1,303 9/9/2021
2021.9.7.1901 1,173 9/8/2021
2021.9.7.1121 1,323 9/7/2021
2021.9.6.1518 1,213 9/7/2021
2021.9.4.1124 1,346 9/4/2021
2021.9.2.708 1,245 9/4/2021
2021.9.0.1259 1,217 9/2/2021
2021.8.2200 1,221 8/23/2021
2021.8.2100 1,282 8/23/2021
2021.8.22.900 1,335 8/22/2021
2021.8.18.1500 1,257 8/18/2021
2021.8.18.930 1,213 8/18/2021
2021.8.14.1600 1,226 8/16/2021
2021.8.9.1105 1,212 8/9/2021
2021.8.8.1612 1,167 8/8/2021
2021.8.8.1138 1,324 8/8/2021
2021.8.6.1044 1,346 8/6/2021
2021.8.4.1355 1,308 8/5/2021
2021.7.30.2118 1,295 7/31/2021
2021.7.27.926 1,297 7/28/2021
2021.7.23.931 1,233 7/26/2021
2021.7.22.1456 1,330 7/23/2021
2021.7.15.1547 1,328 7/15/2021
2021.7.13.812 1,326 7/13/2021
2021.7.8.1527 1,475 7/10/2021
2021.7.5.1649 1,342 7/5/2021
2021.6.29.1453 1,333 6/30/2021
2021.6.26.1753 1,455 6/27/2021
2021.6.25.1849 1,291 6/25/2021
2021.6.24.1518 1,338 6/24/2021
2021.6.20.729 1,261 6/20/2021
2021.6.15.2006 1,299 6/15/2021
2021.6.14.2025 1,352 6/15/2021
2021.6.13.2035 1,259 6/14/2021
2021.6.12.1154 1,200 6/13/2021
2021.6.9.1120 1,289 6/9/2021
2021.6.3.1509 1,286 6/3/2021
2021.5.31.1533 1,307 5/31/2021
2021.5.31.1415 1,353 5/31/2021
2021.5.25.1732 1,290 5/25/2021
2021.5.24.1128 1,296 5/24/2021
2021.5.24.1019 1,227 5/24/2021
2021.5.12.1054 1,227 5/12/2021
2021.5.12.637 1,205 5/12/2021
2021.5.10.1442 1,319 5/11/2021
2021.5.8.1226 1,232 5/8/2021
2021.5.6.2037 1,277 5/6/2021
2021.5.5.1901 1,323 5/6/2021
2021.5.3.1621 1,237 5/4/2021
2021.5.1.905 1,192 5/1/2021
2021.4.28.1511 1,234 4/28/2021
2021.4.20.1520 1,211 4/21/2021
2021.4.16.738 1,258 4/21/2021
2021.4.14.1216 1,270 4/16/2021
2021.4.9.1538 1,222 4/13/2021
2021.4.8.947 1,290 4/13/2021
2021.4.6.1235 1,276 4/6/2021
2021.4.5.1653 1,248 4/5/2021
2021.4.1.913 1,246 4/1/2021
2021.3.31.2003 1,221 4/1/2021
2021.3.18.1622 1,318 3/18/2021
2021.3.3.1259 1,389 3/3/2021
2021.3.2.1415 1,361 3/2/2021
2021.3.1.11 1,331 2/28/2021
2021.3.1.1 1,368 2/27/2021
2021.3.1 1,336 2/27/2021
2021.2.23.6 1,325 2/23/2021
2021.2.21.1 1,243 2/21/2021
2021.2.20.1 1,269 2/20/2021
2021.2.19.2 1,242 2/19/2021
2021.2.18.6 1,314 2/19/2021
2021.2.17.1 1,412 2/17/2021
2021.2.16.1 1,417 2/16/2021
2021.2.15.3 1,395 2/15/2021
2021.2.15.1 1,360 2/14/2021
2021.2.14.3 1,379 2/14/2021
2021.2.12.6 1,293 2/12/2021
2021.2.12.2 1,362 2/12/2021
2021.2.11.1 1,361 2/11/2021
2021.2.10.1 1,443 2/10/2021
2021.2.8.1 1,450 2/9/2021
2021.2.7.2 1,442 2/7/2021
2021.2.7.1 1,313 2/6/2021
2020.12.27.6 1,458 12/27/2020
2020.12.27.1 1,355 12/27/2020
2020.12.26.7 1,355 12/27/2020
2020.12.26.5 1,391 12/27/2020
2020.12.26.3 1,327 12/27/2020
2020.12.19.1 1,598 12/19/2020
2020.12.16.1 1,379 12/16/2020
2020.12.15.1 1,308 12/15/2020
2020.12.14.5 1,342 12/14/2020
2020.12.14.4 1,439 12/14/2020
2020.12.14.3 1,439 12/14/2020
2020.12.4.4 1,433 12/4/2020
2020.12.4.3 1,435 12/4/2020
2020.12.3.1 1,431 12/3/2020
2020.12.2.4 1,365 12/2/2020
2020.12.2.3 1,471 12/2/2020
2020.12.1.1 1,439 12/1/2020
2020.11.28.1 1,484 11/28/2020
2020.11.27.2 1,443 11/27/2020
2020.11.27.1 1,394 11/27/2020
2020.11.25.1 1,358 11/25/2020
2020.11.22.3 1,426 11/23/2020
2020.11.20.1 1,513 11/21/2020
2020.11.19.3 1,473 11/19/2020
2020.11.19.1 1,492 11/19/2020
2020.11.18.2 1,469 11/18/2020
2020.11.17.2 1,485 11/17/2020
2020.11.17.1 1,453 11/17/2020
2020.11.15.1 1,389 11/15/2020
2020.11.14.1 1,586 11/14/2020
2020.11.13.3 1,612 11/14/2020
2020.11.13.2 1,316 11/13/2020
2020.11.13.1 1,427 11/13/2020
2020.11.12.1 1,468 11/12/2020
2020.11.11.1 1,457 11/11/2020
2020.11.8.1 1,532 11/8/2020
2020.11.7.1 1,402 11/7/2020
2020.11.5.1 1,469 11/5/2020
2020.11.3.1 1,401 11/3/2020
2020.11.1.3 1,405 11/1/2020
2020.11.1.2 1,466 11/1/2020
2020.11.1.1 1,475 11/1/2020
2020.10.30.1 1,418 11/1/2020
2020.10.15.3 1,397 10/15/2020
2020.10.15.2 1,490 10/15/2020
2020.10.14.1 1,444 10/14/2020
2020.10.13.1 1,457 10/13/2020
2020.10.12.2 1,430 10/12/2020
2020.10.12.1 1,401 10/12/2020
2020.10.10.1 1,569 10/10/2020
2020.10.9.6 1,359 10/9/2020
2020.10.9.2 1,418 10/9/2020
2020.10.9.1 1,445 10/9/2020
2020.10.8.1 1,456 10/8/2020
2020.10.6.8 1,536 10/7/2020
2020.10.6.6 1,518 10/7/2020
2020.10.6.5 1,431 10/7/2020
2020.10.6.4 1,407 10/7/2020
2020.10.6.3 1,444 10/7/2020
2020.10.6.2 1,340 10/7/2020
2020.10.6.1 1,442 10/7/2020
2020.10.5.1 1,550 10/6/2020
2020.10.1.3 1,338 10/1/2020
2020.10.1.2 1,392 10/1/2020
2020.10.1.1 1,493 10/1/2020
2020.9.29.10 1,521 9/29/2020
2020.9.29.9 1,481 9/29/2020
2020.9.28.2 1,390 9/28/2020
2020.9.28.1 1,431 9/28/2020
2020.9.25.1 1,594 9/26/2020
2020.9.24.2 1,368 9/24/2020
2020.9.24 1,422 9/24/2020
2020.9.23.2 1,418 9/23/2020
2020.9.23.1 1,414 9/23/2020
2020.9.22.1 1,359 9/22/2020
2020.9.21.1 1,473 9/21/2020
2020.9.17.2 1,404 9/17/2020
2020.9.16 1,454 9/16/2020
2020.9.15 1,485 9/15/2020
2020.9.9.2 1,412 9/9/2020
2020.9.8.1 1,403 9/8/2020
2020.9.6.5 1,511 9/6/2020
2020.9.4.2 1,419 9/4/2020
2020.9.4.1 1,409 9/4/2020
2020.9.4 1,384 9/4/2020
2020.9.3.1 1,391 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