Walter.Web.FireWall.SqlLogger 2020.10.14.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.10.14.1
                    
NuGet\Install-Package Walter.Web.FireWall.SqlLogger -Version 2020.10.14.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.10.14.1" />
                    
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.10.14.1" />
                    
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.10.14.1
                    
#r "nuget: Walter.Web.FireWall.SqlLogger, 2020.10.14.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.
#addin nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.10.14.1
                    
Install Walter.Web.FireWall.SqlLogger as a Cake Addin
#tool nuget:?package=Walter.Web.FireWall.SqlLogger&version=2020.10.14.1
                    
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 182 4/17/2025
2025.3.13.1323 141 3/13/2025
2025.2.26.1642 108 2/26/2025
2025.2.25.1033 102 2/26/2025
2025.2.24.1556 95 2/25/2025
2025.2.16.1149 114 2/19/2025
2025.2.15.1316 109 2/15/2025
2025.1.16.1410 87 1/16/2025
2025.1.4.1941 118 1/4/2025
2025.1.2.1544 131 1/3/2025
2024.12.14.838 96 12/14/2024
2024.12.13.1227 95 12/13/2024
2024.11.28.1632 91 11/28/2024
2024.11.20.644 116 11/21/2024
2024.11.15.421 105 11/15/2024
2024.11.11.1334 91 11/14/2024
2024.11.6.1222 113 11/6/2024
2024.10.28.1605 99 10/28/2024
2024.10.28.1335 99 10/28/2024
2024.10.19.1525 101 10/20/2024
2024.10.18.1315 122 10/18/2024
2024.9.27.1406 113 9/27/2024
2024.9.17.1417 139 9/17/2024
2024.9.12.1923 117 9/12/2024
2024.9.6.1352 122 9/7/2024
2024.9.1.1159 127 9/1/2024
2024.8.26.1150 144 8/26/2024
2024.8.19.1411 165 8/19/2024
2024.8.17.1000 129 8/17/2024
2024.8.12.1622 139 8/13/2024
2024.8.5.1010 103 8/5/2024
2024.8.1.1545 137 8/16/2024
2024.7.28.629 85 7/28/2024
2024.7.26.1512 89 7/26/2024
2024.7.26.828 89 7/26/2024
2024.7.11.1604 139 7/11/2024
2024.7.9.1520 121 7/9/2024
2024.7.4.1425 104 7/4/2024
2024.7.3.1249 104 7/3/2024
2024.7.2.1536 128 7/2/2024
2024.6.28.953 115 6/28/2024
2023.11.13.1117 649 11/13/2023
2023.10.26.1502 595 10/29/2023
2023.10.12.1926 605 10/12/2023
2023.9.14.812 700 9/14/2023
2023.9.7.1748 688 9/7/2023
2023.9.7.1241 682 9/7/2023
2023.9.6.1001 657 9/6/2023
2023.9.5.1246 678 9/5/2023
2023.9.5.1032 673 9/5/2023
2023.8.31.1522 654 8/31/2023
2023.8.29.1040 683 8/29/2023
2023.8.17.901 755 8/17/2023
2023.8.9.1314 785 8/9/2023
2023.8.2.750 778 8/2/2023
2023.7.12.830 794 7/12/2023
2023.7.5.1419 785 7/6/2023
2023.6.14.1628 853 6/14/2023
2023.6.11.1304 831 6/11/2023
2023.5.30.1640 822 5/30/2023
2023.5.4.1552 856 5/4/2023
2023.4.29.910 869 4/29/2023
2023.4.12.1236 931 4/12/2023
2023.3.22.1456 960 3/22/2023
2023.3.14.1356 977 3/14/2023
2023.3.1.810 901 3/1/2023
2023.2.25.11857 939 2/25/2023
2023.2.22.27 986 2/22/2023
2023.2.15.1413 963 2/15/2023
2023.2.11.1628 951 2/11/2023
2023.1.11.534 1,025 1/11/2023
2022.12.30.711 1,038 12/30/2022
2022.12.15.1108 1,040 12/15/2022
2022.12.14.648 1,000 12/14/2022
2022.11.27.1059 1,077 11/27/2022
2022.11.21.338 1,041 11/21/2022
2022.11.14.1819 1,117 11/14/2022
2022.11.13.917 1,046 11/13/2022
2022.10.31.740 1,118 11/1/2022
2022.10.15.652 1,229 10/15/2022
2022.10.1.810 1,213 10/1/2022
2022.9.26.1444 1,231 9/26/2022
2022.9.14.1508 1,246 9/14/2022
2022.9.14.809 1,302 9/14/2022
2022.9.8.1009 1,309 9/8/2022
2022.8.20.1007 1,263 8/20/2022
2022.8.1.1 1,241 7/31/2022
2022.7.1300 1,283 7/1/2022
2022.7.31.1016 1,210 7/31/2022
2022.7.15.841 1,298 7/15/2022
2022.6.21.647 1,285 6/21/2022
2022.5.18.638 1,296 5/19/2022
2022.5.16.853 1,288 5/19/2022
2022.5.16.816 1,313 5/16/2022
2022.5.4.1010 1,263 5/4/2022
2022.4.10.947 1,415 4/10/2022
2022.4.10.925 1,334 4/10/2022
2022.4.10.828 1,340 4/10/2022
2022.4.1.1545 1,382 4/1/2022
2022.3.26.1103 1,362 3/26/2022
2022.3.26.820 1,308 3/26/2022
2022.3.25.840 1,305 3/26/2022
2022.2.16.1131 1,352 2/17/2022
2022.2.16.834 1,352 2/17/2022
2022.2.5.1114 1,421 2/5/2022
2022.1.17.1158 1,389 1/17/2022
2022.1.10.1505 1,484 1/10/2022
2022.1.10.537 1,344 1/10/2022
2022.1.5.1139 1,175 1/8/2022
2021.12.28.1452 1,191 12/28/2021
2021.12.16.812 1,278 12/16/2021
2021.11.23.1528 7,465 11/24/2021
2021.11.21.925 1,331 11/22/2021
2021.11.19.1503 1,315 11/22/2021
2021.11.19.847 1,348 11/19/2021
2021.11.18.1824 1,320 11/16/2021
2021.11.10.852 1,286 11/10/2021
2021.11.9.2021 1,442 11/9/2021
2021.11.8.2109 1,278 11/9/2021
2021.11.8.1612 1,299 11/8/2021
2021.11.7.1021 1,335 11/8/2021
2021.11.3.1612 1,438 11/4/2021
2021.11.1.1102 1,312 11/1/2021
2021.10.25.1206 1,351 10/25/2021
2021.10.23.1310 1,355 10/25/2021
2021.10.19.1522 1,334 10/19/2021
2021.10.16.1325 1,243 10/18/2021
2021.10.9.1119 100 10/9/2024
2021.10.6.1546 1,328 10/6/2021
2021.10.5.1450 1,368 10/5/2021
2021.10.4.1155 1,382 10/5/2021
2021.10.1.753 1,447 10/1/2021
2021.9.27.1005 1,348 9/28/2021
2021.9.26.1913 1,352 9/26/2021
2021.9.19.1015 1,414 9/19/2021
2021.9.17.1702 1,291 9/17/2021
2021.9.17.1449 1,324 9/17/2021
2021.9.13.1600 1,417 9/13/2021
2021.9.9.1110 1,374 9/9/2021
2021.9.7.1901 1,243 9/8/2021
2021.9.7.1121 1,399 9/7/2021
2021.9.6.1518 1,289 9/7/2021
2021.9.4.1124 1,440 9/4/2021
2021.9.2.708 1,307 9/4/2021
2021.9.0.1259 1,287 9/2/2021
2021.8.2200 1,304 8/23/2021
2021.8.2100 1,390 8/23/2021
2021.8.22.900 1,416 8/22/2021
2021.8.18.1500 1,322 8/18/2021
2021.8.18.930 1,283 8/18/2021
2021.8.14.1600 1,305 8/16/2021
2021.8.9.1105 1,288 8/9/2021
2021.8.8.1612 1,258 8/8/2021
2021.8.8.1138 1,391 8/8/2021
2021.8.6.1044 1,417 8/6/2021
2021.8.4.1355 1,370 8/5/2021
2021.7.30.2118 1,375 7/31/2021
2021.7.27.926 1,359 7/28/2021
2021.7.23.931 1,324 7/26/2021
2021.7.22.1456 1,421 7/23/2021
2021.7.15.1547 1,395 7/15/2021
2021.7.13.812 1,390 7/13/2021
2021.7.8.1527 1,542 7/10/2021
2021.7.5.1649 1,403 7/5/2021
2021.6.29.1453 1,403 6/30/2021
2021.6.26.1753 1,518 6/27/2021
2021.6.25.1849 1,357 6/25/2021
2021.6.24.1518 1,414 6/24/2021
2021.6.20.729 1,319 6/20/2021
2021.6.15.2006 1,364 6/15/2021
2021.6.14.2025 1,431 6/15/2021
2021.6.13.2035 1,327 6/14/2021
2021.6.12.1154 1,273 6/13/2021
2021.6.9.1120 1,359 6/9/2021
2021.6.3.1509 1,357 6/3/2021
2021.5.31.1533 1,377 5/31/2021
2021.5.31.1415 1,424 5/31/2021
2021.5.25.1732 1,368 5/25/2021
2021.5.24.1128 1,359 5/24/2021
2021.5.24.1019 1,295 5/24/2021
2021.5.12.1054 1,298 5/12/2021
2021.5.12.637 1,267 5/12/2021
2021.5.10.1442 1,384 5/11/2021
2021.5.8.1226 1,301 5/8/2021
2021.5.6.2037 1,347 5/6/2021
2021.5.5.1901 1,392 5/6/2021
2021.5.3.1621 1,319 5/4/2021
2021.5.1.905 1,270 5/1/2021
2021.4.28.1511 1,349 4/28/2021
2021.4.20.1520 1,290 4/21/2021
2021.4.16.738 1,321 4/21/2021
2021.4.14.1216 1,334 4/16/2021
2021.4.9.1538 1,311 4/13/2021
2021.4.8.947 1,361 4/13/2021
2021.4.6.1235 1,352 4/6/2021
2021.4.5.1653 1,319 4/5/2021
2021.4.1.913 1,311 4/1/2021
2021.3.31.2003 1,301 4/1/2021
2021.3.18.1622 1,391 3/18/2021
2021.3.3.1259 1,473 3/3/2021
2021.3.2.1415 1,469 3/2/2021
2021.3.1.11 1,417 2/28/2021
2021.3.1.1 1,456 2/27/2021
2021.3.1 1,422 2/27/2021
2021.2.23.6 1,393 2/23/2021
2021.2.21.1 1,318 2/21/2021
2021.2.20.1 1,339 2/20/2021
2021.2.19.2 1,316 2/19/2021
2021.2.18.6 1,385 2/19/2021
2021.2.17.1 1,481 2/17/2021
2021.2.16.1 1,497 2/16/2021
2021.2.15.3 1,481 2/15/2021
2021.2.15.1 1,436 2/14/2021
2021.2.14.3 1,452 2/14/2021
2021.2.12.6 1,391 2/12/2021
2021.2.12.2 1,443 2/12/2021
2021.2.11.1 1,431 2/11/2021
2021.2.10.1 1,526 2/10/2021
2021.2.8.1 1,522 2/9/2021
2021.2.7.2 1,530 2/7/2021
2021.2.7.1 1,385 2/6/2021
2020.12.27.6 1,541 12/27/2020
2020.12.27.1 1,424 12/27/2020
2020.12.26.7 1,427 12/27/2020
2020.12.26.5 1,461 12/27/2020
2020.12.26.3 1,401 12/27/2020
2020.12.19.1 1,670 12/19/2020
2020.12.16.1 1,452 12/16/2020
2020.12.15.1 1,387 12/15/2020
2020.12.14.5 1,422 12/14/2020
2020.12.14.4 1,514 12/14/2020
2020.12.14.3 1,507 12/14/2020
2020.12.4.4 1,504 12/4/2020
2020.12.4.3 1,509 12/4/2020
2020.12.3.1 1,499 12/3/2020
2020.12.2.4 1,440 12/2/2020
2020.12.2.3 1,557 12/2/2020
2020.12.1.1 1,513 12/1/2020
2020.11.28.1 1,561 11/28/2020
2020.11.27.2 1,519 11/27/2020
2020.11.27.1 1,468 11/27/2020
2020.11.25.1 1,437 11/25/2020
2020.11.22.3 1,498 11/23/2020
2020.11.20.1 1,597 11/21/2020
2020.11.19.3 1,569 11/19/2020
2020.11.19.1 1,563 11/19/2020
2020.11.18.2 1,545 11/18/2020
2020.11.17.2 1,567 11/17/2020
2020.11.17.1 1,530 11/17/2020
2020.11.15.1 1,466 11/15/2020
2020.11.14.1 1,655 11/14/2020
2020.11.13.3 1,712 11/14/2020
2020.11.13.2 1,401 11/13/2020
2020.11.13.1 1,506 11/13/2020
2020.11.12.1 1,546 11/12/2020
2020.11.11.1 1,543 11/11/2020
2020.11.8.1 1,608 11/8/2020
2020.11.7.1 1,486 11/7/2020
2020.11.5.1 1,552 11/5/2020
2020.11.3.1 1,503 11/3/2020
2020.11.1.3 1,522 11/1/2020
2020.11.1.2 1,557 11/1/2020
2020.11.1.1 1,559 11/1/2020
2020.10.30.1 1,511 11/1/2020
2020.10.15.3 1,471 10/15/2020
2020.10.15.2 1,587 10/15/2020
2020.10.14.1 1,535 10/14/2020
2020.10.13.1 1,527 10/13/2020
2020.10.12.2 1,521 10/12/2020
2020.10.12.1 1,523 10/12/2020
2020.10.10.1 1,653 10/10/2020
2020.10.9.6 1,429 10/9/2020
2020.10.9.2 1,496 10/9/2020
2020.10.9.1 1,527 10/9/2020
2020.10.8.1 1,522 10/8/2020
2020.10.6.8 1,626 10/7/2020
2020.10.6.6 1,596 10/7/2020
2020.10.6.5 1,499 10/7/2020
2020.10.6.4 1,480 10/7/2020
2020.10.6.3 1,510 10/7/2020
2020.10.6.2 1,414 10/7/2020
2020.10.6.1 1,518 10/7/2020
2020.10.5.1 1,630 10/6/2020
2020.10.1.3 1,427 10/1/2020
2020.10.1.2 1,470 10/1/2020
2020.10.1.1 1,566 10/1/2020
2020.9.29.10 1,609 9/29/2020
2020.9.29.9 1,548 9/29/2020
2020.9.28.2 1,460 9/28/2020
2020.9.28.1 1,504 9/28/2020
2020.9.25.1 1,694 9/26/2020
2020.9.24.2 1,451 9/24/2020
2020.9.24 1,509 9/24/2020
2020.9.23.2 1,495 9/23/2020
2020.9.23.1 1,510 9/23/2020
2020.9.22.1 1,443 9/22/2020
2020.9.21.1 1,569 9/21/2020
2020.9.17.2 1,505 9/17/2020
2020.9.16 1,543 9/16/2020
2020.9.15 1,552 9/15/2020
2020.9.9.2 1,485 9/9/2020
2020.9.8.1 1,481 9/8/2020
2020.9.6.5 1,586 9/6/2020
2020.9.4.2 1,491 9/4/2020
2020.9.4.1 1,544 9/4/2020
2020.9.4 1,503 9/4/2020
2020.9.3.1 1,473 9/3/2020

14 October 2020
     - Update to .net core 3.1.4
     
     12 October 2020
     - Implement changed database reporting interface

     05 October 2020
     - Update terms
     - update NuGet package references

     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