Walter.DataTools.MsSql 2021.6.9.1120

Package used by Firewall products for interacting with sql server and is used to create and apply updates to database DDL objects
This package will be re-factored in the future separating base classes into a new package and have the MSSQL and MySql in their own packages.

Install-Package Walter.DataTools.MsSql -Version 2021.6.9.1120
dotnet add package Walter.DataTools.MsSql --version 2021.6.9.1120
<PackageReference Include="Walter.DataTools.MsSql" Version="2021.6.9.1120" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Walter.DataTools.MsSql --version 2021.6.9.1120
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Walter.DataTools.MsSql, 2021.6.9.1120"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Walter.DataTools.MsSql as a Cake Addin
#addin nuget:?package=Walter.DataTools.MsSql&version=2021.6.9.1120

// Install Walter.DataTools.MsSql as a Cake Tool
#tool nuget:?package=Walter.DataTools.MsSql&version=2021.6.9.1120
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Major releases that add functionality other than optimization and minor bug fixing
     09 June 2021
     - Update to .Net SDK 5.0.301 and 3.1.410
     
     07 June 2021      
     - Update NuGet Package references
     
     
     25 May 2021
     - Add event monitoring failed statements
     - Write update log when failed statements changed
     - Add TableRow extension method to read simple data types
     
     12 April 2021
     - Update to new code base after .net security violation fix
     
     05 April 2021
     - Update trigger for data migration
     
     22 March 2021
     - performance update

     15 March 2021
     - Add additional data access methods

     05 March 2021
     - Refactoring code

     12 February 2021
     - Framework extension changes
     - Update package references

     25 January 2021
     - update package references
     - update storage initialization

     02 January 2021
     - Updated terms and conditions to REL. 2021.01.02
     - Add classes for data state reporting

     29 December 2020
     - Extend Storage interface and Documentation interfaces

     23 December 2020
     - TSqlResult properties added
     - Extend interface IDatabaseTools


     19-20 December 2020
     - Update package references

     14 December 2020
     - Update package references
     - Update TSqlResult data source result

     11 December 2020
     - Update package references
     - Compile with Language version 9.0

     04 December 2020
     - Extend TSqlResult class to allow for better logging of exceptions using a new exceptions class TSqlResultException
     - Update package references

     01 December 2020
     - Capture server and database name on loose executions that return a TsqlResult.

     22 November 2020
     - Update compiler hints improving .net Core 3.1 and .Net 5.0 compiled binaries

     11 November 2020
     - Update packages and support .Net 5.0

     08 November 2020
     - Update signatures and NuGet package references

     14 October 2020
     - Update to .net core 3.1.4

     06 October 2020
     1. Add DebuggerDisplay to TSqlResult

     05 October 2020
     1. Update NuGet Package References
     2. Update EULA

     17. September 2020
     - Package refactoring and package renaming
     - Update documentation

     11 June 2020 release
     - Add Ticket service for incident reporting when the 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

     24 May 2020 changes in 1.0.0.3
     - Add logging via DIContainer

NuGet packages (6)

Showing the top 5 NuGet packages that depend on Walter.DataTools.MsSql:

Package Downloads
Walter.Net.LookWhosTalking
Provide insight into the communication between the server hosting the website and the outside world and allows the users to observe communication and look for irrational or known malicious interaction. The static class that exposes this functionality can be found at Walter.Net.LookWhosTalking.WhosTalking Documentation available at https://firewallapi.asp-waf.com/?topic=html/N-Walter.Net.LookWhosTalking.htm
Walter.Web.FireWall.SqlLogger
Package that enable SQL Server database storage and logging to NuGet package Walter.Web.Firewall The NuGet package is easily activated by dependency injection during service configuration services.AddFireWall(FireWallTrial.License, FireWallTrial.DomainKey , domainName: new Uri("https://www.your-domain.com", UriKind.Absolute) , options => { //your firewall settings }).UseDataBase(ConfigurationManager.ConnectionStrings["FireWallState"].ConnectionString) .UseFireWallReportingDatabase(ConfigurationManager.ConnectionStrings["FireWallReporting"].ConnectionString); More information on how to use this Add-On is available in this manual https://www.asp-waf.com/download/ASP-WAF-FireWall-Getting-Started.pdf as well as on-line at https://www.asp-waf.com/NuGet
Walter.Web.FireWall.SMTPLogger
The Package adds E-Mail based reporting functionality to NuGet package Walter.Web.Firewall and allows for the logging of incidents via E-Mail by using a E-Mail buffer and sends the emails at configured intervals. The NuGet package is easily activated by dependency injection during service configuration services.AddFireWall(FireWallTrial.License, FireWallTrial.DomainKey , domainName: new Uri("https://www.your-domain.com", UriKind.Absolute) , options => { //your firewall settings }).UseSMTPReportingDatabase(options =>{ options.Archive = TimeSpan.FromDays(180); options.Server = "mail.server.com"; options.UserName = "noreply@your-domain.com"; options.Password = "pa$$w0rd1234"; options.Port = 8889; options.From = "noreply@your-domain.com"; options.IgnoreServerCertificateErrors = true; options.DefaultEmail = "webmaster@your-domain.com"; options.Archive = TimeSpan.FromDays(60); options.MailingList.AddRange(new[] { new EMailAddress("Security Admin","security@your-domain.com") { Frequency= TimeSpan.FromHours(1), Roles= EMailRoles.FireWallAdministrationViolations | EMailRoles.UnauthorizedPhysicalFilesViolation }, new EMailAddress("WAF","info@your-domain.com"){ Frequency= TimeSpan.FromHours(1), Roles= EMailRoles.ProductUpdates | EMailRoles.OwnAccountRelatedViolations } , }); }); More information on how to use this Add-On is available in this manual https://www.asp-waf.com/download/ASP-WAF-FireWall-Getting-Started.pdf as well as on-line at https://www.asp-waf.com/NuGet
Walter.Web.FireWall
The application firewall that can be used in .NET 5.0, .Net CORE 3.1 and .NET standard 2.1 applications that would benefit for protection against several types of attacks and is easily activated by service integration. services.AddFireWall(FireWallTrial.License, FireWallTrial.DomainKey , domainName: new Uri("https://www.your-domain.com", UriKind.Absolute) , options => { //your options }); Have a look at the GitHub samples at https://github.com/ASP-WAF/FireWall and https://github.com/ASP-WAF/FireWall/wiki to see how to use the firewall in applications. You can view the firewall in action using https://www.asp-waf.com/Firewall You can get started with the firewall using the samples shown in https://www.asp-waf.com/download/ASP-WAF-FireWall-Getting-Started.pdf as well as the on line documentation at https://firewallapi.asp-waf.com/
Walter.Web.FireWall.CookieStore
Cookie store for use with the firewall allowing to not store any GDPR data in cookies but keep all references local. You can read and write these cookies using the User in the page request object that is injected in all your controllers. To integrate the Cookie Store database use the UseDBCookieStore extension method as shown bellow services.AddFireWall(FireWallTrial.License, FireWallTrial.DomainKey , domainName: new Uri("https://www.your-domain.com", UriKind.Absolute) , options => { //your firewall settings }).UseDBCookieStore(); You can see how to use it using this online documentation here: https://firewallapi.asp-waf.com/?topic=html/Overload-Walter.Web.FireWall.IUserIdentity.WriteCookie.htm Read about reading such a cookie is documented here: https://firewallapi.asp-waf.com/?topic=html/M-Walter.Web.FireWall.IUserIdentity.TryReadCookie.htm

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
2021.6.9.1120 20 6/9/2021
2021.6.7.2103 34 6/7/2021
2021.6.3.1509 440 6/3/2021
2021.5.31.1533 393 5/31/2021
2021.5.31.1415 450 5/31/2021
2021.5.25.1732 432 5/25/2021
2021.5.24.1128 538 5/24/2021
2021.5.24.1019 423 5/24/2021
2021.5.12.1054 157 5/12/2021
2021.5.12.637 131 5/12/2021
2021.5.10.1442 160 5/11/2021
2021.5.8.1226 151 5/8/2021
2021.5.6.2037 154 5/6/2021
2021.5.5.1901 160 5/6/2021
2021.5.3.1621 153 5/4/2021
2021.5.1.905 231 5/1/2021
2021.4.28.1511 226 4/28/2021
2021.4.20.1520 251 4/21/2021
2021.4.16.738 237 4/21/2021
2021.4.15.9 64 4/16/2021
2021.4.14.1216 300 4/16/2021
2021.4.9.1538 310 4/13/2021
2021.4.8.947 301 4/13/2021
2021.4.6.1235 271 4/6/2021
2021.4.5.1653 292 4/5/2021
2021.4.1.913 277 4/1/2021
2021.3.31.2003 303 4/1/2021
2021.3.18.1622 287 3/18/2021
2021.3.3.1259 293 3/3/2021
2021.3.2.1415 252 3/2/2021
2021.3.1.11 288 2/28/2021
2021.3.1.1 291 2/27/2021
2021.3.1 280 2/27/2021
2021.2.23.6 228 2/23/2021
2021.2.21.1 282 2/21/2021
2021.2.20.1 285 2/20/2021
2021.2.19.2 319 2/19/2021
2021.2.18.6 285 2/19/2021
2021.2.17.1 322 2/17/2021
2021.2.16.1 336 2/16/2021
2021.2.15.3 327 2/15/2021
2021.2.15.1 357 2/14/2021
2021.2.14.3 345 2/14/2021
2021.2.12.6 338 2/12/2021
2021.2.12.2 346 2/12/2021
2021.2.11.1 283 2/11/2021
2021.2.10.1 295 2/10/2021
2021.2.8.1 361 2/9/2021
2021.2.7.1 572 2/6/2021
2020.12.27.6 427 12/27/2020
2020.12.27.1 387 12/27/2020
2020.12.26.7 368 12/27/2020
2020.12.26.5 399 12/27/2020
2020.12.26.3 397 12/27/2020
2020.12.19.1 463 12/19/2020
2020.12.16.1 378 12/16/2020
2020.12.15.1 365 12/15/2020
2020.12.14.5 487 12/14/2020
2020.12.14.4 368 12/14/2020
2020.12.14.3 369 12/14/2020
2020.12.5 380 12/5/2020
2020.12.4.1 613 12/4/2020
2020.12.4 328 12/4/2020
2020.12.2.3 872 12/2/2020
2020.12.1 420 12/1/2020
2020.11.28 432 11/28/2020
2020.11.27.2 360 11/27/2020
2020.11.25.1 529 11/25/2020
2020.11.22.3 369 11/23/2020
2020.11.20.1 443 11/21/2020
2020.11.19.3 374 11/19/2020
2020.11.18.1 657 11/18/2020
2020.11.15.1 850 11/15/2020
2020.11.11.1 1,375 11/11/2020
2020.11.8.1 525 11/8/2020
2020.11.5.1 744 11/5/2020
2020.11.3.1 446 11/3/2020
2020.10.30.1 1,394 11/1/2020
2020.10.15.3 457 10/15/2020
2020.10.15.2 441 10/15/2020
2020.10.14.1 450 10/14/2020
2020.10.13.1 466 10/13/2020
2020.10.12.2 537 10/12/2020
2020.10.12.1 425 10/12/2020
2020.10.10.1 604 10/10/2020
2020.10.9.6 446 10/9/2020
2020.10.9.5 158 10/9/2020
2020.10.9.2 295 10/9/2020
2020.10.9.1 439 10/9/2020
2020.10.8.1 440 10/8/2020
2020.10.6.8 451 10/7/2020
2020.10.6.7 161 10/7/2020
2020.10.6.6 449 10/7/2020
2020.10.6.5 475 10/7/2020
2020.10.6.4 419 10/7/2020
2020.10.6.3 491 10/7/2020
2020.10.6.1 756 10/7/2020
2020.10.5.1 485 10/6/2020
2020.10.1.3 423 10/1/2020
2020.10.1.2 399 10/1/2020
2020.10.1.1 379 10/1/2020
2020.9.29.10 453 9/29/2020
2020.9.29.9 533 9/29/2020
2020.9.28.1 746 9/28/2020
2020.9.25.1 579 9/26/2020
2020.9.24.2 443 9/24/2020
2020.9.24 442 9/24/2020
2020.9.23.2 426 9/23/2020
2020.9.23.1 417 9/23/2020
2020.9.22.1 671 9/22/2020
2020.9.17.3 134 9/17/2020
2020.9.17.2 421 9/17/2020