Walter.Web.FireWall.SqlLogger 2020.9.29.9

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.29.9
                    
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.9.29.9
                    
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.29.9" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Walter.Web.FireWall.SqlLogger" Version="2020.9.29.9" />
                    
Directory.Packages.props
<PackageReference Include="Walter.Web.FireWall.SqlLogger" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Walter.Web.FireWall.SqlLogger --version 2020.9.29.9
                    
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.9.29.9"
                    
#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.
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.29.9
                    
Install Walter.Web.FireWall.SqlLogger as a Cake Addin
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.9.29.9
                    
Install Walter.Web.FireWall.SqlLogger as a Cake Tool

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.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.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.4.17.1816 180 4/17/2025
2025.3.13.1323 140 3/13/2025
2025.2.26.1642 107 2/26/2025
2025.2.25.1033 100 2/26/2025
2025.2.24.1556 94 2/25/2025
2025.2.16.1149 113 2/19/2025
2025.2.15.1316 108 2/15/2025
2025.1.16.1410 86 1/16/2025
2025.1.4.1941 116 1/4/2025
2025.1.2.1544 128 1/3/2025
2024.12.14.838 94 12/14/2024
2024.12.13.1227 93 12/13/2024
2024.11.28.1632 89 11/28/2024
2024.11.20.644 114 11/21/2024
2024.11.15.421 103 11/15/2024
2024.11.11.1334 89 11/14/2024
2024.11.6.1222 111 11/6/2024
2024.10.28.1605 97 10/28/2024
2024.10.28.1335 97 10/28/2024
2024.10.19.1525 99 10/20/2024
2024.10.18.1315 120 10/18/2024
2024.9.27.1406 109 9/27/2024
2024.9.17.1417 137 9/17/2024
2024.9.12.1923 115 9/12/2024
2024.9.6.1352 120 9/7/2024
2024.9.1.1159 125 9/1/2024
2024.8.26.1150 142 8/26/2024
2024.8.19.1411 161 8/19/2024
2024.8.17.1000 127 8/17/2024
2024.8.12.1622 137 8/13/2024
2024.8.5.1010 101 8/5/2024
2024.8.1.1545 135 8/16/2024
2024.7.28.629 83 7/28/2024
2024.7.26.1512 87 7/26/2024
2024.7.26.828 87 7/26/2024
2024.7.11.1604 137 7/11/2024
2024.7.9.1520 119 7/9/2024
2024.7.4.1425 102 7/4/2024
2024.7.3.1249 102 7/3/2024
2024.7.2.1536 126 7/2/2024
2024.6.28.953 113 6/28/2024
2023.11.13.1117 647 11/13/2023
2023.10.26.1502 593 10/29/2023
2023.10.12.1926 603 10/12/2023
2023.9.14.812 698 9/14/2023
2023.9.7.1748 686 9/7/2023
2023.9.7.1241 680 9/7/2023
2023.9.6.1001 655 9/6/2023
2023.9.5.1246 676 9/5/2023
2023.9.5.1032 671 9/5/2023
2023.8.31.1522 652 8/31/2023
2023.8.29.1040 681 8/29/2023
2023.8.17.901 753 8/17/2023
2023.8.9.1314 783 8/9/2023
2023.8.2.750 776 8/2/2023
2023.7.12.830 792 7/12/2023
2023.7.5.1419 784 7/6/2023
2023.6.14.1628 851 6/14/2023
2023.6.11.1304 829 6/11/2023
2023.5.30.1640 821 5/30/2023
2023.5.4.1552 855 5/4/2023
2023.4.29.910 868 4/29/2023
2023.4.12.1236 930 4/12/2023
2023.3.22.1456 959 3/22/2023
2023.3.14.1356 976 3/14/2023
2023.3.1.810 900 3/1/2023
2023.2.25.11857 938 2/25/2023
2023.2.22.27 985 2/22/2023
2023.2.15.1413 962 2/15/2023
2023.2.11.1628 950 2/11/2023
2023.1.11.534 1,024 1/11/2023
2022.12.30.711 1,037 12/30/2022
2022.12.15.1108 1,039 12/15/2022
2022.12.14.648 999 12/14/2022
2022.11.27.1059 1,076 11/27/2022
2022.11.21.338 1,040 11/21/2022
2022.11.14.1819 1,116 11/14/2022
2022.11.13.917 1,045 11/13/2022
2022.10.31.740 1,117 11/1/2022
2022.10.15.652 1,228 10/15/2022
2022.10.1.810 1,212 10/1/2022
2022.9.26.1444 1,229 9/26/2022
2022.9.14.1508 1,245 9/14/2022
2022.9.14.809 1,301 9/14/2022
2022.9.8.1009 1,308 9/8/2022
2022.8.20.1007 1,262 8/20/2022
2022.8.1.1 1,239 7/31/2022
2022.7.1300 1,282 7/1/2022
2022.7.31.1016 1,209 7/31/2022
2022.7.15.841 1,296 7/15/2022
2022.6.21.647 1,284 6/21/2022
2022.5.18.638 1,295 5/19/2022
2022.5.16.853 1,287 5/19/2022
2022.5.16.816 1,312 5/16/2022
2022.5.4.1010 1,261 5/4/2022
2022.4.10.947 1,413 4/10/2022
2022.4.10.925 1,332 4/10/2022
2022.4.10.828 1,338 4/10/2022
2022.4.1.1545 1,380 4/1/2022
2022.3.26.1103 1,360 3/26/2022
2022.3.26.820 1,306 3/26/2022
2022.3.25.840 1,303 3/26/2022
2022.2.16.1131 1,350 2/17/2022
2022.2.16.834 1,350 2/17/2022
2022.2.5.1114 1,419 2/5/2022
2022.1.17.1158 1,387 1/17/2022
2022.1.10.1505 1,482 1/10/2022
2022.1.10.537 1,342 1/10/2022
2022.1.5.1139 1,173 1/8/2022
2021.12.28.1452 1,189 12/28/2021
2021.12.16.812 1,276 12/16/2021
2021.11.23.1528 7,463 11/24/2021
2021.11.21.925 1,329 11/22/2021
2021.11.19.1503 1,313 11/22/2021
2021.11.19.847 1,346 11/19/2021
2021.11.18.1824 1,318 11/16/2021
2021.11.10.852 1,284 11/10/2021
2021.11.9.2021 1,440 11/9/2021
2021.11.8.2109 1,276 11/9/2021
2021.11.8.1612 1,297 11/8/2021
2021.11.7.1021 1,333 11/8/2021
2021.11.3.1612 1,436 11/4/2021
2021.11.1.1102 1,310 11/1/2021
2021.10.25.1206 1,349 10/25/2021
2021.10.23.1310 1,353 10/25/2021
2021.10.19.1522 1,332 10/19/2021
2021.10.16.1325 1,241 10/18/2021
2021.10.9.1119 98 10/9/2024
2021.10.6.1546 1,326 10/6/2021
2021.10.5.1450 1,366 10/5/2021
2021.10.4.1155 1,380 10/5/2021
2021.10.1.753 1,445 10/1/2021
2021.9.27.1005 1,346 9/28/2021
2021.9.26.1913 1,350 9/26/2021
2021.9.19.1015 1,412 9/19/2021
2021.9.17.1702 1,289 9/17/2021
2021.9.17.1449 1,322 9/17/2021
2021.9.13.1600 1,415 9/13/2021
2021.9.9.1110 1,372 9/9/2021
2021.9.7.1901 1,241 9/8/2021
2021.9.7.1121 1,397 9/7/2021
2021.9.6.1518 1,287 9/7/2021
2021.9.4.1124 1,438 9/4/2021
2021.9.2.708 1,305 9/4/2021
2021.9.0.1259 1,285 9/2/2021
2021.8.2200 1,302 8/23/2021
2021.8.2100 1,388 8/23/2021
2021.8.22.900 1,414 8/22/2021
2021.8.18.1500 1,320 8/18/2021
2021.8.18.930 1,281 8/18/2021
2021.8.14.1600 1,303 8/16/2021
2021.8.9.1105 1,285 8/9/2021
2021.8.8.1612 1,256 8/8/2021
2021.8.8.1138 1,389 8/8/2021
2021.8.6.1044 1,415 8/6/2021
2021.8.4.1355 1,368 8/5/2021
2021.7.30.2118 1,373 7/31/2021
2021.7.27.926 1,357 7/28/2021
2021.7.23.931 1,322 7/26/2021
2021.7.22.1456 1,419 7/23/2021
2021.7.15.1547 1,393 7/15/2021
2021.7.13.812 1,388 7/13/2021
2021.7.8.1527 1,540 7/10/2021
2021.7.5.1649 1,401 7/5/2021
2021.6.29.1453 1,401 6/30/2021
2021.6.26.1753 1,516 6/27/2021
2021.6.25.1849 1,355 6/25/2021
2021.6.24.1518 1,412 6/24/2021
2021.6.20.729 1,317 6/20/2021
2021.6.15.2006 1,362 6/15/2021
2021.6.14.2025 1,428 6/15/2021
2021.6.13.2035 1,324 6/14/2021
2021.6.12.1154 1,270 6/13/2021
2021.6.9.1120 1,356 6/9/2021
2021.6.3.1509 1,354 6/3/2021
2021.5.31.1533 1,374 5/31/2021
2021.5.31.1415 1,421 5/31/2021
2021.5.25.1732 1,365 5/25/2021
2021.5.24.1128 1,356 5/24/2021
2021.5.24.1019 1,292 5/24/2021
2021.5.12.1054 1,295 5/12/2021
2021.5.12.637 1,264 5/12/2021
2021.5.10.1442 1,381 5/11/2021
2021.5.8.1226 1,298 5/8/2021
2021.5.6.2037 1,344 5/6/2021
2021.5.5.1901 1,389 5/6/2021
2021.5.3.1621 1,316 5/4/2021
2021.5.1.905 1,267 5/1/2021
2021.4.28.1511 1,346 4/28/2021
2021.4.20.1520 1,287 4/21/2021
2021.4.16.738 1,318 4/21/2021
2021.4.14.1216 1,331 4/16/2021
2021.4.9.1538 1,308 4/13/2021
2021.4.8.947 1,358 4/13/2021
2021.4.6.1235 1,349 4/6/2021
2021.4.5.1653 1,316 4/5/2021
2021.4.1.913 1,308 4/1/2021
2021.3.31.2003 1,298 4/1/2021
2021.3.18.1622 1,388 3/18/2021
2021.3.3.1259 1,470 3/3/2021
2021.3.2.1415 1,466 3/2/2021
2021.3.1.11 1,414 2/28/2021
2021.3.1.1 1,453 2/27/2021
2021.3.1 1,419 2/27/2021
2021.2.23.6 1,390 2/23/2021
2021.2.21.1 1,315 2/21/2021
2021.2.20.1 1,336 2/20/2021
2021.2.19.2 1,313 2/19/2021
2021.2.18.6 1,382 2/19/2021
2021.2.17.1 1,478 2/17/2021
2021.2.16.1 1,494 2/16/2021
2021.2.15.3 1,478 2/15/2021
2021.2.15.1 1,433 2/14/2021
2021.2.14.3 1,449 2/14/2021
2021.2.12.6 1,388 2/12/2021
2021.2.12.2 1,440 2/12/2021
2021.2.11.1 1,428 2/11/2021
2021.2.10.1 1,523 2/10/2021
2021.2.8.1 1,519 2/9/2021
2021.2.7.2 1,527 2/7/2021
2021.2.7.1 1,382 2/6/2021
2020.12.27.6 1,538 12/27/2020
2020.12.27.1 1,421 12/27/2020
2020.12.26.7 1,424 12/27/2020
2020.12.26.5 1,458 12/27/2020
2020.12.26.3 1,398 12/27/2020
2020.12.19.1 1,667 12/19/2020
2020.12.16.1 1,449 12/16/2020
2020.12.15.1 1,384 12/15/2020
2020.12.14.5 1,419 12/14/2020
2020.12.14.4 1,511 12/14/2020
2020.12.14.3 1,504 12/14/2020
2020.12.4.4 1,501 12/4/2020
2020.12.4.3 1,506 12/4/2020
2020.12.3.1 1,496 12/3/2020
2020.12.2.4 1,437 12/2/2020
2020.12.2.3 1,554 12/2/2020
2020.12.1.1 1,510 12/1/2020
2020.11.28.1 1,558 11/28/2020
2020.11.27.2 1,516 11/27/2020
2020.11.27.1 1,465 11/27/2020
2020.11.25.1 1,434 11/25/2020
2020.11.22.3 1,495 11/23/2020
2020.11.20.1 1,594 11/21/2020
2020.11.19.3 1,566 11/19/2020
2020.11.19.1 1,560 11/19/2020
2020.11.18.2 1,542 11/18/2020
2020.11.17.2 1,564 11/17/2020
2020.11.17.1 1,527 11/17/2020
2020.11.15.1 1,463 11/15/2020
2020.11.14.1 1,651 11/14/2020
2020.11.13.3 1,709 11/14/2020
2020.11.13.2 1,397 11/13/2020
2020.11.13.1 1,503 11/13/2020
2020.11.12.1 1,543 11/12/2020
2020.11.11.1 1,540 11/11/2020
2020.11.8.1 1,605 11/8/2020
2020.11.7.1 1,483 11/7/2020
2020.11.5.1 1,549 11/5/2020
2020.11.3.1 1,500 11/3/2020
2020.11.1.3 1,519 11/1/2020
2020.11.1.2 1,554 11/1/2020
2020.11.1.1 1,556 11/1/2020
2020.10.30.1 1,508 11/1/2020
2020.10.15.3 1,468 10/15/2020
2020.10.15.2 1,584 10/15/2020
2020.10.14.1 1,532 10/14/2020
2020.10.13.1 1,524 10/13/2020
2020.10.12.2 1,518 10/12/2020
2020.10.12.1 1,520 10/12/2020
2020.10.10.1 1,650 10/10/2020
2020.10.9.6 1,426 10/9/2020
2020.10.9.2 1,493 10/9/2020
2020.10.9.1 1,524 10/9/2020
2020.10.8.1 1,519 10/8/2020
2020.10.6.8 1,623 10/7/2020
2020.10.6.6 1,593 10/7/2020
2020.10.6.5 1,496 10/7/2020
2020.10.6.4 1,477 10/7/2020
2020.10.6.3 1,507 10/7/2020
2020.10.6.2 1,411 10/7/2020
2020.10.6.1 1,514 10/7/2020
2020.10.5.1 1,627 10/6/2020
2020.10.1.3 1,424 10/1/2020
2020.10.1.2 1,467 10/1/2020
2020.10.1.1 1,563 10/1/2020
2020.9.29.10 1,606 9/29/2020
2020.9.29.9 1,545 9/29/2020
2020.9.28.2 1,457 9/28/2020
2020.9.28.1 1,501 9/28/2020
2020.9.25.1 1,691 9/26/2020
2020.9.24.2 1,448 9/24/2020
2020.9.24 1,506 9/24/2020
2020.9.23.2 1,492 9/23/2020
2020.9.23.1 1,507 9/23/2020
2020.9.22.1 1,440 9/22/2020
2020.9.21.1 1,566 9/21/2020
2020.9.17.2 1,502 9/17/2020
2020.9.16 1,540 9/16/2020
2020.9.15 1,549 9/15/2020
2020.9.9.2 1,482 9/9/2020
2020.9.8.1 1,477 9/8/2020
2020.9.6.5 1,583 9/6/2020
2020.9.4.2 1,488 9/4/2020
2020.9.4.1 1,543 9/4/2020
2020.9.4 1,502 9/4/2020
2020.9.3.1 1,470 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